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)

Reply via email to