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 Installing Hive recipe of Chapter 1, Developing Hive. You will also need the Hive CLI or Beeline client to run the commands.

This recipe requires transactions to be enabled, so refer to Enabling transactions in Hive for that (https://cwiki.apache.org...