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

Failure in data load when we first load the bad record and then valid record and bad record action is set to Fail

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 1.2.0
    • None
    • None

    Description

      When we load bad record into the table and bad record action is set to "FAIL", then data load will fail. During load a bad record logger static map is maintained which holds the key for bad record. When data load fails due to bad record exception is thrown and key from bad record logger static map is not cleared because of which when valid data is loaded next time data load fails because the key still exists in the map.

      Steps to reproduce
      -------------------------------
      Execute the below commands in sequence in the same session.
      create table bigtab (val string, bal int) STORED BY 'carbondata'
      load data inpath 'bigtabbad.csv' into table bigtab options('DELIMITER'=',','QUOTECHAR'='"','BAD_RECORDS_ACTION'='FAIL','FILEHEADER'='val,bal')
      load data inpath 'bigtab.csv' into table bigtab options('DELIMITER'=',','QUOTECHAR'='"','BAD_RECORDS_ACTION'='FAIL','FILEHEADER'='val,bal')

      Attachments

        1. bigtab.csv
          68 kB
          Manish Gupta
        2. bigtabbad.csv
          68 kB
          Manish Gupta

        Issue Links

          Activity

            People

              manishgupta_88 Manish Gupta
              manishgupta_88 Manish Gupta
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m