Hello all,<div><br></div><div>I'm sure someone has seen this before, so hopefully this will be easy to answer.</div><div><br></div><div>I'm trying to hook up Mondrian to Hive. I noticed that there is a HiveDialect implementation, but that it was not listed in the META-INF/services/mondrian.spi.Dialect file in the 3.4.1 release. I've tried several methods for adding it (described below), but I keep feeling the following error:</div>
<div><br></div><div><div>Main error</div><div>mondrian.olap.MondrianException: Mondrian Error:Internal error: while quoting identifier</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942)</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.olap.Util.newInternal(Util.java:2261)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.impl.JdbcDialectImpl.deduceIdentifierQuoteString(JdbcDialectImpl.java:179)</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.impl.JdbcDialectImpl.<init>(JdbcDialectImpl.java:113)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.DialectManager$DialectManagerImpl$1.createDialect(DialectManager.java:173)</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:278)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.DialectManager$CachingDialectFactory.createDialect(DialectManager.java:377)</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.DialectManager$DialectManagerImpl.createDialect(DialectManager.java:237)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.DialectManager.createDialect(DialectManager.java:80)</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.test.loader.MondrianFoodMartLoader.load(MondrianFoodMartLoader.java:380)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.test.loader.MondrianFoodMartLoader.main(MondrianFoodMartLoader.java:342)</div>
<div>Caused by: java.sql.SQLException: Method not supported</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>at org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.getIdentifierQuoteString(HiveDatabaseMetaData.java:356)</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>at mondrian.spi.impl.JdbcDialectImpl.deduceIdentifierQuoteString(JdbcDialectImpl.java:172)</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>... 8 more</div>
</div><div><br></div><div>I believe this indicates that the default JdbcDialectImpl is being used instead of the HiveDialect, but I can't seem to figure out why or how to fix it. I tried unpacking mondian.jar, adding a line for the HiveDialect, and re-packing it. I have also tried re-building Mondrian from scratch with that line added to the build's version of the file, also with no success.</div>
<div><br></div><div>I know that my JDBC parameters are correct, because I can see Mondrian connecting to Hive, but because Hive's JDBC driver is not full-featured (thus the need for the HiveDialect), I keep getting this failure.</div>
<div><br></div><div>Any pointers or help on this would be much appreciated!</div><div><br></div><div>Thanks!</div><div>Craig</div><div><br></div><div><br></div>