[
https://issues.apache.org/jira/browse/CALCITE-665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14481029#comment-14481029
]
Naresh Jois commented on CALCITE-665:
-------------------------------------
I have imported the MongoDB JSON data from -
https://github.com/julianhyde/foodmart-data-json
I am using the MongoDB connector that comes with calcite (Model-Used :
<src>/mongodb/target/test-classes/mongo-foodmart-model.json)
I am using the Foodmart Schema of mondrian (I tried using both Schema of both
versions 4 & 3)
I am not using an ad-hoc SQL Query, I am just using the following code to make
a connection
{code:java}
String connectionString = getConnectionString();
RolapConnection connection =
(RolapConnection)DriverManager.getConnection(connectionString, null);
RolapSchema schema = connection.getSchema();
RolapCube cube = (RolapCube) schema.lookupCube("Warehouse",false);
{code}
Please excuse me if I am missing something fairly obvious, but what do you
refer to as built-in MongoDB instance ?
Please do let me know if any other information is needed,
> Issue when using with mondrian
> -------------------------------
>
> Key: CALCITE-665
> URL: https://issues.apache.org/jira/browse/CALCITE-665
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.1.0-incubating
> Environment: Windows x64, MongoDB , JDK 1.7
> Reporter: Naresh Jois
> Assignee: Julian Hyde
> Priority: Minor
>
> When using with Mondrian 4.2 and With MongoDB (foodmart data),
> The following exception is raised.
> Exception in thread "main" java.lang.ClassCastException: java.lang.Integer
> cannot be cast to java.lang.Long
> at
> org.apache.calcite.avatica.util.AbstractCursor$LongAccessor.getLong(AbstractCursor.java:483)
> at
> org.apache.calcite.avatica.util.AbstractCursor$AccessorImpl.getInt(AbstractCursor.java:252)
> at
> org.apache.calcite.avatica.AvaticaResultSet.getInt(AvaticaResultSet.java:248)
> at
> org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
> at
> org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
> at
> mondrian.spi.impl.SqlStatisticsProvider.getTableCardinality(SqlStatisticsProvider.java:52)
> at
> mondrian.rolap.RolapSchema$PhysStatistic.getTableCardinality(RolapSchema.java:2888)
> at
> mondrian.rolap.RolapSchema$PhysStatistic.getRelationCardinality(RolapSchema.java:2860)
> at
> mondrian.rolap.RolapSchema$PhysTable.populateColumns(RolapSchema.java:1859)
> at
> mondrian.rolap.RolapSchema$PhysRelationImpl.ensurePopulated(RolapSchema.java:1519)
> at
> mondrian.rolap.RolapSchema$PhysTable.ensurePopulated(RolapSchema.java:1729)
> at
> mondrian.rolap.RolapSchemaUpgrader.toPhysRelation(RolapSchemaUpgrader.java:1866)
> at
> mondrian.rolap.RolapSchemaUpgrader.convertCube(RolapSchemaUpgrader.java:179)
> at
> mondrian.rolap.RolapSchemaUpgrader.convertSchema(RolapSchemaUpgrader.java:2208)
> at
> mondrian.rolap.RolapSchemaUpgrader.upgrade(RolapSchemaUpgrader.java:125)
> at
> mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:254)
> at
> mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)
> 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.olap.DriverManager.getConnection(DriverManager.java:50)
> at ....
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
