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.
{code:none}
id,email,first_name,last_name,middle_name,suffix,work_phone,mobile_phone,gender,picture,speciality,taxonomy_code,education_details,experience_details,keywords,doctor_npi,wait_time,created_tstamp,created_by,last_updated_tstamp,last_updated_by,is_deleted
1,[email protected],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 12:06:27.0,,N
2,[email protected],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
{code}
I get this error :
{noformat}
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 286.
Fragment 0:0
[Error Id: 1fff3645-e788-4ec3-b678-bea86a39003c on praveens-mbp.lan:31010]
(state=,code=0)
{noformat}
Solution:
Replacing column name "suffix" with any other text fixed the error.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
