[
https://issues.apache.org/jira/browse/HIVE-16300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kostyantyn Oliynyk updated HIVE-16300:
--------------------------------------
Summary: Allow specify target table columns in static partition insert
(was: Allow specify target table columns in partition static insert)
> 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 with static partition insert,
> like:
> Let my_table have 5 columns (col1,col2,col3,col4,col) partitioned by
> (partition_field STRING).
> SQL parser will throw an error if select fields does not match target table
> fields for static partition insert:
> INSERT OVERWRITE TABLE my_table
> PARTITION(partition_field='value')
> SELECT a, c FROM another_table;
>
> It is proposed add ability to specify target coluns
> INSERT OVERWRITE TABLE my_table
> PARTITION(partition_field='value')
> *(col1, col5)*
> SELECT a, c FROM another_table;
> As a result SQL parser will throw an error if select fields does not match
> target table fields.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
