?????? How to delete row with Long.MAX_VALUE timestamp

[zheng wang]

It seems like the Long.MAX_VALUE is a special value, if set it as the 
timestamp , will be changed to current time.






------------------ ???????? ------------------
??????:&nbsp;"Wellington Chevreuil"<wellington.chevre...@gmail.com&gt;;
????????:&nbsp;2020??4??29??(??????) ????5:41
??????:&nbsp;"Hbase-User"<user@hbase.apache.org&gt;;

????:&nbsp;Re: How to delete row with Long.MAX_VALUE timestamp



That's expected behaviour [1]. If you are "travelling to the future", you
need to do a delete specifying Long.MAX_VALUE timestamp as the timestamp
optional parameter in the delete operation [2], if you don't specify
timestamp on the delete, it will assume current time for the delete marker,
which will be smaller than the Long.MAX_VALUE set to your cells, so scans
wouldn't filter it.

[1] https://hbase.apache.org/book.html#version.delete
[2]
https://github.com/apache/hbase/blob/branch-1.4/hbase-client/src/main/java/org/apache/hadoop/hbase/client/Delete.java#L98

Em qua., 29 de abr. de 2020 ??s 08:57, Alexander Batyrshin 
<0x62...@gmail.com&gt;
escreveu:

&gt;&nbsp; Hello all,
&gt; We had faced with strange situation: table has rows with Long.MAX_VALUE
&gt; timestamp.
&gt; These rows impossible to delete, because DELETE mutation uses
&gt; System.currentTimeMillis() timestamp.
&gt; Is there any way to delete these rows?
&gt; We use HBase-1.4.10
&gt;
&gt; Example:
&gt;
&gt; hbase(main):037:0&gt; scan 'TRACET', { ROWPREFIXFILTER =&gt; 
"\x0439d58wj434dd",
&gt; RAW=&gt;true, VERSIONS=&gt;10}
&gt; 
ROW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 COLUMN+CELL
&gt;&nbsp; 
\x0439d58wj434dd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 column=d:_0,
&gt; timestamp=9223372036854775807, value=x
&gt;
&gt;
&gt; hbase(main):045:0* delete 'TRACET', "\x0439d58wj434dd", "d:_0"
&gt; 0 row(s) in 0.0120 seconds
&gt;
&gt; hbase(main):046:0&gt; scan 'TRACET', { ROWPREFIXFILTER =&gt; 
"\x0439d58wj434dd",
&gt; RAW=&gt;true, VERSIONS=&gt;10}
&gt; 
ROW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 COLUMN+CELL
&gt;&nbsp; 
\x0439d58wj434dd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 column=d:_0,
&gt; timestamp=9223372036854775807, value=x
&gt;&nbsp; 
\x0439d58wj434dd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 column=d:_0,
&gt; timestamp=1588146570005, type=Delete
&gt;
&gt;
&gt; hbase(main):047:0&gt; delete 'TRACET', "\x0439d58wj434dd", "d:_0",
&gt; 9223372036854775807
&gt; 0 row(s) in 0.0110 seconds
&gt;
&gt; hbase(main):048:0&gt; scan 'TRACET', { ROWPREFIXFILTER =&gt; 
"\x0439d58wj434dd",
&gt; RAW=&gt;true, VERSIONS=&gt;10}
&gt; 
ROW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 COLUMN+CELL
&gt;&nbsp; 
\x0439d58wj434dd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 column=d:_0,
&gt; timestamp=9223372036854775807, value=x
&gt;&nbsp; 
\x0439d58wj434dd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 column=d:_0,
&gt; timestamp=1588146678086, type=Delete
&gt;&nbsp; 
\x0439d58wj434dd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 column=d:_0,
&gt; timestamp=1588146570005, type=Delete
&gt;
&gt;
&gt;
&gt;