[jira] [Commented] (CALCITE-665) Issue when using with mondrian

["Piers (JIRA)" <ji...@apache.org>]

    [ 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)