[DRILL-1809] Select * from multi-regions hbase table fails

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.7.0
• Fix Version/s: Future
• Component/s: Storage - HBase
• Assignee: Unassigned
• Reporter: Krystal
• Created: 04/Dec/14 18:51
• Updated: 01/Oct/15 16:36

Description

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)