Support Questions
Find answers, ask questions, and share your expertise

Getting an error while selecting Binary data ORC files?

Highlighted

Getting an error while selecting Binary data ORC files?

Contributor

12158-binary-select-issue.jpg

I had used the following sqoop command to import db2 data which is defined as BLOB into Hive in ORC format.

sqoop import \ --connect "jdbc:db2://******/DB22" --username ***** --password '******' \ --table temp --map-column-hive row_id=String,binary_id=Binary --map-column-java row_id=String -m 1 --hcatalog-database temp_database --hcatalog-table temp_table --create-hcatalog-table --hcatalog-storage-stanza "stored as orcfile"

1) Table is created in Hive (one column is having binary data,rest of the columns are in STRING format) and

when I do , select count(*) from temp_table; --

I am able to get the count When I select without that one Binary column also ,I am able to pull the result.

But, 2) When I try to select something (including Binary column) from that table like below.

select * from temp_table limit 1; I am getting below error:,

Please help.

3 REPLIES 3
Highlighted

Re: Getting an error while selecting Binary data ORC files?

Mentor

What is the output of command below and why do you map row_id to hive and java, use one or the other

select row_id, base64(binary_id) limit 1;

Re: Getting an error while selecting Binary data ORC files?

Contributor

@Artem Ervits Thanks for your reply. I tried it but no results and no errors.

Highlighted

Re: Getting an error while selecting Binary data ORC files?

Mentor
@Sankar T

can you take a look at the class generated after your sqoop and verify the data type for binary_id?