You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/31 07:53:43 UTC
[jira] [Updated] (DRILL-1203) Problem selecting by integers when
csv file has a header there
[ https://issues.apache.org/jira/browse/DRILL-1203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-1203:
----------------------------------
Fix Version/s: 0.5.0
> 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
> Fix For: 0.5.0
>
>
> 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)