You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Lenni Kuff (JIRA)" <ji...@apache.org> on 2014/08/07 07:43:11 UTC

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

Lenni Kuff created HIVE-7641:
--------------------------------

             Summary: 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


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.2#6252)