[
https://issues.apache.org/jira/browse/HBASE-21276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16642735#comment-16642735
]
xiaolerzheng commented on HBASE-21276:
--------------------------------------
we used CopyTable to copy the table content to another hbase cluster, with
starttime and endtime,
/data/program/hbase/bin/hbase org.apache.hadoop.hbase.mapreduce.CopyTable -D
mapreduce.job.running.map.limit=20 --starttime=1537254000000
--endtime=1537254300000
--peer.adr=10.1.169.18,10.1.169.19,10.1.169.20:2181:/hbase
ZEUS.LOAN_CONSUMER_CONTACT
and then scan the table in the new cluster:
hbase(main):001:0> scan 'ZEUS.LOAN_CONSUMER_CONTACT'
ROW COLUMN+CELL
105649041#\xE4\xB8\x83\xE7\x88\xB7#13885790967 column=0:BINLOG_TIME,
timestamp=1537254172859, value=\x80\x00\x01e\xEB}&]
105649041#\xE4\xB8\x83\xE7\x88\xB7#13885790967 column=0:CREATE_TIME,
timestamp=1537254172859, value=2018-09-18 15:02:52
105649041#\xE4\xB8\x83\xE7\x88\xB7#13885790967 column=0:LAST_MOD_TIME,
timestamp=1537254172859, value=2018-09-18 15:02:52
105649041#\xE4\xB8\x83\xE7\x88\xB7#13885790967 column=0:PHONE_NO,
timestamp=1537254172859, value=13885790967
105649041#\xE4\xB8\x83\xE7\x88\xB7#13885790967 column=0:SOURCE,
timestamp=1537254172859, value=\x80\x00\x00\x01
......
154941041##18604085555 column=0:UID, timestamp=1537254007372,
value=\x80\x00\x00\x00\x09<6q
154941041##18604085555 column=0:_0, timestamp=1537254007372, value=x
77 row(s) in 0.6480 seconds
we got the row which timestamp in [1537254007372, 1537254174086],
but we cannot get the row above
hbase(main):005:0> get 'ZEUS.LOAN_CONSUMER_CONTACT',
'72520206#KB李总2泥鳅83#13971083626'
COLUMN CELL
0 row(s) in 0.0030 seconds
> 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)
