Apache Hive Cookbook

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 ...