Skip to content

ClickHouse fails to read Iceberg tables with columns containing dot '.' #947

@alex-zaitsev

Description

@alex-zaitsev

Reproduced by "flowers.iris" test data (see in https://github.com/Altinity/ice examples)

select * from ice.`flowers.iris` limit 5;

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

Columns is automatically renamed in Parquet escaping dot. ClickHouse should understand such mapping or use column ids (better)

Metadata

Metadata

Assignees

Labels

antalyabugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions