Ashutosh Chauhan created HIVE-18792:
---------------------------------------
Summary: Allow standard compliant syntax for insert on partitioned
tables
Key: HIVE-18792
URL: https://issues.apache.org/jira/browse/HIVE-18792
Project: Hive
Issue Type: Improvement
Components: SQL
Reporter: Ashutosh Chauhan
Following works:
{code}
create table t1 (a int, b int, c int);
create table t2 (a int, b int, c int) partitioned by (d int);
insert into t1 values (1,2,3);
insert into t1 (c, b, a) values (1,2,3);
insert into t1 (a,b) values (1,2);
{code}
For partitioned tables it should work similarly but doesn't. All of following
fails:
{code}
insert into t2 values (1,2,3,4);
insert into t2 (a, b, c, d) values (1,2,3,4);
insert into t2 (c,d) values (1,2);
insert into t2 (a,b) values (1,2);
{code}
All of above should work. Also note following works:
{code}
insert into t2 partition(d) values (1,2,3,4);
insert into t2 partition(d=4) values (1,2,3);
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
