[DRILL-503] Cast fail for float and double

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Krystal
• Created: 11/Apr/14 22:01
• Updated: 15/Mar/17 16:14
• Resolved: 09/Jun/14 06:48

Description

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)