Skip to content

dot-separated column names show nulls instead of data on Antalya 25.8.12.20747 #1301

@alsugiliazova

Description

@alsugiliazova

Describe the bug

You can create iceberg table with dot-separated column as you want.

I followed this to create local iceberg table https://github.com/Altinity/ice/tree/master/examples/localfileio.
I had to make this changes in order to work with latest Antalya (altinity/clickhouse-server:25.8.12.20747.altinityantalya):
https://altinity.slack.com/archives/C07NZ441PK9/p1767709246868069?thread_ts=1767649655.440519&cid=C07NZ441PK9

CREATE DATABASE ice2
ENGINE = DataLakeCatalog('http://localhost:5000')
SETTINGS catalog_type = 'rest', vended_credentials = false, warehouse = 'warehouse'
SELECT *
FROM ice2.`flowers.iris`
LIMIT 10
Query id: 1df7b5c1-34b0-4ce8-a347-1993f3d76137

    ┌─sepal.length─┬─sepal.width─┬─petal.length─┬─petal.width─┬─variety─┐
 1. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 2. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 3. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 4. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 5. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 6. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 7. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 8. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
 9. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
10. │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │         ᴺᵁᴸᴸ │        ᴺᵁᴸᴸ │ Setosa  │
    └──────────────┴─────────────┴──────────────┴─────────────┴─────────┘

10 rows in set. Elapsed: 0.029 sec. 

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions