question Re: Hive 3 export single ORC file in Support Questions

Hive 3 export single ORC file

bob_zhao — Wed, 26 Dec 2018 16:19:21 GMT

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

ekoifman — Thu, 27 Dec 2018 04:07:27 GMT

You can use the Export Table command

bob_zhao — Thu, 27 Dec 2018 09:50:49 GMT

Hi Eugene,

Thanks for the quick response! It works well.

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