Value with Array type in ClickHouse dictionary

[Sahar Imani]

Hello everyone!

I want to create a dictionary in ClickHouse that has a key with String type and 3 values. These values have String type, String type and Array type. When I create this dictionary and select dictGet the value that has String type, the dictionary works correctly but when I select dictGet the value that has Array type, it doesn't work and shows this error:

Bad cast from type DB::ColumnString to DB::ColumnArray

While the table column, which has an Array type in the dictionary and the dictionary is created from it, also has an Array(String) type.

Does dictionary in ClickHouse not accept the value with Array type or am I doing something wrong that I don't know what?

Thanks

[Denis Zhuravlev]

Array type was recently implemented in Dictionaries

https://github.com/ClickHouse/ClickHouse/blob/master/CHANGELOG.md

ClickHouse release v21.7, 2021-07-09

Added support for Array type in dictionaries. #25119 (Maksim Kita).

Examples https://kb.altinity.com/altinity-kb-dictionaries/dictionaries-and-arrays/