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.