You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Prasad Nagaraj Subramanya (JIRA)" <ji...@apache.org> on 2017/08/04 23:53:00 UTC

[jira] [Updated] (DRILL-5705) Select * on hbase table having multiple regions and multiple schema returns wrong result

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

Prasad Nagaraj Subramanya updated DRILL-5705:
---------------------------------------------
    Description: 
Repro steps-

1) Create a hbase table with 4 regions-
{code}
create 'myhbase', 'cf1','cf2', {SPLITS => ['a', 'b', 'c']}
put 'myhbase','a','cf1:col1','somedata'
put 'myhbase','b','cf1:col2','somedata'
put 'myhbase','c','cf2:col1','somedata'
put 'myhbase', 'd','cf1:col1','somedata'
put 'myhbase', 'd','cf2:col1','somedata'
{code}

2) Run select * on the hbase table
{code}
Select * from hbase.myhbase;
{code}

The query returns wrong result, and the result is not consistent across multiple runs.

  was:
Repro steps-

1) Create a hbase table with 4 regions-
{code}
create 'myhbase', 'cf1','cf2', {SPLITS => ['a', 'b', 'c']}
put 'myhbase','a','cf1:col1','somedata'
put 'myhbase','b','cf1:col2','somedata'
put 'myhbase','c','cf2:col1','somedata'
put 'myhbase', 'd', 'cf1:col1', 'somedata'
put 'myhbase', 'd', 'cf2:col1', 'somedata'
{code}

2) Run select * on the hbase table
{code}
Select * from hbase.myhbase;
{code}

The query returns wrong result, and the result is not consistent across multiple runs.


> Select * on hbase table having multiple regions and multiple schema returns wrong result
> ----------------------------------------------------------------------------------------
>
>                 Key: DRILL-5705
>                 URL: https://issues.apache.org/jira/browse/DRILL-5705
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.11.0
>            Reporter: Prasad Nagaraj Subramanya
>
> Repro steps-
> 1) Create a hbase table with 4 regions-
> {code}
> create 'myhbase', 'cf1','cf2', {SPLITS => ['a', 'b', 'c']}
> put 'myhbase','a','cf1:col1','somedata'
> put 'myhbase','b','cf1:col2','somedata'
> put 'myhbase','c','cf2:col1','somedata'
> put 'myhbase', 'd','cf1:col1','somedata'
> put 'myhbase', 'd','cf2:col1','somedata'
> {code}
> 2) Run select * on the hbase table
> {code}
> Select * from hbase.myhbase;
> {code}
> The query returns wrong result, and the result is not consistent across multiple runs.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)