You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Devi Sunil Kumar Shegu <su...@gmail.com> on 2017/03/02 09:48:19 UTC
Scan and Get - different results
Hi,
Scan and get are yielding different results for the same column even when
versioning is disabled.
Thanks in advance and please check the details below
Description of the table:
{NAME => 'u', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false',
KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL =>
'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE =>
'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}
Query 1:
get 'tableName', 'status', 'u:1206'
colum: u:1206 ----value: registered ------ timestamp: 1488446959115
Query 2:
scan 'tableName', {FILTER => "ValueFilter(=, 'binary:anonymous')", COLUMNS
=> 'u:1206', STARTROW=>'status', STOPROW=> 'status'}
key:status column=u:1206 value=anonymous timestamp: 1488446869428
One column has two values when versioned is disabled. Any insights?
Re: Scan and Get - different results
Posted by Jean-Marc Spaggiari <je...@spaggiari.org>.
Can that not be causes by the filter? What scan gives you if you remove the
filter?
2017-03-02 11:03 GMT-05:00 Ted Yu <yu...@gmail.com>:
> When you issue raw scan, what output do you get ?
>
> hbase> scan 't1', {RAW => true}
>
> BTW looks like you have row key 'status', I am bit curious what your schema
> is - 'status' is such general term.
>
> On Thu, Mar 2, 2017 at 1:48 AM, Devi Sunil Kumar Shegu <
> sunil143devi@gmail.com> wrote:
>
> > Hi,
> >
> > Scan and get are yielding different results for the same column even when
> > versioning is disabled.
> >
> > Thanks in advance and please check the details below
> >
> > Description of the table:
> >
> > {NAME => 'u', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY =>
> 'false',
> > KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL =>
> > 'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE =>
> > 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}
> >
> > Query 1:
> >
> > get 'tableName', 'status', 'u:1206'
> > colum: u:1206 ----value: registered ------ timestamp: 1488446959115
> >
> >
> > Query 2:
> >
> > scan 'tableName', {FILTER => "ValueFilter(=, 'binary:anonymous')",
> COLUMNS
> > => 'u:1206', STARTROW=>'status', STOPROW=> 'status'}
> >
> > key:status column=u:1206 value=anonymous timestamp: 1488446869428
> >
> >
> > One column has two values when versioned is disabled. Any insights?
> >
>
Re: Scan and Get - different results
Posted by Ted Yu <yu...@gmail.com>.
When you issue raw scan, what output do you get ?
hbase> scan 't1', {RAW => true}
BTW looks like you have row key 'status', I am bit curious what your schema
is - 'status' is such general term.
On Thu, Mar 2, 2017 at 1:48 AM, Devi Sunil Kumar Shegu <
sunil143devi@gmail.com> wrote:
> Hi,
>
> Scan and get are yielding different results for the same column even when
> versioning is disabled.
>
> Thanks in advance and please check the details below
>
> Description of the table:
>
> {NAME => 'u', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false',
> KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL =>
> 'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE =>
> 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}
>
> Query 1:
>
> get 'tableName', 'status', 'u:1206'
> colum: u:1206 ----value: registered ------ timestamp: 1488446959115
>
>
> Query 2:
>
> scan 'tableName', {FILTER => "ValueFilter(=, 'binary:anonymous')", COLUMNS
> => 'u:1206', STARTROW=>'status', STOPROW=> 'status'}
>
> key:status column=u:1206 value=anonymous timestamp: 1488446869428
>
>
> One column has two values when versioned is disabled. Any insights?
>
Re: Scan and Get - different results
Posted by Ted Yu <yu...@gmail.com>.
Actually this is manifestation of HBASE-17125
On Thu, Mar 2, 2017 at 1:48 AM, Devi Sunil Kumar Shegu <
sunil143devi@gmail.com> wrote:
> Hi,
>
> Scan and get are yielding different results for the same column even when
> versioning is disabled.
>
> Thanks in advance and please check the details below
>
> Description of the table:
>
> {NAME => 'u', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMORY => 'false',
> KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'NONE', TTL =>
> 'FOREVER', COMPRESSION => 'NONE', MIN_VERSIONS => '0', BLOCKCACHE =>
> 'true', BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}
>
> Query 1:
>
> get 'tableName', 'status', 'u:1206'
> colum: u:1206 ----value: registered ------ timestamp: 1488446959115
>
>
> Query 2:
>
> scan 'tableName', {FILTER => "ValueFilter(=, 'binary:anonymous')", COLUMNS
> => 'u:1206', STARTROW=>'status', STOPROW=> 'status'}
>
> key:status column=u:1206 value=anonymous timestamp: 1488446869428
>
>
> One column has two values when versioned is disabled. Any insights?
>