Can Sqoop export ORC?

[#1]

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.

[#2 · Accepted solution]

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....

and this one for exporting ORC

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

[#3]

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