[jira] [Created] (DRILL-3386) NumberFormatException with numeric data from CSV file in where clause

["Uwe Geercken (JIRA)" <ji...@apache.org>]

Uwe Geercken created DRILL-3386:
-----------------------------------

             Summary: NumberFormatException with numeric data from CSV file in where clause
                 Key: DRILL-3386
                 URL: https://issues.apache.org/jira/browse/DRILL-3386
             Project: Apache Drill
          Issue Type: Improvement
          Components: Execution - Data Types
    Affects Versions: 1.0.0
         Environment: RedHat 6 enterprise
            Reporter: Uwe Geercken
            Assignee: Daniel Barclay (Drill)
            Priority: Minor


query on a csv file. sample data:

XWF,WF_APR_Head count,5,2015,1.00
XWF,WF_APR_Head count,6,2015,1.00
XWF,WF_APR_NORMAL TIME,5,2015,48.00
XWF,WF_APR_NORMAL TIME,6,2015,104.00

this query runs ok:

select columns[0] as node_key, columns[1] as row_key,columns[2] as `month`,columns[3] as `year`,columns[4] as `day`,columns[5] as `value` from dfs.data.`/epx_toms/Workforce_Daily_Actual.csv` where columns[5]>10.0

but if the decimal in the where clause is is NOT specified like here:

select columns[0] as node_key, columns[1] as row_key,columns[2] as `month`,columns[3] as `year`,columns[4] as `day`,columns[5] as `value` from dfs.data.`/epx_toms/Workforce_Daily_Actual.csv` where columns[5]>10

an exception occurs:
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: java.lang.NumberFormatException: For input string: "value" Fragment 0:0 [Error Id: 63ee12d6-55a0-4cd5-8626-4d3cbbfb7ae9 on xxx.xxx.xxx:31010] 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)