drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Praveen Yadav (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5762) CSV having header column by name "suffix" fails to load
Date Fri, 01 Sep 2017 12:44:01 GMT
Praveen Yadav created DRILL-5762:

             Summary: CSV having header column by name "suffix" fails to load
                 Key: DRILL-5762
                 URL: https://issues.apache.org/jira/browse/DRILL-5762
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Text & CSV
    Affects Versions: 1.11.0
            Reporter: Praveen Yadav

Trying select * query on the below csv file using apache drill 1.11.0.

1,xxxx@gmail.com,XXXXX,XXXX,,Dr,912225711234,,M,assets/images/doctorIcon.png,Primary Care
Physician,Primary Care Doctor,M.D,3 years,Primary Care Doctor,12349765,10,2015-04-22 17:20:48.0,,2015-12-16
2,xxxx@gmail.com,XXXX,XXXX,,Dr,913345311234,,M,assets/images/doctorIcon.png,Eye Doctor,EYE
Care Doctor,MD,5 years,,16456076,20,2015-04-30 11:07:57.0,,2015-11-07 08:49:57.0,,N

I get this error :

Error: DATA_READ ERROR: Error processing input: , line=1, char=286. Content parsed: [ ]

Failure while reading file file:somepath/file.csv. Happened at or shortly before byte position
Fragment 0:0

[Error Id: 1fff3645-e788-4ec3-b678-bea86a39003c on praveens-mbp.lan:31010] (state=,code=0)

Replacing column name "suffix" with any other text fixed the error.

This message was sent by Atlassian JIRA

View raw message