[jira] [Commented] (HIVE-7641) INSERT ... SELECT with no source table leads to NPE

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-7641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14160302#comment-14160302 ] 

Xuefu Zhang commented on HIVE-7641:
-----------------------------------

Looking at the patch, it seems making more sense to return an error in the case, in order to be consist with regular "select x from table" query, in which error is given if "from table" is missed.

> 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
>
>
> 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)