[
https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15466910#comment-15466910
]
Venkatesh C commented on PHOENIX-3229:
--------------------------------------
Is that, fix available in Phoenix 4.7 also. Because we are using
Hartonworks(2.4) environment. If we use recent version of Hartonworks(2.5), we
will be able to use 4.7 but not 4.8.
Please suggest.
> 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)
