[HIVE-7641] INSERT ... SELECT with no source table leads to NPE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.1
• Fix Version/s: 1.2.0
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Lenni Kuff
• Created: 07/Aug/14 05:42
• Updated: 18/May/15 19:50
• Resolved: 14/May/15 02:09

Description

When no source table is provided for an INSERT statement Hive fails with NPE.

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)

Issue Links

• is duplicated by: HIVE-9923 No clear message when "from" is missing
• is related to: HIVE-5690 Support subquery for single sourced multi query