Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sun, 26 Mar 2017 21:22:41 +0000 (UTC)
From: "Kostyantyn Oliynyk (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13059241.1490561873000.126518.1490563361547@Atlassian.JIRA>
In-Reply-To: <JIRA.13059241.1490561873000@Atlassian.JIRA>
References: <JIRA.13059241.1490561873000@Atlassian.JIRA> <JIRA.13059241.1490561873611@jira-lw-us.apache.org>
Subject: [jira] [Updated] (HIVE-16300) Allow specify target table columns in
 static partition insert
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sun, 26 Mar 2017 21:22:46 -0000


     [ https://issues.apache.org/jira/browse/HIVE-16300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kostyantyn Oliynyk updated HIVE-16300:
--------------------------------------
    Description: 
It is not possible specify target table columns in static partition insert.
SQL parser will throw an error if fields from sub select does not match target table fields.

For example for the following table

{code}
CREATE TABLE my_table(col1 STRING, col2 STRING, col3 STRING) PARTITIONED BY (pool STRING);
{code)

following insert will failed due to different number of fields in select and in target table:

{code} 
INSERT OVERWRITE TABLE my_table
PARTITION(pcol='TEST')
SELECT 'A' as a, 'B'as b;
{code}

Proposed change adds support for the following syntax:
{code} 
INSERT OVERWRITE TABLE my_table
PARTITION(pcol='TEST')
*(col1, col3)*
SELECT 'A' as a, 'B'as b;
{code}


  was:
It is not possible specify target table columns in static partition insert.
SQL parser will throw an error if fields from sub select does not match target table fields.

For example for the following table
{code}
CREATE TABLE my_table(col1 STRING, col2 STRING, col3 STRING) PARTITIONED BY (pool STRING);
{code)
following insert will failed due to different number of fields in select and in target table:
{code} 
INSERT OVERWRITE TABLE my_table
PARTITION(pcol='TEST')
SELECT 'A' as a, 'B'as b;
{code}

Proposed change adds support for the following syntax:
{code} 
INSERT OVERWRITE TABLE my_table
PARTITION(pcol='TEST')
*(col1, col3)*
SELECT 'A' as a, 'B'as b;
{code}


> Allow specify target table columns in static partition insert
> -------------------------------------------------------------
>
>                 Key: HIVE-16300
>                 URL: https://issues.apache.org/jira/browse/HIVE-16300
>             Project: Hive
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.1.1
>            Reporter: Kostyantyn Oliynyk
>            Priority: Trivial
>
> It is not possible specify target table columns in static partition insert.
> SQL parser will throw an error if fields from sub select does not match target table fields.
> For example for the following table
> {code}
> CREATE TABLE my_table(col1 STRING, col2 STRING, col3 STRING) PARTITIONED BY (pool STRING);
> {code)
> following insert will failed due to different number of fields in select and in target table:
> {code} 
> INSERT OVERWRITE TABLE my_table
> PARTITION(pcol='TEST')
> SELECT 'A' as a, 'B'as b;
> {code}
> Proposed change adds support for the following syntax:
> {code} 
> INSERT OVERWRITE TABLE my_table
> PARTITION(pcol='TEST')
> *(col1, col3)*
> SELECT 'A' as a, 'B'as b;
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)