You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Alexander Zarei (JIRA)" <ji...@apache.org> on 2014/12/04 20:46:12 UTC
[jira] [Commented] (DRILL-1809) Select * from multi-regions hbase
table fails
[ https://issues.apache.org/jira/browse/DRILL-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14234541#comment-14234541 ]
Alexander Zarei commented on DRILL-1809:
----------------------------------------
This is the the content of my git.properties file
#Generated by Git-Commit-Id-Plugin
#Thu Dec 04 10:51:27 PST 2014
git.commit.id.abbrev=4a4f54a
git.commit.user.email=jacques@apache.org
git.commit.message.full=Disable failing large compilation test due to overuse of memory on fast schema return. To be fixed as part of DRILL-1808\n
git.commit.id=4a4f54a54d6454143ba90f9a2a2ecdc8f38e2910
git.commit.message.short=Disable failing large compilation test due to overuse of memory on fast schema return. To be fixed as part of DRILL-1808
git.commit.user.name=Jacques Nadeau
git.build.user.name=Unknown
git.commit.id.describe=drill-1.0.0-m1-995-g4a4f54a
git.build.user.email=Unknown
git.branch=master
git.commit.time=03.12.2014 @ 21\:15\:03 PST
git.build.time=04.12.2014 @ 10\:51\:26 PST
git.remote.origin.url=https\://github.com/apache/drill.git
Sqlline interaction:
[root@192 bin]# ./sqlline -u jdbc:drill:zk=localhost:5181
sqlline version 1.1.6
0: jdbc:drill:zk=localhost:5181> select * from INFORMATION_SCHEMA.SCHEMATA;
+--------------+-------------+--------------+------------+------------+
| CATALOG_NAME | SCHEMA_NAME | SCHEMA_OWNER | TYPE | IS_MUTABLE |
+--------------+-------------+--------------+------------+------------+
| DRILL | hive43.default | <owner> | hive | NO |
| DRILL | dfs.default | <owner> | file | NO |
| DRILL | dfs.root | <owner> | file | NO |
| DRILL | dfs.tmp | <owner> | file | YES |
| DRILL | cp.default | <owner> | file | NO |
| DRILL | hbase | <owner> | hbase | NO |
| DRILL | sys | <owner> | system-tables | NO |
| DRILL | INFORMATION_SCHEMA | <owner> | ischema | NO |
+--------------+-------------+--------------+------------+------------+
8 rows selected (0.26 seconds)
0: jdbc:drill:zk=localhost:5181> SELECT * FROM `hbase`.`MultiRegion` LIMIT 100;
Query failed: Query failed: Failure while running fragment.[ c49bc405-d82e-431b-acfc-76709fed3b22 on 192.168.39.44:31010 ]
[ c49bc405-d82e-431b-acfc-76709fed3b22 on 192.168.39.44:31010 ]
Error: exception while executing query: Failure while executing query. (state=,code=0)
> 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: 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)