how do i create hive orc table and how to load the data in same orc hive table using only sqoop import command?

[#1 · Accepted solution]

See the following on creating ORC tables (it is mostly a matter of using "stored as ORC"):

• http://hadooptutorial.info/hive-table-creation-commands/#Example_3_8211_External_Table_with_ORC_File...
• https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL

To use sqoop to import to Hive ORC table, see:

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

[#2]

No. It does not working, by the way what really works in cloudera platform??