You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Eugene Koifman (JIRA)" <ji...@apache.org> on 2015/01/27 23:48:35 UTC

[jira] [Created] (HIVE-9481) allow column list specification in INSERT statement

Eugene Koifman created HIVE-9481:
------------------------------------

             Summary: allow column list specification in INSERT statement
                 Key: HIVE-9481
                 URL: https://issues.apache.org/jira/browse/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 NULL.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)