Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive Error: UDFArgumentException Only string, char, varchar or binary data can be cast into binary data types

Hive Error: UDFArgumentException Only string, char, varchar or binary data can be cast into binary data types

Explorer

I am migrating data from vertica to Hadoop and one of the tables has a column of type VARBINARY(8). I mapped it to BINARY in hive and created an external table of the data I imported via Sqoop (imported as a csv file).

Now I want to create an ORC table and created a table exactly like the first ETL table but with some tableproperties and partitions. I am trying to do an

INSERT OVERWRITE TABLE orc_table PARTITION (partition_key) SELECT * FROM old_table;

I am getting an error:

FAILED: UDFArgumentException Only string, char, varchar or binary data can be cast into binary data types.

at the insert overwrite part. Please advise

Don't have an account?
Coming from Hortonworks? Activate your account here