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

clickhouse filter pushdown #8312

Closed
quanleiqwe opened this issue Jun 18, 2021 · 3 comments
Closed

clickhouse filter pushdown #8312

quanleiqwe opened this issue Jun 18, 2021 · 3 comments

Comments

@quanleiqwe
Copy link

quanleiqwe commented Jun 18, 2021

clickhouse connector filter pushdown not effect

select count(*) from clickhouse.test01.person_info ;
_col0

269140
(1 row)

select person_id from clickhouse.test01.person_info where person_id = '1234';
person_id

1234
1234
1234
1234
1234
(5 rows)

Query 20210618_121625_03302_j9w2a, FINISHED, 2 nodes
Splits: 33 total, 33 done (100.00%)
0.21 [269K rows, 0B] [1.27M rows/s, 0B/s]

this sql clieckhouse excute shoud return five record , but return 269K rows

@quanleiqwe quanleiqwe changed the title clickhouse pushdown filter clickhouse filter pushdown Jun 18, 2021
@hashhar
Copy link
Member

hashhar commented Jun 18, 2021

Predicate pushdown for VARCHAR/VARBINARY is not yet implemented in ClickHouse connector. cc: @wgzhao

See #7103 for current state.

Should I consider this a duplicate?

@quanleiqwe
Copy link
Author

ok, thanks

@findepi
Copy link
Member

findepi commented Jun 21, 2021

Covered by #7100

@findepi findepi closed this as completed Jun 21, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

3 participants