[Mondrian] Mondrian Fails even with latest Hive Dialect

[Julian Hyde]

It sure looks like a bug.

I'm not an expert on Hive SQL syntax. What SQL do you think should be generated?

Log a jira case please, and post a link to the case to this list.

Julian

On Mar 1, 2012, at 1:22 AM, Venkatesh U wrote:

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
_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20120301/f4579f2c/attachment-0001.html