Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-4872

BulkLoad has bug when loading on single-cell-array-with-offsets table.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 4.11.0, 4.12.0, 4.13.0, 4.14.0
    • 4.15.0, 5.1.0
    • None
    • None

    Description

      CsvBulkLoadTool creates incorrect data for the SCAWO(SingleCellArrayWithOffsets) table.

      Every phoenix table needs a marker (empty) column, but CsvBulkLoadTool does not create that column for SCAWO tables.

      If you check the data through HBase Shell, you can see that there is no corresponding column.
      If created by Upsert Query, it is created normally.

      column=0:\x00\x00\x00\x00, timestamp=1535420036372, value=x
      

      Since there is no upper column, the result of all Group By queries is zero.

      This is because "families":

      {"0": ["\\ x00 \\ x00 \\ x00 \\ x00"]}

      is added to the column of the Scan object.

      Because the CsvBulkLoadTool has not created the column, the result of the scan is empty.

       

      This problem applies only to tables with multiple column families. The single-column family table works luckily.

      "Families": {"0": ["ALL"]} is added to the column of the Scan object in the single column family table. 

       

      Attachments

        1. PHOENIX-4872-4.x-HBase-1.4.patch
          5 kB
          Swaroopa Kadam
        2. PHOENIX-4872-master.patch
          5 kB
          Swaroopa Kadam

        Activity

          People

            swaroopa Swaroopa Kadam
            mini666 JeongMin Ju
            Votes:
            0 Vote for this issue
            Watchers:
            7 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 - 40m
                40m