[jira] [Commented] (DRILL-2571) convert_from fails with ' Wrong length 1(1-0) in the buffer '1', expected 4.'

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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