Skip to content

[Analyzer] Set index: Cannot get value from Set (parallel_index test) #58593

@Algunenano

Description

@Algunenano

From perf tests (parallel_index):

create table test_parallel_index (x UInt64, y UInt64, z UInt64, INDEX a (y) TYPE minmax GRANULARITY 2,
        INDEX b (z) TYPE set(8) GRANULARITY 2) engine = MergeTree order by x partition by bitAnd(x, 63 * 64) settings index_granularity = 4;

insert into test_parallel_index select number, number, number from numbers(1048576);

select sum(z) from test_parallel_index where z = 2 or z = 7 or z = 13 or z = 17 or z = 19 or z = 23;

With the analyzer you get: Code: 48. DB::Exception: Cannot get value from Set. (NOT_IMPLEMENTED)

Works fine without it

Metadata

Metadata

Assignees

No one assigned

    Labels

    analyzerIssues and pull-requests related to new analyzerexperimental featureBug in the feature that should not be used in productionunfinished code

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions