drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1809) Select * from multi-regions hbase table fails
Date Thu, 04 Dec 2014 22:55:12 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14234756#comment-14234756
] 

Krystal commented on DRILL-1809:
--------------------------------

I did a scan using startrow and endrow from hbase shell and all regions returned data.

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

Mime
View raw message