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?