Ashutosh Chauhan created HIVE-18792:

             Summary: Allow standard compliant syntax for insert on partitioned 
                 Key: HIVE-18792
             Project: Hive
          Issue Type: Improvement
          Components: SQL
            Reporter: Ashutosh Chauhan

Following works:


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);


For partitioned tables it should work similarly but doesn't.  All of following 


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);


All of above should work. Also note following works:


insert into t2 partition(d)  values (1,2,3,4);

insert into t2 partition(d=4)  values (1,2,3);



This message was sent by Atlassian JIRA

Reply via email to