[jira] [Created] (DRILL-4897) NumberFormatException in Drill SQL while casting to BIGINT when its actually a number

["Srihari Karanth (JIRA)" <ji...@apache.org>]

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)