skip to main content
SQL Functionality for the Driver for Apache Hive : Restrictions : Insert and Update Restrictions
  
Insert and Update Restrictions
Apache Hive does not support row level INSERT, UPDATE, and DELETE. Hive-specific syntax provides limited INSERT support:
*INSERT INTO is supported.
*INSERT OVERWRITE is supported.
*The name of the target table for an Insert must be prefixed by table, for example, INSERT INTO table gtable …
Column lists are not supported. Values for all columns must be specified.