[
https://issues.apache.org/jira/browse/IMPALA-6710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alex Rodoni resolved IMPALA-6710.
---------------------------------
Resolution: Fixed
Fix Version/s: Impala 2.12.0
> Docs around INSERT into partitioned tables are misleading
> ---------------------------------------------------------
>
> Key: IMPALA-6710
> URL: https://issues.apache.org/jira/browse/IMPALA-6710
> Project: IMPALA
> Issue Type: Bug
> Components: Docs
> Affects Versions: Impala 2.12.0
> Reporter: Thomas Tauber-Marshall
> Assignee: Alex Rodoni
> Priority: Major
> Labels: docs
> Fix For: Impala 2.12.0
>
>
> Impala's INSERT statement has an optional "partition" clause where partition
> columns can be specified.
> This clause must be used for static partitioning, i.e. where the partition
> value is specified after the column:
> {noformat}
> > insert into t1 partition(x=10, y='a') select c1 from some_other_table;
> {noformat}
> But it is not required for dynamic partition, eg. the following inserts are
> equivalent:
> {noformat}
> > create table test (c string) partitioned by (p int);
> > insert into foo (p, c) values (0, 'c');
> > insert into foo (c) partition(p) values ('c', 0);
> > insert into foo partition(p) values ('c', 0);
> {noformat}
> and note:
> - the columns are inserted into in the order they appear in the SQL, hence
> the order of 'c' and 1 being flipped in the first two examples
> - when a partition clause is specified but the other columns are excluded, as
> in the third example, the other columns are treated as though they had all
> been specified before the partition clauses in the SQL
> Confusingly, though, the partition columns are required to be mentioned in
> the query in some form, eg:
> {noformat}
> > insert into foo values ('c', 1);
> {noformat}
> would be valid for a non-partitioned table, so long as it had a number and
> types of columns that match the values clause, but can never be valid for a
> partitioned table.
> The docs around this are not very clear:
> http://impala.apache.org/docs/build/html/topics/impala_insert.html
> and seem to indicate that partition columns must be specified in the
> "partition" clause, eg. the sentence:
> {noformat}
> Inserting data into partitioned tables requires slightly different syntax
> that divides the partitioning columns from the others:
> {noformat}
> and the examples that follow it.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
