[
https://issues.apache.org/jira/browse/DRILL-5706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16172202#comment-16172202
]
Vitalii Diravka edited comment on DRILL-5706 at 9/20/17 5:40 PM:
-----------------------------------------------------------------
I have a reproduce on latest Drill master version:
{code}
0: jdbc:drill:> select myhbase.cf1 from hbase. myhbase;
+--------------------------+
| cf1 |
+--------------------------+
| {"col1":"c29tZWRhdGE="} |
| {"col1":"c29tZWRhdGE="} |
| {"col1":"c29tZWRhdGE="} |
+--------------------------+
3 rows selected (0.169 seconds)
0: jdbc:drill:> select myhbase.cf1 from hbase. myhbase;
+------+
| cf1 |
+------+
+------+
No rows selected (0.188 seconds)
{code}
Without fde0a1df1734e0 commit (fix for DRILL-5546) there is no this issue.
was (Author: vitalii):
[~prasadns14] Looks like the result is correct. Please verify:
{code}
0: jdbc:drill:> select * from hbase.myhbase;
+--------------+--------------------------+
| row_key | cf1 |
+--------------+--------------------------+
| [B@3486f312 | {"col1":"c29tZWRhdGE="} |
| [B@12e0f043 | {"col1":"c29tZWRhdGE="} |
| [B@6dbdc863 | {"col1":"c29tZWRhdGE="} |
+--------------+--------------------------+
3 rows selected (0.322 seconds)
0: jdbc:drill:> select convert_from(row_key, 'UTF8') as id,
convert_from(myhbase.cf1.col1, 'UTF8') col1 from hbase. myhbase;
+-----+-----------+
| id | col1 |
+-----+-----------+
| c | somedata |
| a | somedata |
| b | somedata |
+-----+-----------+
3 rows selected (0.262 seconds)
{code}
Note: the above result is the same for Drill-1.10 and Drill-1.12 master version.
> Select * on hbase table having multiple regions(one or more empty) returns
> wrong result intermittently
> ------------------------------------------------------------------------------------------------------
>
> Key: DRILL-5706
> URL: https://issues.apache.org/jira/browse/DRILL-5706
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Affects Versions: 1.11.0
> Reporter: Prasad Nagaraj Subramanya
> Assignee: Vitalii Diravka
>
> 1) Create a hbase table with 4 regions
> {code}
> create 'myhbase', 'cf1', {SPLITS => ['a', 'b', 'c']}
> put 'myhbase','a','cf1:col1','somedata'
> put 'myhbase','b','cf1:col1','somedata'
> put 'myhbase','c','cf1:col1','somedata'
> {code}
> 2) Run select * on the hbase table
> {code}
> select * from hbase.myhbase;
> {code}
> The query returns wrong result intermittently
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
