phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jepson (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4520) Strange Phenomenon : Data appear repeat and get back to normal
Date Fri, 05 Jan 2018 02:28:00 GMT
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)

Mime
View raw message