Kostyantyn Oliynyk created HIVE-16300:
-----------------------------------------
Summary: Allow specify target table columns in partition static
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)
