PDA

View Full Version : Mondrian can;t process query inside Saiku2, datasource from Hive2



rbondar
08-08-2013, 08:32 AM
Hi team,

Looks like i experienced another issue ^)
Mondrian can;t process query.

The most interesting part of log is :

at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.olap4j.OlapException: mondrian gave exception while executing query
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:762)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:421)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)
at org.saiku.olap.query.OlapQuery.execute(OlapQuery.java:201)
at org.saiku.service.olap.OlapQueryService.execute(OlapQueryService.java:208)
... 86 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select NON EMPTY {Hierarchize({[fee].[fee].Members})} ON COLUMNS,
NON EMPTY Crossjoin([id].[id].Members, {[Measures].[amt]}) ON ROWS
from [hive_acq_data_sample_duplicate]
]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:967)
at mondrian.olap.Util.newInternal(Util.java:2323)


Full stacktrace in attachment.