insert partitions into orc table from text format table

[#1]

Hi all,

I have a text format table, to compress i have created an orc table and inserting partitions(date, hour) from text to orc table, what is the fastest way to do this? right now i am doing like this:

insert into table orc_table partition(date, hour) select * from text_table where date=20180206 and hour=0;

Instead can i do it for whole day? or month? in one select statement?

Please help.

[#2]

Hey, I wonder did you solve this problem? If yes, is there a chance that you could share the solution? 🙂