[
https://issues.apache.org/jira/browse/CALCITE-665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14576514#comment-14576514
]
Piers commented on CALCITE-665:
-------------------------------
Hi -
I think I hit a similar problem when following the example here
http://calcite.incubator.apache.org/docs/howto.html#mongodb-adapter - using
latest head from incubator-calcite on Ubuntu Vivid with a vanilla Mongo
install. When I get to the point in the example "sqlline> select count(*) from
zips; " - I get the following error:
{code}
0: jdbc:calcite:model=mongodb/target/test-cla> select count(*) from zips;
+---------------------+
| EXPR$0 |
+---------------------+
java.lang.ClassCastException: java.lang.Integer cannot be cast to
java.lang.Long
at
org.apache.calcite.avatica.util.AbstractCursor$LongAccessor.getLong(AbstractCursor.java:504)
at org.apache.calcite.avatica.AvaticaSite.get(AvaticaSite.java:305)
at
org.apache.calcite.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:381)
at sqlline.Rows$Row.<init>(Rows.java:157)
at sqlline.IncrementalRows.hasNext(IncrementalRows.java:63)
at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
at sqlline.SqlLine.print(SqlLine.java:1652)
at sqlline.Commands.execute(Commands.java:833)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:807)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
0: jdbc:calcite:model=mongodb/target/test-cla>
{code}
Thanks,
Piers Harding.
> 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)
