You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2018/02/24 00:04:00 UTC
[jira] [Created] (HIVE-18792) Allow standard compliant syntax for
insert on partitioned tables
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)