INSERT INTO SELECT statement
DataStax Enterprise supports the INSERT INTO SELECT statement in Hive.
DataStax Enterprise supports the INSERT INTO SELECT statement in Hive. You set a TBL and SERDE property, and use INSERT INTO SELECT to copy data from one table and insert it into another, or the same, table.
Supported TBL and SERDE properties include the following SERDE property:
cql3.update.columns
You use cql3.update.columns in conjunction with the CQL output query property, cql3.output.query.
The following example shows how to configure these properties and use the INSERT INTO SELECT statement in Hive to insert selective columns from a table into another row of the same Cassandra table. The SELECT statement requires values for each column in the target table. Using fake values satisfies this requirement.