Member since
05-13-2019
3
Posts
0
Kudos Received
0
Solutions
06-04-2019
07:39 AM
Okay. Thanks! But the insertion of data takes too much time for a table with 38M records. Is there any efficient way or trick to do the insertion process faster? @Lester Martin
... View more
06-03-2019
01:41 AM
I have a table with 38M rows which is being updated daily. The table is in orc format and it is managed table. I want to create partitions on that table but I couldn't find a way to alter existing non-partitioned table to create partitions in that table. I tried searching all over the google but the only option I was able to find was Create a new partitioned table and insert data into it from the old table. I was wondering if there was any way to create partitions on an existing table. My HIVE version is 3.1. Thanks & Regards, Kartik
... View more
Labels: