Hi all,

Not sure whether I can ask questions to this group, if not, kindly ignore
this email and thanks for the time.

I query HBase from Drill.
In the HBase table, I have a column family called log and a column log:ra
for some money amount.

I want to convert the HBase binary data into INT for the column and I use:

select convert_from(activities_perf.log.ra, 'INT') FROM activities_perf;
However, error says "Query failed: RemoteRpcException: Failure while
running fragment., Wrong length 2(2-0) in the buffer '74', expected 4. [
77ba1d80-da84-443f-bb7d-5e0c8f86f68f on local104:31010 ]", what is that?

I can query the data by "select SUM(CAST(activities_perf.log.ra AS INT))
FROM activities_perf;"

Thanks!

Regards,
George Lu

Reply via email to