Apache Hive Cookbook

Inserting values into tables from SQL

In this recipe, you will learn how to insert data from SQL into a table in Hive.

Inserting data into a Hive table through a SQL statement is the third variant of inserting data. This is the traditional way of inserting data into a table in any RDBMS. Inserting in a table through SQL statements can only be performed if the table supports ACID. The general format of inserting data into a table is as follows:

INSERT INTO TABLE table_name [PARTITION (partcol1[=val1], partcol2[=val2] ...)] VALUES values_row [, values_row ...]

Where:

• tablename: This is the name of the table
• values_row: This is the value that is to be inserted into the table

Getting ready

This recipe requires having Hive installed as described in the ...