Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A9FEF107A7 for ; Thu, 4 Dec 2014 18:51:13 +0000 (UTC) Received: (qmail 61772 invoked by uid 500); 4 Dec 2014 18:51:13 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 61716 invoked by uid 500); 4 Dec 2014 18:51:13 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 61700 invoked by uid 99); 4 Dec 2014 18:51:13 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Dec 2014 18:51:13 +0000 Date: Thu, 4 Dec 2014 18:51:13 +0000 (UTC) From: "Krystal (JIRA)" To: dev@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-1809) Select * from multi-regions hbase table fails MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Krystal created DRILL-1809: ------------------------------ Summary: 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 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)