[
https://issues.apache.org/jira/browse/HIVE-7641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14176748#comment-14176748
]
Navis commented on HIVE-7641:
-----------------------------
[~xuefuz] From HIVE-4144, "select x" is supported regarding the source is a
table with single null row.
> INSERT ... SELECT with no source table leads to NPE
> ---------------------------------------------------
>
> Key: HIVE-7641
> URL: https://issues.apache.org/jira/browse/HIVE-7641
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.13.1
> Reporter: Lenni Kuff
> Assignee: Navis
> Attachments: HIVE-7641.1.patch.txt, HIVE-7641.2.patch.txt
>
>
> When no source table is provided for an INSERT statement Hive fails with NPE.
> {code}
> 0: jdbc:hive2://localhost:11050/default> create table test_tbl(i int);
> No rows affected (0.333 seconds)
> 0: jdbc:hive2://localhost:11050/default> insert into table test_tbl select 1;
> Error: Error while compiling statement: FAILED: NullPointerException null
> (state=42000,code=40000)
> -- Get a NPE even when using incorrect syntax (no TABLE keyword)
> 0: jdbc:hive2://localhost:11050/default> insert into test_tbl select 1;
> Error: Error while compiling statement: FAILED: NullPointerException null
> (state=42000,code=40000)
> -- Works when a source table is provided
> 0: jdbc:hive2://localhost:11050/default> insert into table test_tbl select 1
> from foo;
> No rows affected (5.751 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
