How can create the dynamic partition table with data in Hive

Question

Can anyone suggest how to create the dynamic partition table with data in Hive?

Answer 1

Hi,

We can see some steps to do that:

• Create a non-partitioned table X and load the data
• Now create a partitioned table Y and specify the partition column (say state)
• Load data from X to Y like below

You can use this command to create that:

hive> INSERT INTO TABLE Y PARTITION(state) SELECT * from X;

Here you should ensure that the partition column is the last column of the non-partitioned table.