You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Uwe Geercken (JIRA)" <ji...@apache.org> on 2015/06/26 08:59:04 UTC
[jira] [Created] (DRILL-3386) NumberFormatException with numeric
data from CSV file in where clause
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)