[jira] [Created] (DRILL-1203) Problem selecting by integers when csv file has a header there

["Winston Chen (JIRA)" <ji...@apache.org>]

Winston Chen created DRILL-1203:
-----------------------------------

             Summary: Problem selecting by integers when csv file has a header there
                 Key: DRILL-1203
                 URL: https://issues.apache.org/jira/browse/DRILL-1203
             Project: Apache Drill
          Issue Type: Bug
         Environment: local
            Reporter: Winston Chen


If a csv file contains header, the following query:

select * from dfs.`SIC.csv` where columns[0]=17;

causes the following exception:

java.lang.NumberFormatException: sic
	at org.apache.drill.exec.test.generated.FiltererGen12.doEval(FilterTemplate2.java:93) ~[na:na]
	at org.apache.drill.exec.test.generated.FiltererGen12.filterBatchNoSV(FilterTemplate2.java:95) ~[na:na]
	at org.apache.drill.exec.test.generated.FiltererGen12.filterBatch(FilterTemplate2.java:68) ~[na:na]


CSV content format:
isic,name
1,Crop and animal production hunting and related service activities
2,Forestry and logging
3,Fishing and aquaculture
5,Mining of coal and lignite
6,Extraction of crude petroleum and natural gas
7,Mining of metal ores



--
This message was sent by Atlassian JIRA
(v6.2#6252)