Hitachi Vantara Pentaho Community Wiki
Child pages
  • PA_CR_PA-3.9.X_presto-0.100

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Feature

Status

Notes

Concurrency and Thread Safety


 

Degenerate Schemas

 

Star Schemas


 

Snowflake Schemas


 

Filters


 

Top Count


setMaxRows() is not implemented correctly in the JDBC driver.

Aggregation Tables


Implicit aggregation tables are not recognized by Mondrian. The JDBC driver does not implement java.sql.DatabaseMetaData.getTables

Null Values & Keys


 

Inline Tables


 

Distinct Count


Not all forms of distinct counts are supported, although the minimum support it offers is sufficient for Mondrian.

Grouping Sets


Grouping sets are not supported.

Metadata and data types

The type of certain columns is not reported properly by the JDBC driver.

Connection pooling

Image Added

Using Apache DBCP causes connections to fail because of an unimplemented method.

Failures

...

Connection pooling

Symptom

X

...

When a connection pool is used, connections will fail. Apache DBCP tries to set the connection's read-only property and this throws an exception from the driver.

Code Block
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:presto://localhost:8080/mysql/foodmart; JdbcUser=test; JdbcPassword=test
	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
	at mondrian.olap.Util.newInternal(Util.java:2404)
	at mondrian.olap.Util.newError(Util.java:2420)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:247)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:189)
	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
	at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:215)
	at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:67)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161)
	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:114)
	at mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
	at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:164)
	at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
	at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
	at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
	at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:134)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:270)
	at org.pentaho.mondrian.tck.MondrianContext$1.load(MondrianContext.java:59)
	at org.pentaho.mondrian.tck.MondrianContext$1.load(MondrianContext.java:1)
	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3524)
	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2317)
	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2280)
	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2195)
	... 30 more
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:227)
	... 51 more
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: Disabling read-only mode not supported
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
	... 52 more

Top Count

Symptom

TopCount operations are not working. The JDBC driver doesn't enforce the value passed to java.sql.Statement.setMaxRows().

...