Inserting data into dynamic partitions

Until now, we have learned how to insert data into partitions in a table one at a time. For that, it was important for us to know in which partition we need to insert data. Further, only one partition can be inserted using one INSERT statement. Now, we will learn how to insert data into multiple partitions through a single statement. The general syntax of inserting data into multiple partitions is as follows:

FROM tablename
INSERT OVERWRITE TABLE tablename1 PARTITION(root_partition_name='value',child_partition_name)
SELECT select_statment;

Where:

• tablename: This is the name of the table from which the value is to be taken by the select statement

• tablename1: This is the name of the table in which the data will be inserted

• root_partition_name: This is the static partition column

• child_partition_name: This is the dynamic partition column

Getting ready

This recipe requires having Hive installed as described in the Installing Hive recipe of Chapter 1, Developing...