Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0C489175DC for ; Wed, 1 Apr 2015 16:06:53 +0000 (UTC) Received: (qmail 39945 invoked by uid 500); 1 Apr 2015 16:06:53 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 39917 invoked by uid 500); 1 Apr 2015 16:06:52 -0000 Mailing-List: contact issues-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 issues@drill.apache.org Received: (qmail 39907 invoked by uid 99); 1 Apr 2015 16:06:52 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Apr 2015 16:06:52 +0000 Date: Wed, 1 Apr 2015 16:06:52 +0000 (UTC) From: "Jacques Nadeau (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-2571) convert_from fails with ' Wrong length 1(1-0) in the buffer '1', expected 4.' MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390892#comment-14390892 ] Jacques Nadeau commented on DRILL-2571: --------------------------------------- Please confirm the bytes using hbase shell. I actually think that hive stores data as strings by default in hbase. I saw there is a binary option since hive 0.9 but not sure what encoding it uses. The error message could be better but Drill is complaining here about the fact that the data returned from HBase is 1 byte while the 'INT' encoding is a four byte little endian encoding and MUST be four bytes. > convert_from fails with ' Wrong length 1(1-0) in the buffer '1', expected 4.' > ----------------------------------------------------------------------------- > > Key: DRILL-2571 > URL: https://issues.apache.org/jira/browse/DRILL-2571 > Project: Apache Drill > Issue Type: Bug > Components: Storage - HBase > Affects Versions: 0.8.0 > Reporter: Rahul Challapalli > Assignee: Aditya Kishore > Priority: Critical > Fix For: 0.9.0 > > Attachments: dataload.hql, error.log > > > git.commit.id.abbrev=f1b59ed > Hbase : > {code} > create 'fewtypes_null', 'types' > put 'fewtypes_null', 1, 'types:int_col', 1 > {code} > Now from Drill : > {code} > select * from fewtypes_null; > +------------+------------+ > | row_key | types | > +------------+------------+ > | [B@2461ae9c | {"int_col":"MQ=="} | > {code} > The below query fails : > {code} > select convert_from(a.types.int_col, 'INT') from fewtypes_null a; > Query failed: RemoteRpcException: Failure while running fragment., Wrong length 1(1-0) in the buffer '1', expected 4. [ f9a3bb31-bb19-428c-8c7d-99e1898e66e7 on qa-node114.qa.lab:31010 ] > [ f9a3bb31-bb19-428c-8c7d-99e1898e66e7 on qa-node114.qa.lab:31010 ] > {code} > I attached the complete error from the logs. Let me know if you need anything else -- This message was sent by Atlassian JIRA (v6.3.4#6332)