Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
Algunenano opened this issue Jan 8, 2024 · 1 comment · Fixed by #58657
Closed

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

Algunenano opened this issue Jan 8, 2024 · 1 comment · Fixed by #58657
Labels
analyzer Issues and pull-requests related to new analyzer experimental feature Bug in the feature that should not be used in production unfinished code

Comments

@Algunenano
Copy link
Member

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

@canhld94
Copy link
Contributor

I think it's broken for non-analyzer as well. Anw #58657 seems to fix the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
analyzer Issues and pull-requests related to new analyzer experimental feature Bug in the feature that should not be used in production unfinished code
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants