You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hbase.apache.org by "xiaolerzheng (JIRA)" <ji...@apache.org> on 2018/12/13 09:06:00 UTC

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

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

xiaolerzheng updated HBASE-21276:
---------------------------------
    Attachment: image-2018-12-13-17-05-40-743.png

> 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
>         Attachments: image-2018-12-13-17-05-40-743.png
>
>
> 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#YYYY#139xxxxxxxx'
>  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=139xxxxxxxx
>  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=YYYY
>  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#YYYY#139xxxxxxxx', TIMERANGE => [1537254107280, 1537254107294]}
> ROW COLUMN+CELL
>  72520206#YYYY#139xxxxxxxx column=0:BINLOG_TIME, timestamp=1537254107291, value=\x80\x00\x01e\xEB|%I
>  72520206#YYYY#139xxxxxxxx column=0:CREATE_TIME, timestamp=1537254107291, value=2018-09-18 15:01:46
>  72520206#YYYY#139xxxxxxxx column=0:LAST_MOD_TIME, timestamp=1537254107291, value=2018-09-18 15:01:46
>  72520206#YYYY#139xxxxxxxx column=0:PHONE_NO, timestamp=1537254107291, value=139xxxxxxxx
>  72520206#YYYY#139xxxxxxxx column=0:SOURCE, timestamp=1537254107291, value=\x80\x00\x00\x01
>  72520206#YYYY#139xxxxxxxx column=0:UID, timestamp=1537254107291, value=\x80\x00\x00\x00\x04R\x92\x0E
>  72520206#YYYY#139xxxxxxxx column=0:USER_NAME, timestamp=1537254107291, value=YYYY
>  72520206#YYYY#139xxxxxxxx column=0:_0, timestamp=1537254107291, value=x



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