hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eugene Koifman (JIRA)" <>
Subject [jira] [Created] (HIVE-9481) allow column list specification in INSERT statement
Date Tue, 27 Jan 2015 22:48:35 GMT
Eugene Koifman created HIVE-9481:

             Summary: allow column list specification in INSERT statement
                 Key: HIVE-9481
             Project: Hive
          Issue Type: Bug
          Components: Parser, Query Processor, SQL
    Affects Versions: 0.14.0
            Reporter: Eugene Koifman
            Assignee: Eugene Koifman

Given a table FOO(a int, b int, c int), ANSI SQL supports insert into FOO(c,b) select x,y
from T.  The expectation is that 'x' is written to column 'c' and 'y' is written column 'b'
and 'a' is set to NULL, assuming column 'a' is NULLABLE.

Hive does not support this.  In Hive one has to ensure that the data producing statement has
a schema that matches target table schema.

Since Hive doesn't support DEFAULT value for columns in CREATE TABLE, when target schema is
explicitly provided, missing columns will be set to NULL if they are NULLABLE, otherwise an
error will be raised.

If/when DEFAULT clause is supported, this can be enhanced to set default value rather than

This message was sent by Atlassian JIRA

View raw message