phoenix-dev mailing list archives

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

     [ 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.*
!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?


  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.*

*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.*
> !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?



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message