sqoop2's target file format should be one of the supported types by hive (e.g. `ORC` or `RCBinary`) related links: - https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html#_file_formats - https://stackoverflow.com/questions/29978522/sqoop-import-as-orc-file - https://community.hortonworks.com/articles/9828/import-rdbms-into-hive-table-stored-as-orc-with-sq.html