[ 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)