You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ankit Singhal (JIRA)" <ji...@apache.org> on 2016/09/02 11:38:21 UTC
[jira] [Comment Edited] (PHOENIX-3229)
java.lang.IllegalArgumentException: Unable to PTableType enum for value of
'MATERIALIZED VIEW' Exception In Saiku
[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458277#comment-15458277 ]
Ankit Singhal edited comment on PHOENIX-3229 at 9/2/16 11:37 AM:
-----------------------------------------------------------------
Couldn't find , how "MATERIALIZED VIEW" type is passed in mondrian.(below code says only TABLE and VIEW which is supported by Phoenix).
https://github.com/pentaho/mondrian/blob/4.3.0.1-R/src/main/java/mondrian/rolap/aggmatcher/JdbcSchema.java
It seems saiku is using some different version of mondrian (4.3.0.1-SPARK) which might be passing this type.
Anyways, from v4.8 onwards, Phoenix has started ignoring the unknown table type in DatabaseMetaData.getTables() API (changes done as part of PHOENIX-2489)
was (Author: ankit@apache.org):
0
down vote
Couldn't find , how "MATERIALIZED VIEW" type is passed in mondrian.(below code says only TABLE and VIEW which is supported by Phoenix).
https://github.com/pentaho/mondrian/blob/4.3.0.1-R/src/main/java/mondrian/rolap/aggmatcher/JdbcSchema.java
It seems saiku is using some different version of mondrian (4.3.0.1-SPARK) which might be passing this type.
Anyways, from v4.8 onwards, Phoenix has started ignoring the unknown table type in DatabaseMetaData.getTables() API (changes done as part of PHOENIX-2489)
> java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku
> -----------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-3229
> URL: https://issues.apache.org/jira/browse/PHOENIX-3229
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.4.0
> Environment: HBase 1.1.2, Saiku 3.8
> Reporter: Venkatesh C
> Fix For: 4.8.0
>
>
> I am trying to integrate the saiku with phoenix. Phoenix intern connect with HBase. I created a schema and when the Saiku tries to load phoenix schema xml, Am triggered with below error. I am working restless to figure it out. Can any one please suggest am I missing something and what to do.
> This might be wrong place to post the question here. But, couldn't find any solution from any where. That's the reason posting here, to check if it's related to phoenix versions issue.
> java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW'
> at org.apache.phoenix.schema.PTableType.fromValue(PTableType.java:88)
> at org.apache.phoenix.jdbc.PhoenixDatabaseMetaData.getTables(PhoenixDatabaseMetaData.java:1057)
> at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
> at mondrian.rolap.aggmatcher.JdbcSchema.loadTablesOfType(JdbcSchema.java:1205)
> at mondrian.rolap.aggmatcher.JdbcSchema.loadTables(JdbcSchema.java:1162)
> at mondrian.rolap.aggmatcher.JdbcSchema.load(JdbcSchema.java:1042)
> at mondrian.rolap.RolapSchema$PhysSchema.<init>(RolapSchema.java:976)
> at mondrian.rolap.RolapSchemaLoader.createSyntheticPhysicalSchema(RolapSchemaLoader.java:1479)
> at mondrian.rolap.RolapSchemaLoader.validatePhysicalSchema(RolapSchemaLoader.java:684)
> at mondrian.rolap.RolapSchemaLoader.loadStage2(RolapSchemaLoader.java:376)
> at mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:336)
> at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:272)
> at mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4304)
> at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)
> at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)
> at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
> at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)
> at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
> at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
> at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)
> 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:139)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:111)
> at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:57)
> at org.saiku.datasources.connection.SaikuConnectionFactory.getConnection(SaikuConnectionFactory.java:29)
> at org.saiku.web.core.SecurityAwareConnectionManager.a(SecurityAwareConnectionManager.java:293)
> at org.saiku.web.core.SecurityAwareConnectionManager.getInternalConnection(SecurityAwareConnectionManager.java:109)
> at org.saiku.datasources.connection.AbstractConnectionManager.getConnection(AbstractConnectionManager.java:131)
> at org.saiku.datasources.connection.AbstractConnectionManager.getAllConnections(AbstractConnectionManager.java:158)
> at org.saiku.datasources.connection.AbstractConnectionManager.getAllOlapConnections(AbstractConnectionManager.java:181)
> at org.saiku.olap.discover.OlapMetaExplorer.getAllConnections(OlapMetaExplorer.java:119)
> at org.saiku.service.olap.OlapDiscoverService.getAllConnections(OlapDiscoverService.java:58)
> at org.saiku.web.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:60)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)