[jira] [Updated] (HBASE-21276) hbase scan operation cannot scan some rowkey

Mon, 08 Oct 2018 20:12:26 -0700 


     [ 
https://issues.apache.org/jira/browse/HBASE-21276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

xiaolerzheng updated HBASE-21276:
---------------------------------
    Description: 
the table ZEUS.LOAN_CONSUMER_CONTACT has some row,

we can get the row from "get",

but we cannot scan it from scan mr and neither can get the row from "scan"  
with timestamp, nor can get the row from 'scan' with timestamp and startrow

hbase(main):001:0> get 'ZEUS.LOAN_CONSUMER_CONTACT', 
'72520206#KB李总2泥鳅83#13971083626'
 COLUMN CELL
 0:BINLOG_TIME timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
 0:CREATE_TIME timestamp=1537254107291, value=2018-09-18 15:01:46
 0:LAST_MOD_TIME timestamp=1537254107291, value=2018-09-18 15:01:46
 0:PHONE_NO timestamp=1537254107291, value=13971083626
 0:SOURCE timestamp=1537254107291, value=\x80\x00\x00\x01
 0:UID timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
 0:USER_NAME timestamp=1537254107291, 
value=KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583
 0:_0 timestamp=1537254107291, value=x
 8 row(s) in 0.2280 seconds

 

 

hbase(main):002:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',

{ TIMERANGE => [1537254107291, 1537254107293]}

ROW COLUMN+CELL
 0 row(s) in 1410.9010 seconds

hbase(main):003:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',

{ TIMERANGE => [1537254107280, 1537254107294]}

ROW COLUMN+CELL
 0 row(s) in 1410.5480 seconds

 

hbase(main):004:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',

{ STARTROW => 
'72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583#13971083626', 
TIMERANGE => [1537254107280, 1537254107294]}

ROW COLUMN+CELL
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:BINLOG_TIME, 
timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:CREATE_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:LAST_MOD_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:PHONE_NO, 
timestamp=1537254107291, value=13971083626
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:SOURCE, 
timestamp=1537254107291, value=\x80\x00\x00\x01
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:UID, 
timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:USER_NAME, 
timestamp=1537254107291, 
value=KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:_0, 
timestamp=1537254107291, value=x
 xA5\xE9\xB3\x8583#13971083626
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:BINLOG_TIME, 
timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:CREATE_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:LAST_MOD_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:PHONE_NO, 
timestamp=1537254107291, value=18694056338
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:SOURCE, 
timestamp=1537254107291, value=\x80\x00\x00\x01
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:UID, 
timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:USER_NAME, 
timestamp=1537254107291, value=K\xE6\x96\x8C\xE5\x93\xA5
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:_0, 
timestamp=1537254107291, value=x

  was:
the table ZEUS.LOAN_CONSUMER_CONTACT has some row,

we can get the row from "get",

but we cannot scan it from scan mr and neither can get the row from "scan"  
with timestamp, nor can get the row from 'scan' with timestamp and startrow

hbase(main):001:0> get 'ZEUS.LOAN_CONSUMER_CONTACT', 
'72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583#13971083626'
 COLUMN CELL
 0:BINLOG_TIME timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
 0:CREATE_TIME timestamp=1537254107291, value=2018-09-18 15:01:46
 0:LAST_MOD_TIME timestamp=1537254107291, value=2018-09-18 15:01:46
 0:PHONE_NO timestamp=1537254107291, value=13971083626
 0:SOURCE timestamp=1537254107291, value=\x80\x00\x00\x01
 0:UID timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
 0:USER_NAME timestamp=1537254107291, 
value=KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583
 0:_0 timestamp=1537254107291, value=x
 8 row(s) in 0.2280 seconds

 

 

hbase(main):002:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',

{ TIMERANGE => [1537254107291, 1537254107293]}

ROW COLUMN+CELL
 0 row(s) in 1410.9010 seconds

hbase(main):003:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',

{ TIMERANGE => [1537254107280, 1537254107294]}

ROW COLUMN+CELL
 0 row(s) in 1410.5480 seconds

 

hbase(main):004:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',

{ STARTROW => 
'72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583#13971083626', 
TIMERANGE => [1537254107280, 1537254107294]}

ROW COLUMN+CELL
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:BINLOG_TIME, 
timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:CREATE_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:LAST_MOD_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:PHONE_NO, 
timestamp=1537254107291, value=13971083626
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:SOURCE, 
timestamp=1537254107291, value=\x80\x00\x00\x01
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:UID, 
timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:USER_NAME, 
timestamp=1537254107291, 
value=KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583
 xA5\xE9\xB3\x8583#13971083626
 72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:_0, 
timestamp=1537254107291, value=x
 xA5\xE9\xB3\x8583#13971083626
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:BINLOG_TIME, 
timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:CREATE_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:LAST_MOD_TIME, 
timestamp=1537254107291, value=2018-09-18 15:01:46
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:PHONE_NO, 
timestamp=1537254107291, value=18694056338
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:SOURCE, 
timestamp=1537254107291, value=\x80\x00\x00\x01
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:UID, 
timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:USER_NAME, 
timestamp=1537254107291, value=K\xE6\x96\x8C\xE5\x93\xA5
 8
 72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:_0, 
timestamp=1537254107291, value=x


> hbase scan operation  cannot scan some rowkey
> ---------------------------------------------
>
>                 Key: HBASE-21276
>                 URL: https://issues.apache.org/jira/browse/HBASE-21276
>             Project: HBase
>          Issue Type: Bug
>    Affects Versions: 1.1.3
>            Reporter: xiaolerzheng
>            Priority: Major
>
> the table ZEUS.LOAN_CONSUMER_CONTACT has some row,
> we can get the row from "get",
> but we cannot scan it from scan mr and neither can get the row from "scan"  
> with timestamp, nor can get the row from 'scan' with timestamp and startrow
> hbase(main):001:0> get 'ZEUS.LOAN_CONSUMER_CONTACT', 
> '72520206#KB李总2泥鳅83#13971083626'
>  COLUMN CELL
>  0:BINLOG_TIME timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
>  0:CREATE_TIME timestamp=1537254107291, value=2018-09-18 15:01:46
>  0:LAST_MOD_TIME timestamp=1537254107291, value=2018-09-18 15:01:46
>  0:PHONE_NO timestamp=1537254107291, value=13971083626
>  0:SOURCE timestamp=1537254107291, value=\x80\x00\x00\x01
>  0:UID timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
>  0:USER_NAME timestamp=1537254107291, 
> value=KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583
>  0:_0 timestamp=1537254107291, value=x
>  8 row(s) in 0.2280 seconds
>  
>  
> hbase(main):002:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',
> { TIMERANGE => [1537254107291, 1537254107293]}
> ROW COLUMN+CELL
>  0 row(s) in 1410.9010 seconds
> hbase(main):003:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',
> { TIMERANGE => [1537254107280, 1537254107294]}
> ROW COLUMN+CELL
>  0 row(s) in 1410.5480 seconds
>  
> hbase(main):004:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT',
> { STARTROW => 
> '72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583#13971083626', 
> TIMERANGE => [1537254107280, 1537254107294]}
> ROW COLUMN+CELL
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:BINLOG_TIME, 
> timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:CREATE_TIME, 
> timestamp=1537254107291, value=2018-09-18 15:01:46
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:LAST_MOD_TIME, 
> timestamp=1537254107291, value=2018-09-18 15:01:46
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:PHONE_NO, 
> timestamp=1537254107291, value=13971083626
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:SOURCE, 
> timestamp=1537254107291, value=\x80\x00\x00\x01
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:UID, 
> timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:USER_NAME, 
> timestamp=1537254107291, 
> value=KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\xA5\xE9\xB3\x8583
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#KB\xE6\x9D\x8E\xE6\x80\xBB2\xE6\xB3\ column=0:_0, 
> timestamp=1537254107291, value=x
>  xA5\xE9\xB3\x8583#13971083626
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:BINLOG_TIME, 
> timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:CREATE_TIME, 
> timestamp=1537254107291, value=2018-09-18 15:01:46
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:LAST_MOD_TIME, 
> timestamp=1537254107291, value=2018-09-18 15:01:46
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:PHONE_NO, 
> timestamp=1537254107291, value=18694056338
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:SOURCE, 
> timestamp=1537254107291, value=\x80\x00\x00\x01
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:UID, 
> timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:USER_NAME, 
> timestamp=1537254107291, value=K\xE6\x96\x8C\xE5\x93\xA5
>  8
>  72520206#K\xE6\x96\x8C\xE5\x93\xA5#1869405633 column=0:_0, 
> timestamp=1537254107291, value=x



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to