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)