[Mondrian] Mondrian Fails even with latest Hive Dialect

[Venkatesh U]

Hi,

 Versions: mondrian-3.3.0.14703 and hive-0.7.1-cdh3u3
Jdbc driver used:
http://repository.pentaho.org/artifactory/pentaho/org/apache/hadoop/hive/hive-jdbc/0.7.0-pentaho-SNAPSHOT/hive-jdbc-0.7.0-pentaho-SNAPSHOT.jar

The Generated SQL is not Hive complaint. The sql is not running in hive.
Please confirm if this is a bug, then i will log it in the jira

Error Stack:

mondrian.olap.MondrianException: Mondrian
Error:java.util.concurrent.ExecutionException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while
executing query [select {[Measures]} ON COLUMNS from [Test_cube] ] at
mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:152)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:580) at
mondrian.rolap.RolapConnection.execute(RolapConnection.java:565) at
mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:92)
at mondrian.web.servlet.MdxQueryServlet.doGet(MdxQueryServlet.java:241) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662) Caused by:
java.util.concurrent.ExecutionException: mondrian.olap.MondrianException:
Mondrian Error:Internal error: Error while executing query [select
{[Measures]} ON COLUMNS from [Test_cube] ] at
java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at
java.util.concurrent.FutureTask.get(FutureTask.java:83) at
mondrian.rolap.RolapResultShepherd.shepherdExecution(RolapResultShepherd.java:126)
... 22 more Caused by: mondrian.olap.MondrianException: Mondrian
Error:Internal error: Error while executing query [select {[Measures]} ON
COLUMNS from [Test_cube] ] at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at
mondrian.olap.Util.newInternal(Util.java:2038) at
mondrian.olap.Util.newError(Util.java:2054) at
mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:667) at
mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at
mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586) at
mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585) at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at
java.util.concurrent.FutureTask.run(FutureTask.java:138) ... 3 more Caused
by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while loading segment; sql=[select sum('test_fact'.'fact_1') as 'm0' from
'test_fact' as 'test_fact'] at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at
mondrian.olap.Util.newInternal(Util.java:2038) at
mondrian.olap.Util.newError(Util.java:2054) at
mondrian.rolap.SqlStatement.handle(SqlStatement.java:294) at
mondrian.rolap.SqlStatement.execute(SqlStatement.java:206) at
mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:279) at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:672)
at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:121) at
mondrian.rolap.agg.Aggregation.load(Aggregation.java:180) at
mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:98)
at
mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:471)
at
mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:406)
at
mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:182)
at
mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:163)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:811) at
mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at
mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:633)
... 8 more Caused by: java.sql.SQLException: Query returned non-zero code:
11, cause: FAILED: Parse Error: line 1:23 mismatched input ''fact_1''
expecting Identifier near '.' in expression specification at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:161) ... 20 more
java.util.concurrent.ExecutionException: mondrian.olap.MondrianException:
Mondrian Error:Internal error: Error while executing query [select
{[Measures]} ON COLUMNS from [Test_cube] ]mondrian.olap.MondrianException:
Mondrian Error:Internal error: Error while executing query [select
{[Measures]} ON COLUMNS from [Test_cube] ] at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at
mondrian.olap.Util.newInternal(Util.java:2038) at
mondrian.olap.Util.newError(Util.java:2054) at
mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:667) at
mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at
mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586) at
mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585) at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at
java.util.concurrent.FutureTask.run(FutureTask.java:138) at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662) Caused by:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while
loading segment; sql=[select sum('test_fact'.'fact_1') as 'm0' from
'test_fact' as 'test_fact'] at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at
mondrian.olap.Util.newInternal(Util.java:2038) at
mondrian.olap.Util.newError(Util.java:2054) at
mondrian.rolap.SqlStatement.handle(SqlStatement.java:294) at
mondrian.rolap.SqlStatement.execute(SqlStatement.java:206) at
mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:279) at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:672)
at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:121) at
mondrian.rolap.agg.Aggregation.load(Aggregation.java:180) at
mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:98)
at
mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:471)
at
mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:406)
at
mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:182)
at
mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:163)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:811) at
mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at
mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:633)
... 8 more Caused by: java.sql.SQLException: Query returned non-zero code:
11, cause: FAILED: Parse Error: line 1:23 mismatched input ''fact_1''
expecting Identifier near '.' in expression specification at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:161) ... 20 more
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while
loading segment; sql=[select sum('test_fact'.'fact_1') as 'm0' from
'test_fact' as 'test_fact'] at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:912) at
mondrian.olap.Util.newInternal(Util.java:2038) at
mondrian.olap.Util.newError(Util.java:2054) at
mondrian.rolap.SqlStatement.handle(SqlStatement.java:294) at
mondrian.rolap.SqlStatement.execute(SqlStatement.java:206) at
mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:279) at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:672)
at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:121) at
mondrian.rolap.agg.Aggregation.load(Aggregation.java:180) at
mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:98)
at
mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:471)
at
mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:406)
at
mondrian.rolap.FastBatchingCellReader.loadAggregation(FastBatchingCellReader.java:182)
at
mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:163)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:811) at
mondrian.rolap.RolapResult.<init>(RolapResult.java:445) at
mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:633) at
mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at
mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586) at
mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585) at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at
java.util.concurrent.FutureTask.run(FutureTask.java:138) at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException:
Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:23
mismatched input ''fact_1'' expecting Identifier near '.' in expression
specification at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:161) ... 20 more
Query returned non-zero code: 11, cause: FAILED: Parse Error: line 1:23
mismatched input ''fact_1'' expecting Identifier near '.' in expression
specification
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20120301/03102f99/attachment.html