[jira] [Closed] (PHOENIX-4872) BulkLoad has bug when loading on single-cell-array-with-offsets table.

["Chinmay Kulkarni (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-4872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chinmay Kulkarni closed PHOENIX-4872.
-------------------------------------

Bulk closing Jiras for the 4.15.0 release.

> BulkLoad has bug when loading on single-cell-array-with-offsets table.
> ----------------------------------------------------------------------
>
>                 Key: PHOENIX-4872
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4872
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.11.0, 4.12.0, 4.13.0, 4.14.0
>            Reporter: JeongMin Ju
>            Assignee: Swaroopa Kadam
>            Priority: Critical
>             Fix For: 4.15.0, 5.1.0
>
>         Attachments: PHOENIX-4872-4.x-HBase-1.4.patch, PHOENIX-4872-master.patch
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> 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.
> {code:java}
> column=0:\x00\x00\x00\x00, timestamp=1535420036372, value=x
> {code}
> 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. 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)