drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Winston Chen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1203) Problem selecting by integers when csv file has a header there
Date Mon, 28 Jul 2014 06:05:39 GMT
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)
	at org.apache.drill.exec.test.generated.FiltererGen12.filterBatch(FilterTemplate2.java:68)

CSV content format:
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

View raw message