Krystal created DRILL-503:
-----------------------------
Summary: 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
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.2#6252)
