[
https://issues.apache.org/jira/browse/OPTIQ-437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tom Barber updated OPTIQ-437:
-----------------------------
Description:
I can't validate this cause I can't get the suite to run but I think this is
more than just a mongo bug. I've attached a patch to the mongo test suite that
causes a class cast exception on my build when i run the query in SQLLine
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
Error while loading segment; sql=[select "time_by_day"."the_year" as "c0",
"product_class"."product_family" as "c1", "prod
uct_class"."product_department" as "c2", "product_class"."product_category" as
"c3", count("sales_fact_1997"."product_id") as "m0" from "sales_fact_1997" as
"sales_fact_1997", "time_by_day" as "tim
e_by_day", "product" as "product", "product_class" as "product_class" where
"time_by_day"."the_year" = 1997 and "sales_fact_1997"."time_id" =
"time_by_day"."time_id" and "sales_fact_1997"."product_
id" = "product"."product_id" and "product"."product_class_id" =
"product_class"."product_class_id" group by "time_by_day"."the_year",
"product_class"."product_family", "product_class"."product_depa
rtment", "product_class"."product_category"]
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
at mondrian.olap.Util.newInternal(Util.java:2543)
at mondrian.olap.Util.newError(Util.java:2559)
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:362)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:262)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:346)
at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:633)
... 7 more
Caused by: java.sql.SQLException: exception while executing query:
java.lang.Integer cannot be cast to java.lang.Short
at net.hydromatic.avatica.Helper.createException(Helper.java:39)
at
net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406)
at
net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:350)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:77)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:202)
... 9 more
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to
java.lang.Short
at Baz$12.apply(Unknown Source)
at Baz$12.apply(Unknown Source)
at
net.hydromatic.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:664)
at
net.hydromatic.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:632)
at
net.hydromatic.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:284)
at Baz.bind(Unknown Source)
at
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.getEnumerable(OptiqPrepare.java:270)
at
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.enumerator(OptiqPrepare.java:280)
at
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.createCursor(OptiqPrepare.java:248)
at net.hydromatic.optiq.jdbc.MetaImpl.createCursor(MetaImpl.java:611)
at
net.hydromatic.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:161)
at
net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:58)
at
net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:35)
at
net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
... 14 more
was:I can't validate this cause I can't get the suite to run but I think this
is more than just a mongo bug. I've attached a patch to the mongo test suite
that causes a class cast exception on my build when i run the query in SQLLine
Summary: Cast Class Exception at Baz$12.apply (was: Cast Class
Exception)
> Cast Class Exception at Baz$12.apply
> ------------------------------------
>
> Key: OPTIQ-437
> URL: https://issues.apache.org/jira/browse/OPTIQ-437
> Project: Optiq
> Issue Type: Bug
> Affects Versions: 0.9.1-incubating
> Reporter: Tom Barber
> Assignee: Julian Hyde
> Attachments: 0001-classcasttest.patch
>
>
> I can't validate this cause I can't get the suite to run but I think this is
> more than just a mongo bug. I've attached a patch to the mongo test suite
> that causes a class cast exception on my build when i run the query in SQLLine
> Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error:
> Error while loading segment; sql=[select "time_by_day"."the_year" as "c0",
> "product_class"."product_family" as "c1", "prod
> uct_class"."product_department" as "c2", "product_class"."product_category"
> as "c3", count("sales_fact_1997"."product_id") as "m0" from "sales_fact_1997"
> as "sales_fact_1997", "time_by_day" as "tim
> e_by_day", "product" as "product", "product_class" as "product_class" where
> "time_by_day"."the_year" = 1997 and "sales_fact_1997"."time_id" =
> "time_by_day"."time_id" and "sales_fact_1997"."product_
> id" = "product"."product_id" and "product"."product_class_id" =
> "product_class"."product_class_id" group by "time_by_day"."the_year",
> "product_class"."product_family", "product_class"."product_depa
> rtment", "product_class"."product_category"]
> at
> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
> at mondrian.olap.Util.newInternal(Util.java:2543)
> at mondrian.olap.Util.newError(Util.java:2559)
> at mondrian.rolap.SqlStatement.handle(SqlStatement.java:362)
> at mondrian.rolap.SqlStatement.execute(SqlStatement.java:262)
> at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:346)
> at
> mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:633)
> ... 7 more
> Caused by: java.sql.SQLException: exception while executing query:
> java.lang.Integer cannot be cast to java.lang.Short
> at net.hydromatic.avatica.Helper.createException(Helper.java:39)
> at
> net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:406)
> at
> net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:350)
> at
> net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:77)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
> at mondrian.rolap.SqlStatement.execute(SqlStatement.java:202)
> ... 9 more
> Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to
> java.lang.Short
> at Baz$12.apply(Unknown Source)
> at Baz$12.apply(Unknown Source)
> at
> net.hydromatic.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:664)
> at
> net.hydromatic.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:632)
> at
> net.hydromatic.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:284)
> at Baz.bind(Unknown Source)
> at
> net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.getEnumerable(OptiqPrepare.java:270)
> at
> net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.enumerator(OptiqPrepare.java:280)
> at
> net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.createCursor(OptiqPrepare.java:248)
> at net.hydromatic.optiq.jdbc.MetaImpl.createCursor(MetaImpl.java:611)
> at
> net.hydromatic.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:161)
> at
> net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:58)
> at
> net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:35)
> at
> net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
> ... 14 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
