Hive 3 export single ORC file

[#1]

Hello,

Hive 3 changes a lot for internal table's ORC format.

How could I export a Hive 3 's table as ONE ORC file in simple ORC format without these new columns for transnational info ?

Thanks,

Bob

[#2 · Accepted solution]

You can use the Export Table command

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport#LanguageManualImportExp...

[#3]

Hi Eugene,

Thanks for the quick response! It works well.

EXPORT TABLE bob.tab222 TO '/bob/ttt' ;