drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1203) Problem selecting by integers when csv file has a header there
Date Sun, 04 Jan 2015 21:29:44 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-1203.
-----------------------------------
    Resolution: Duplicate

> 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: Future
>
>
> 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.3.4#6332)

Mime
View raw message