[HIVE-18792] Allow standard compliant syntax for insert on partitioned tables

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.0
• Component/s: SQL
• Labels: TODOC3.1
• Assignee: Vineet Garg
• Reporter: Ashutosh Chauhan
• Created: 24/Feb/18 00:03
• Updated: 31/Jul/18 01:33
• Resolved: 02/Jun/18 16:56

Description

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 fails:

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

 

Sub-Tasks

• Make partition clause optional for INSERT: Closed
• Support Analyze table for partitioned tables without partition spec: Closed