[
https://issues.apache.org/jira/browse/IMPALA-10452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltán Borók-Nagy resolved IMPALA-10452.
----------------------------------------
Fix Version/s: Impala 4.0
Resolution: Fixed
> CREATE Iceberg tables with old PARTITIONED BY syntax
> ----------------------------------------------------
>
> Key: IMPALA-10452
> URL: https://issues.apache.org/jira/browse/IMPALA-10452
> Project: IMPALA
> Issue Type: Test
> Components: Frontend
> Reporter: Zoltán Borók-Nagy
> Assignee: Zoltán Borók-Nagy
> Priority: Major
> Labels: impala-iceberg
> Fix For: Impala 4.0
>
>
> It's convenient for users to create Iceberg tables with the old syntax.
> It's also easier to migrate existing workloads to Iceberg because the SQL
> scripts that create the table definitions don't need to change that much.
> So users should be able to write the following:
> {noformat}
> CREATE TABLE ice_t (i int)
> PARTITIONED BY (p int)
> STORED AS ICEBERG;
> {noformat}
> Which should be equivalent to this:
> {noformat}
> CREATE TABLE ice_t (i int, p int)
> PARTITION BY SPEC (p IDENTITY)
> STORED AS ICEBERG;
> {noformat}
> Please note that the old-style CREATE TABLE creates IDENTITY-partitioned
> tables. For other partition transforms the users must use the new, more
> generic syntax.
> Hive also supports the PARTITIONED BY syntax, see
> [https://github.com/apache/iceberg/pull/1612]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]