You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2017/03/15 16:14:41 UTC
[jira] [Closed] (DRILL-503) Cast fail for float and double
[ https://issues.apache.org/jira/browse/DRILL-503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-503.
-------------------------
Bug was verified.
> Cast fail for float and double
> ------------------------------
>
> Key: DRILL-503
> URL: https://issues.apache.org/jira/browse/DRILL-503
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.0.0
> Reporter: Krystal
> Fix For: 0.4.0
>
>
> Cast failed for the following queries:
> 0: jdbc:drill:schema=dfs> select cast(gpa as double) from dfs.`student`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "9cb5c45d-cf98-44f9-8e14-46f537cf2fa2"
> endpoint {
> address: "qa-node57.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up query. < FragmentSetupException:[ Failure while trying to convert fragment into json. ] < JsonMappingException:[ (was java.lang.NullPointerException) (through reference chain: org.apache.drill.exec.physical.config.Screen[\"child\"]->org.apache.drill.exec.physical.config.Project[\"exprs\"]->java.util.ArrayList[0]->org.apache.drill.common.logical.data.NamedExpression[\"expr\"]) ] < NullPointerException"
> ]
> Error: exception while executing query (state=,code=0)
> ---------------------------------------------------------------------------------
> 0: jdbc:drill:schema=dfs> select cast(gpa as float8) from dfs.`student`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "1f5f85ef-1d78-4d87-bdea-feebf7521aff"
> endpoint {
> address: "qa-node57.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 20 to line 1, column 25 ] < EigenbaseContextException:[ From line 1, column 20 to line 1, column 25 ] < SqlValidatorException:[ Unknown datatype name \'float8\' ]"
> ]
> Error: exception while executing query (state=,code=0)
> ----------------------------------------------------------------------------
> 0: jdbc:drill:schema=dfs> select cast(gpa as float) from dfs.`student`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "1fc8859f-b6ac-4789-9265-1d2810b72abc"
> endpoint {
> address: "qa-node57.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up query. < FragmentSetupException:[ Failure while trying to convert fragment into json. ] < JsonMappingException:[ (was java.lang.NullPointerException) (through reference chain: org.apache.drill.exec.physical.config.Screen[\"child\"]->org.apache.drill.exec.physical.config.Project[\"exprs\"]->java.util.ArrayList[0]->org.apache.drill.common.logical.data.NamedExpression[\"expr\"]) ] < NullPointerException"
> ]
> Error: exception while executing query (state=,code=0)
> ------------------------------------------------------------------------------
> 0: jdbc:drill:schema=dfs> select cast(gpa as float8) from dfs.`student`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "8af67797-d174-4b84-b9b7-e6fe9413908b"
> endpoint {
> address: "qa-node57.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 20 to line 1, column 25 ] < EigenbaseContextException:[ From line 1, column 20 to line 1, column 25 ] < SqlValidatorException:[ Unknown datatype name \'float8\' ]"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)