[Mondrian] Mondrian with Hive

Venkatesh U venkatesh.umaashankar at gmail.com
Wed Feb 29 11:49:35 EST 2012


Hi,
 I have downloaded the latest version of mondrian-3.3.0.14703
and hive-0.7.1-cdh3u3. My hive server is running and i have defined a
simple schema. But the jdbc connection does not seem to work.

Here are the steps i followed,

-> I copied $HIVE_HOME/lib/*jar to mondrian-webapp/WEB-INF/lib and also
created a symobolic link to $HIVE_HOME/conf
in mondrian-webapp/WEB-INF/classes directory
-> copied hadoop*core*jar to WEB-INF/lib
-> Modified web.xml as below

 <context-param>
    <param-name>connectString</param-name>

<param-value>Provider=mondrian;Jdbc=jdbc:hive://localhost:9999/default;Catalog=/WEB-INF/queries/TestHive.xml;JdbcDrivers=org.apache.hadoop.hive.jdbc.HiveDriver</param-value>
  </context-param>

but I am getting the below error

Results: Error:


mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while creating SQL connection: Jdbc=jdbc:hive://localhost:9999/default
	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.<init>(RolapConnection.java:232)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:195)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:239)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:60)
	at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:1121)
	at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:913)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:151)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:87)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:71)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:53)
	at mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:90)
	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: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool exhausted
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:212)
	... 30 more
Caused by: java.util.NoSuchElementException: Could not create a
validated object, cause: Method not supported - setAutoCommit(true)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
	... 31 more
Cannot get a connection, pool
exhaustedjava.util.NoSuchElementException: Could not create a
validated object, cause: Method not supported - setAutoCommit(true)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:212)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:195)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:239)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:60)
	at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:1121)
	at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:913)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:151)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:87)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:71)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:53)
	at mondrian.web.servlet.MdxQueryServlet.processRequest(MdxQueryServlet.java:90)
	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)


What version of mondrian works with hive ? or Am i missing something?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20120229/ae0284c1/attachment.html 


More information about the Mondrian mailing list