You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Jepson (JIRA)" <ji...@apache.org> on 2018/01/05 02:28:02 UTC
[jira] [Updated] (PHOENIX-4520) Strange Phenomenon : Data appear
repeat and get back to normal
[ 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.*
*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.*
*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:*
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?
> 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.*
> *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.*
> *Question:*
> The sql1 is why appear 8 rows?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)