[jira] [Commented] (PHOENIX-4847) Index tables will produce dirty data when use BukloadTool

["Jaanai Zhang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-4847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16578282#comment-16578282 ] 

Jaanai Zhang commented on PHOENIX-4847:
---------------------------------------

[~elserj] I don't know this problem whether happened firstly

> Index tables will produce dirty data when use BukloadTool 
> ----------------------------------------------------------
>
>                 Key: PHOENIX-4847
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4847
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.12.0, 4.13.0, 4.14.0, 5.0.0
>            Reporter: Jaanai Zhang
>            Priority: Critical
>
> Index tables are inconsistent with data tables when occurs update primary key of data tables with CSVBulkload tool.
> CSV data:
> {code:sql}
> k1,v1_1,1
> k2,v2_2,2
> k1,v1_1,3
> {code}
> Imported table 
> {code:sql}
> DROP TABLE IF EXISTS TABLE1;
> CREATE TABLE TABLE1 (ID VARCHAR NOT NULL PRIMARY KEY, V1 VARCHAR, V2 BIGINT)
> SALT_BUCKETS = 8,
> UPDATE_CACHE_FREQUENCY = 120000;
> CREATE INDEX V1_IDX on TABLE1(V1) include(v2);
> CREATE INDEX V2_IDX on TABLE1(V2) include(v1);
> {code}
> The following is query results after executing `CsvBulkLoadTool`
> {code:sql}
> 0: jdbc:phoenix:hb-bp18j460748jq41v0-002.hbas> select * from table1;
> +-----+-------+-----+
> | ID  |  V1   | V2  |
> +-----+-------+-----+
> | k2  | v2_2  | 2   |
> | k1  | v1_1  | 3   |
> +-----+-------+-----+
> 2 rows selected (0.066 seconds)
> 0: jdbc:phoenix:hb-bp18j460748jq41v0-002.hbas>  select * from V1_IDX;
> +-------+------+-------+
> | 0:V1  | :ID  | 0:V2  |
> +-------+------+-------+
> | v1_1  | k1   | 3     |
> | v2_2  | k2   | 2     |
> +-------+------+-------+
> 2 rows selected (0.074 seconds)
> 0: jdbc:phoenix:hb-bp18j460748jq41v0-002.hbas>  select * from V2_IDX;
> +-------+------+-------+
> | 0:V2  | :ID  | 0:V1  |
> +-------+------+-------+
> | 1     | k1   | v1_1  |
> | 3     | k1   | v1_1  |
> | 2     | k2   | v2_2  |
> +-------+------+-------+
> 3 rows selected (0.062 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)