<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">It sure looks like a bug.<div><br></div><div>I'm not an expert on Hive SQL syntax. What SQL do you think should be generated?</div><div><br></div><div>Log a jira case please, and post a link to the case to this list.</div><div><br></div><div>Julian</div><div><br><div><div>On Mar 1, 2012, at 1:22 AM, Venkatesh U wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><span style="">Hi,</span></div><div><span style=""><br></span></div><span style=""> Versions: mondrian-3.3.0.14703</span><span style=""> and hive-0.7.1-cdh3u3</span><div><span style="">Jdbc driver used: </span><a href="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" target="_blank" style="">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</a></div>
<div><br></div><div>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</div><div><br></div><div>Error Stack: </div><div><br></div><div>
<span style="font-family:monospace;white-space:pre;font-size:medium">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</span></div>
_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>http://lists.pentaho.org/mailman/listinfo/mondrian<br></blockquote></div><br></div></body></html>