skip to main content
Supported SQL Functionality and Extensions for The Driver for Apache Hive : Restrictions : Insert and Update Restrictions
  
Insert and Update Restrictions
Apache Hive does not support row level 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.