Company or project name
groundcover
Describe what's wrong
A text (skip) index defined on a mapValues(map) (or mapKeys(map)) expression is used when querying the local MergeTree table or via the cluster()/remote() table functions, but is silently not used when the same table is queried through a Distributed engine table with the analyzer enabled. The documented "fast" map-search path (textindexes.md → Indexing Map columns) reproduces it.
When using a preprocessor (for lower() for example), the issue is highlighted as it affects the results as well.
Does it reproduce on the most recent release?
Yes
How to reproduce
using force_data_skipping_indices: https://fiddle.clickhouse.com/a544e0d3-050b-4fcf-b948-7edb0191e549
using a preprocessor: https://fiddle.clickhouse.com/2d564d39-ba9e-4a11-922d-3e3ccbaaa116
Expected behavior
querying through a distributed table should match the behavior of a local table.
Error message and/or stacktrace
No response
Related issues and pull requests
No response
Additional context
No response
Company or project name
groundcover
Describe what's wrong
A text (skip) index defined on a mapValues(map) (or mapKeys(map)) expression is used when querying the local MergeTree table or via the cluster()/remote() table functions, but is silently not used when the same table is queried through a Distributed engine table with the analyzer enabled. The documented "fast" map-search path (textindexes.md → Indexing Map columns) reproduces it.
When using a preprocessor (for lower() for example), the issue is highlighted as it affects the results as well.
Does it reproduce on the most recent release?
Yes
How to reproduce
using force_data_skipping_indices: https://fiddle.clickhouse.com/a544e0d3-050b-4fcf-b948-7edb0191e549
using a preprocessor: https://fiddle.clickhouse.com/2d564d39-ba9e-4a11-922d-3e3ccbaaa116
Expected behavior
querying through a distributed table should match the behavior of a local table.
Error message and/or stacktrace
No response
Related issues and pull requests
No response
Additional context
No response