Skip to content

Exposing partition and sorting keys does not work with glue catalog #1235

@alsugiliazova

Description

@alsugiliazova

Describe the bug
#959
Exposing partition_key and sorting_key does not work for glue catalog (works for rest).

Using glue:

SELECT
    partition_key,
    sorting_key
FROM system.tables
WHERE name = 'namespace_1695a67e_db56_11f0_851b_e0c26496f172.table_1695a6da_db56_11f0_b6bd_e0c26496f172'

Query id: ca9edfbf-30f9-4868-8e7a-51b3fec7e3e1

   ┌─partition_key─┬─sorting_key─┐
1. │               │             │
   └───────────────┴─────────────┘

1 row in set. Elapsed: 0.266 sec. 

Same table but with rest catalog:

SELECT
    partition_key,
    sorting_key
FROM system.tables
WHERE name = 'namespace_5f150819_db56_11f0_8e49_e0c26496f172.table_5f15086a_db56_11f0_88ee_e0c26496f172'

Query id: 7c99ba42-b474-480d-af6c-f1d8dca9c60b

   ┌─partition_key─┬─sorting_key─┐
1. │ name          │ name ASC    │
   └───────────────┴─────────────┘

1 row in set. Elapsed: 0.048 sec. 

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions