Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-191

load data is null when quote char is single and no '\n' being end.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 0.2.0-incubating
    • None
    • None

    Description

      when load data just like below,
      CREATE TABLE Priyal11 (id int,name string) STORED BY 'org.apache.carbondata.format';

      LOAD DATA inpath 'hdfs://hacluster/Priyal1/test34.csv' INTO table Priyal11 options ('DELIMITER'=',', 'QUOTECHAR'='\"', 'FILEHEADER'='id,name');

      and test34.csv is like below(note: there is no new line in the end of file.):
      1,"priyal\"
      2,"hello\"

      then query name's result is null. Actually, because of the existence of quote char. the expected result should be

      prival"
      2,"hello"

      and if we add new line in the end of file, then query is right.

      Attachments

        Issue Links

          Activity

            People

              Jay357089 Jay
              Jay357089 Jay
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: