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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: Future

Environment

local

• Assignee: Unassigned
• Reporter: Winston Chen
• Created: 28/Jul/14 06:04
• Updated: 04/Jan/15 21:29
• Resolved: 04/Jan/15 21:29

Description

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