Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5762

CSV having header column by name "suffix" fails to load

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Invalid
    • Affects Version/s: 1.11.0
    • Fix Version/s: None
    • Component/s: Storage - Text & CSV
    • Labels:
      None

      Description

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

      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,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 12:06:27.0,,N
      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 286.
      Fragment 0:0
      
      [Error Id: 1fff3645-e788-4ec3-b678-bea86a39003c on praveens-mbp.lan:31010] (state=,code=0)
      

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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              praveeny1986 Praveen Yadav
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: