Well, it's weird that puts with such TS values were allowed, according to current code state. Can you afford delete the whole CF for those rows?
Em qua., 29 de abr. de 2020 às 14:41, junhyeok park <runnerren...@gmail.com> escreveu: > I've been through the same thing. I use 2.2.0 > > 2020년 4월 29일 (수) 오후 10:32, Alexander Batyrshin <0x62...@gmail.com>님이 작성: > > > As you can see in example I already tried DELETE operation with timestamp > > = Long.MAX_VALUE without any success. > > > > > On 29 Apr 2020, at 12:41, Wellington Chevreuil < > > wellington.chevre...@gmail.com> wrote: > > > > > > 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> > > > escreveu: > > > > > >> Hello all, > > >> We had faced with strange situation: table has rows with > Long.MAX_VALUE > > >> timestamp. > > >> These rows impossible to delete, because DELETE mutation uses > > >> System.currentTimeMillis() timestamp. > > >> Is there any way to delete these rows? > > >> We use HBase-1.4.10 > > >> > > >> Example: > > >> > > >> hbase(main):037:0> scan 'TRACET', { ROWPREFIXFILTER => > > "\x0439d58wj434dd", > > >> RAW=>true, VERSIONS=>10} > > >> ROW > COLUMN+CELL > > >> \x0439d58wj434dd column=d:_0, > > >> timestamp=9223372036854775807, value=x > > >> > > >> > > >> hbase(main):045:0* delete 'TRACET', "\x0439d58wj434dd", "d:_0" > > >> 0 row(s) in 0.0120 seconds > > >> > > >> hbase(main):046:0> scan 'TRACET', { ROWPREFIXFILTER => > > "\x0439d58wj434dd", > > >> RAW=>true, VERSIONS=>10} > > >> ROW > COLUMN+CELL > > >> \x0439d58wj434dd column=d:_0, > > >> timestamp=9223372036854775807, value=x > > >> \x0439d58wj434dd column=d:_0, > > >> timestamp=1588146570005, type=Delete > > >> > > >> > > >> hbase(main):047:0> delete 'TRACET', "\x0439d58wj434dd", "d:_0", > > >> 9223372036854775807 > > >> 0 row(s) in 0.0110 seconds > > >> > > >> hbase(main):048:0> scan 'TRACET', { ROWPREFIXFILTER => > > "\x0439d58wj434dd", > > >> RAW=>true, VERSIONS=>10} > > >> ROW > COLUMN+CELL > > >> \x0439d58wj434dd column=d:_0, > > >> timestamp=9223372036854775807, value=x > > >> \x0439d58wj434dd column=d:_0, > > >> timestamp=1588146678086, type=Delete > > >> \x0439d58wj434dd column=d:_0, > > >> timestamp=1588146570005, type=Delete > > >> > > >> > > >> > > >> > > > > >
