Support Questions

Find answers, ask questions, and share your expertise

insert partitions into orc table from text format table

Expert Contributor

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.


New Contributor

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