Impala does not support row level INSERT, UPDATE, and DELETE. Impala-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.