Jepson created PHOENIX-4520:
-------------------------------
Summary: 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
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:*
SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER
WHERE WAREHOUSE_CODE='B03'
AND OUTSTOCK_NO ='Z310000164110'
AND CUSTOMERID='1100000871' ;
*The data appear repeat, 8 rows are same.*
*2.Select SQL2:*
SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER
WHERE ID=2102527;
*The data get back to normal, 1 row is correct.*
*After the seconde day , I do this in 2019-01-05:*
*3.Select SQL1:*
SELECT * FROM JYDW.BMS_BIZ_OUTSTOCK_MASTER
WHERE WAREHOUSE_CODE='B03'
AND OUTSTOCK_NO ='Z310000164110'
AND CUSTOMERID='1100000871' ;
*Now,the data is one row, get back to normal.*
*Question:*
The sql1 is why appear 8 rows?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
