drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2571) convert_from fails with ' Wrong length 1(1-0) in the buffer '1', expected 4.'
Date Wed, 01 Apr 2015 16:06:52 GMT

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

Mime
View raw message