kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yerui Sun (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-918) Calcite throws "java.lang.Float cannot be cast to java.lang.Double" error while executing SQL
Date Thu, 28 Jan 2016 17:00:41 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15121887#comment-15121887
] 

Yerui Sun commented on KYLIN-918:
---------------------------------

[~Shaofengshi], would you mind give some suggestions on this issue? Thanks a lot~

> Calcite throws "java.lang.Float cannot be cast to java.lang.Double" error while executing
SQL
> ---------------------------------------------------------------------------------------------
>
>                 Key: KYLIN-918
>                 URL: https://issues.apache.org/jira/browse/KYLIN-918
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v1.0
>            Reporter: Shaofeng SHI
>            Assignee: liyang
>             Fix For: v2.0, v1.1
>
>
> This is from an eBay internal deployment which deployed with a latest build from 0.7-staging
(0.7.3-SNAPSHOT); User reported that running a SQL which got such ClassCastException while
it has no problem before; The error trace is:
> {code}
> Caused by: java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.Double

> at Baz$4.apply(Unknown Source) 
> at Baz$4.apply(Unknown Source) 
> at Baz$4.apply(Unknown Source) 
> at org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:737)

> at org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:677)

> at org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:301) 
> at Baz.bind(Unknown Source) 
> at org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:281)

> at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:235)

> at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:476) 
> at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:184) 
> at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:63) 
> at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:42) 
> at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:473)

> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:508)

> at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:477)

> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:109)

> ... 84 more 
> {code}
> The SQL is simple, like 
> select itemid, sum(column_a) from items group by  itemid
> I noticed the column "column_a" was declared as "float" in hive; After change the type
to "double" in hive and sync it to Kylin, the same SQL can run successfully;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message