My Oracle Support Banner

Exception: Unsupported file format: AvroDataFile Running Sqoop --hive-import with --as-avrodatafile or bogus data (Doc ID 1559906.1)

Last updated on OCTOBER 10, 2019

Applies to:

Big Data Appliance Integrated Software - Version and later
Linux x86-64


Running a sqoop import with --hive-import and --as-avrodatafile as something like:

sqoop import --connect <connection string> --as-avrodatafile ... --hive-import  --hive-table <hive_table>


ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Unsupported file format: AvroDataFile
java.lang.RuntimeException: Unsupported file format: AvroDataFile


Running  sqoop with --hive-import and --as-avrodatafile or  running sqoop with --hive-import and --as-sequenfilefile raises no errors, loads the table successfully, however querying the Hive table returns bogus characters.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.