jackye1995 opened a new issue #2681:
URL: https://github.com/apache/iceberg/issues/2681
Currently user can only create table with identity transforms through the
standard Hive CREATE TABLE syntax, or specify the json text of the partition
spec as table parameter using key `iceberg.mr.table.partition.spec`. This is
very hard to use for users writing SQL manually using in an interactive console
or notebook.
We would like to contribute a more user friendly way to specify the values,
so a create table statement with hidden partition looks like:
```sql
CREATE TABLE database_a.table_a (
id bigint,
category string,
ts timestamp,
data string
) TBLPROPERTIES (
'iceberg.catalog'='hadoop',
'iceberg.partitioning'='bucket(id, 16);category;days(ts)'
) STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
```
Would like to know if this is something valuable to be added, and any
additional suggestions for this. I will put up the PR once we have some initial
agreements.
@pvary @marton-bod
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
