[
https://issues.apache.org/jira/browse/DRILL-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14234826#comment-14234826
]
Steven Phillips commented on DRILL-1809:
----------------------------------------
I think you forgot to scan the first region:
Table Regions
Name Region Server Start Key End Key Requests
voter,,1417562291401.50135f2b2da1c885d6f2aa70d3901b8f.
qa-node113.qa.lab,60020,1417014204974 1 0
voter,1,1417562291401.8b277c1c4ca7c7ce19183ad0b57473de.
qa-node113.qa.lab,60020,1417014204974 1 2 13011
voter,2,1417562291401.e94274677ec5f440a0fdb6654578a797.
qa-node113.qa.lab,60020,1417014204974 2 3 5555
voter,3,1417562291401.a944238b7d9c149a3721bb412727bd7f.
qa-node113.qa.lab,60020,1417014204974 3 4 5545
voter,4,1417562291401.9c781289d8a6d9a56549d10ca1f3d476.
qa-node113.qa.lab,60020,1417014204974 4 5 5303
voter,5,1417562291402.c54c5145e0d9ac81950db4a0a7cf11b6.
qa-node113.qa.lab,60020,1417014204974 5 6 5414
voter,6,1417562291402.53c411fb0fa3da17dae429910168084c.
qa-node113.qa.lab,60020,1417014204974 6 7 5520
voter,7,1417562291402.69a1cbe6471137b356f42d152c488286.
qa-node113.qa.lab,60020,1417014204974 7 8 5525
voter,8,1417562291402.a89bacc0e3fb8b8a33e70226e6971057.
qa-node113.qa.lab,60020,1417014204974 8 9 5338
voter,9,1417562291402.82e048294376168528cfaabd0a55d8d4.
qa-node113.qa.lab,60020,1417014204974 9 5540
hbase(main):006:0> scan 'voter', STOPROW => '1'
ROW COLUMN+CELL
0 row(s) in 0.0070 seconds
So it looks like we are not correctly handling the case where a scanner returns
no records.
> Select * from multi-regions hbase table fails
> ---------------------------------------------
>
> Key: DRILL-1809
> URL: https://issues.apache.org/jira/browse/DRILL-1809
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Affects Versions: 0.7.0
> Reporter: Krystal
> Attachments: Alex_drillbit.out, alex_drillbit.log, hbase.log
>
>
> git.commit.id=58994af57cb65752027b121acc659ca8afa0ae45
> Selecting "*" from a hbase table with mulitple regions fails. For example,
> 0: jdbc:drill:schema=hbase> select * from voter limit 10;
> Query failed: Query failed: Failure while running fragment.[
> 9c1091d4-6714-46d9-afbc-1a812442c383 on qa-node114.qa.lab:31010 ]
> [ 9c1091d4-6714-46d9-afbc-1a812442c383 on qa-node114.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:schema=hbase> select * from voter limit 10;
> Query failed: Query failed: Failure while running fragment.[
> da56e55a-ca96-4df8-b6f4-e1726282941f on qa-node114.qa.lab:31010 ]
> [ da56e55a-ca96-4df8-b6f4-e1726282941f on qa-node114.qa.lab:31010 ]
> Attached is the server log for the above query.
> If perform a select "*" without a limit, partial rows are returned then
> failed:
> 0: jdbc:drill:schema=hbase> select * from voter;
> +------------+------------+------------+------------+------------+
> | row_key | fourcf | onecf | threecf | twocf |
> +------------+------------+------------+------------+------------+
> | [B@2ed26659 | {"create_date":"MjAxNC0wNS0yNyAwMTo1Njo0Mw=="} |
> {"name":"eGF2aWVyIHdoaXRl"} |
> {"contributions":"OTUxLjA1","voterzone":"NzMwMA=="} |
> {"age":"NDc=","registration":"aW5kZXBlbmRlbnQ="} |
> | [B@773d7512 | {"create_date":"MjAxNC0wNC0xMCAwNDozNTowNg=="} |
> {"name":"aG9sbHkgaGVybmFuZGV6"} |
> {"contributions":"NjIxLjQ0","voterzone":"Mjk3MTQ="} |
> {"age":"Mzc=","registration":"Z3JlZW4="} |
> | [B@63d12de6 | {"create_date":"MjAxNC0xMi0xMSAxMTo0Njo1Nw=="} |
> {"name":"aG9sbHkgYnJvd24="} |
> {"contributions":"NTMyLjA2","voterzone":"MTA0Nw=="} |
> {"age":"MzM=","registration":"bGliZXJ0YXJpYW4="} |
> | [B@3a1c8a3c | {"create_date":"MjAxNC0wNS0yMSAwNDoxMjozMQ=="} |
> {"name":"Ym9iIGVsbGlzb24="} |
> {"contributions":"ODc0LjE4","voterzone":"OTk1Mg=="} |
> {"age":"MzA=","registration":"cmVwdWJsaWNhbg=="} |
> | [B@27b786f2 | {"create_date":"MjAxNS0wMS0xOSAwMDo1NDo0NA=="} |
> {"name":"ZnJlZCBsYWVydGVz"} |
> {"contributions":"ODEuNDQ=","voterzone":"MjU1OTA="} |
> {"age":"MzY=","registration":"Z3JlZW4="} |
> .
> .
> .
> | [B@748f2244 | {"create_date":"MjAxNC0xMS0wMyAxNTo1NTozNg=="} |
> {"name":"aG9sbHkgc3RlaW5iZWNr"} |
> {"contributions":"ODEwLjY=","voterzone":"MTQ4MDk="} |
> {"age":"Mzg=","registration":"cmVwdWJsaWNhbg=="} |
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing
> query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> at sqlline.SqlLine.print(SqlLine.java:1809)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> at sqlline.SqlLine.dispatch(SqlLine.java:889)
> at sqlline.SqlLine.begin(SqlLine.java:763)
> at sqlline.SqlLine.start(SqlLine.java:498)
> at sqlline.SqlLine.main(SqlLine.java:460)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
