Text index on mapValues(map) is silently not used when querying through a Distributed engine table (analyzer) · Issue #108874 · ClickHouse/ClickHouse · GitHub
Skip to content

Text index on mapValues(map) is silently not used when querying through a Distributed engine table (analyzer) #108874

Description

@udiz

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    potential bugTo be reviewed by developers and confirmed/rejected.

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions