Srihari Karanth created DRILL-4897: -------------------------------------- Summary: NumberFormatException in Drill SQL while casting to BIGINT when its actually a number Key: DRILL-4897 URL: https://issues.apache.org/jira/browse/DRILL-4897 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Reporter: Srihari Karanth Priority: Blocker
In the following SQL, drill cribs when trying to convert a number which is in varchar select cast (case IsNumeric(Delta_Radio_Delay) when 0 then 0 else Delta_Radio_Delay end as BIGINT) from datasource.`./sometable` where Delta_Radio_Delay='4294967294'; BIGINT should be able to take very large number. I dont understand how it throws the below error: 0: jdbc:drill:> select cast (case IsNumeric(Delta_Radio_Delay) when 0 then 0 else Delta_Radio_Delay end as BIGINT) from datasource.`./sometable` where Delta_Radio_Delay='4294967294'; Error: SYSTEM ERROR: NumberFormatException: 4294967294 Fragment 1:29 [Error Id: a63bb113-271f-4d8b-8194-2c9728543200 on cluster-3:31010] (state=,code=0) How can i modify SQL to fix this? -- This message was sent by Atlassian JIRA (v6.3.4#6332)