question Re: Can Sqoop export ORC? in Archives of Support Questions (Read Only)

Can Sqoop export ORC?

koosha_tahmaseb — Sat, 29 Oct 2016 01:06:03 GMT

Hi, Is it possible to export ORC files using Sqoop? I need to export from Hive to another DBMS which also supports ORC, therefore I would prefer to directly export ORC files without any needs to do conversions.

Re: Can Sqoop export ORC?

gkeys — Sat, 29 Oct 2016 01:43:02 GMT

You can.

Please see this excellent answer for importing ORC

https://community.hortonworks.com/questions/28060/can-sqoop-be-used-to-directly-import-data-into-an.html

and this one for exporting ORC

https://hadoopist.wordpress.com/2015/09/09/how-to-export-a-hive-orc-table-to-a-oracle-database/

Re: Can Sqoop export ORC?

vintec — Wed, 22 Jul 2020 20:15:44 GMT

Is it possible to add filtering condition also while exporting from the ORC table? My point is consider I am having an ORC table 'sampleORC' with column 'name'. I only need to export the data with name ='Demo' from sampleORC