[ https://issues.apache.org/jira/browse/PHOENIX-4520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jepson updated PHOENIX-4520: ---------------------------- Description: Strange Phenomenon : Data appera repeat and get back to normal. *Table:* {code:java} CREATE TABLE JYDW.bms_biz_outstock_master ( id bigint(20) , oms_id varchar(64) , outstock_no varchar(64) , external_no varchar(128) , warehouse_code varchar(64) , warehouse_name varchar(128) , customerid varchar(64) , customer_name varchar(128) , carrier_id varchar(64) , carrier_name varchar(128) , CONSTRAINT pk PRIMARY KEY (id) ) SALT_BUCKETS = 12, COMPRESSION='SNAPPY'; {code} *I do this in 2019-01-04:* *1.Select SQL1:* {code:java} SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER WHERE WAREHOUSE_CODE='B03' AND OUTSTOCK_NO ='Z310000164110' AND CUSTOMERID='1100000871' ; {code} *The data appear repeat, 8 rows are same.* !https://issues.apache.org/jira/secure/attachment/12904715/sql1-2018-01-04.png! *2.Select SQL2:* {code:java} SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER WHERE ID=2102527; {code} *The data get back to normal, 1 row is correct.* *After the seconde day , I do this in 2019-01-05:* *3.Select SQL1:* {code:java} SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER WHERE WAREHOUSE_CODE='B03' AND OUTSTOCK_NO ='Z310000164110' AND CUSTOMERID='1100000871' ; {code} *Now,the data is one row, get back to normal.* !https://issues.apache.org/jira/secure/attachment/12904713/sql1-2018-01-05.png! *Question:* The sql1 is why appear 8 rows? was: Strange Phenomenon : Data appera repeat and get back to normal. *Table:* {code:java} CREATE TABLE JYDW.bms_biz_outstock_master ( id bigint(20) , oms_id varchar(64) , outstock_no varchar(64) , external_no varchar(128) , warehouse_code varchar(64) , warehouse_name varchar(128) , customerid varchar(64) , customer_name varchar(128) , carrier_id varchar(64) , carrier_name varchar(128) , CONSTRAINT pk PRIMARY KEY (id) ) SALT_BUCKETS = 12, COMPRESSION='SNAPPY'; {code} *I do this in 2019-01-04:* *1.Select SQL1:* {code:java} SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER WHERE WAREHOUSE_CODE='B03' AND OUTSTOCK_NO ='Z310000164110' AND CUSTOMERID='1100000871' ; {code} *The data appear repeat, 8 rows are same.* !https://issues.apache.org/jira/secure/attachment/12904715/sql1-2018-01-04.png! *2.Select SQL2:* {code:java} SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER WHERE ID=2102527; {code} *The data get back to normal, 1 row is correct.* !https://issues.apache.org/jira/secure/attachment/12904713/sql1-2018-01-05.png! *After the seconde day , I do this in 2019-01-05:* *3.Select SQL1:* {code:java} SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER WHERE WAREHOUSE_CODE='B03' AND OUTSTOCK_NO ='Z310000164110' AND CUSTOMERID='1100000871' ; {code} *Now,the data is one row, get back to normal.* *Question:* The sql1 is why appear 8 rows? > Strange Phenomenon : Data appear repeat and get back to normal > -------------------------------------------------------------- > > Key: PHOENIX-4520 > URL: https://issues.apache.org/jira/browse/PHOENIX-4520 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.10.0 > Environment: phoenix4.10 > cdh5.12.0-hbase1.2.0 > Reporter: Jepson > Attachments: sql1-2018-01-04.png, sql1-2018-01-05.png, > sql2-2018-01-04.png > > Original Estimate: 96h > Remaining Estimate: 96h > > Strange Phenomenon : Data appera repeat and get back to normal. > *Table:* > {code:java} > CREATE TABLE JYDW.bms_biz_outstock_master ( > id bigint(20) , > oms_id varchar(64) , > outstock_no varchar(64) , > external_no varchar(128) , > warehouse_code varchar(64) , > warehouse_name varchar(128) , > customerid varchar(64) , > customer_name varchar(128) , > carrier_id varchar(64) , > carrier_name varchar(128) , > CONSTRAINT pk PRIMARY KEY (id) > ) SALT_BUCKETS = 12, COMPRESSION='SNAPPY'; > {code} > *I do this in 2019-01-04:* > *1.Select SQL1:* > {code:java} > SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER > WHERE WAREHOUSE_CODE='B03' > AND OUTSTOCK_NO ='Z310000164110' > AND CUSTOMERID='1100000871' ; > {code} > *The data appear repeat, 8 rows are same.* > !https://issues.apache.org/jira/secure/attachment/12904715/sql1-2018-01-04.png! > *2.Select SQL2:* > {code:java} > SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER > WHERE ID=2102527; > {code} > *The data get back to normal, 1 row is correct.* > *After the seconde day , I do this in 2019-01-05:* > *3.Select SQL1:* > {code:java} > SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER > WHERE WAREHOUSE_CODE='B03' > AND OUTSTOCK_NO ='Z310000164110' > AND CUSTOMERID='1100000871' ; > {code} > *Now,the data is one row, get back to normal.* > !https://issues.apache.org/jira/secure/attachment/12904713/sql1-2018-01-05.png! > *Question:* > The sql1 is why appear 8 rows? -- This message was sent by Atlassian JIRA (v6.4.14#64029)