Clickhouse SQL 'GLOBAL IN' not support

[xiao321]

Clickhouse SQL 'GLOBAL IN' not support

sqllineage -f ./sql-global-ck.sql --dialect=clickhouse

SELECT id, name FROM distributed_table WHERE id GLOBAL IN (SELECT id FROM local_table);

Line 1, Position 49: Found unparsable section: 'GLOBAL IN (SELECT id FROM local_table)'

Python 3.8
Sqllineage 1.5.0

[maoxingda]

This is not supported by the underlying sqlfluff, not by sqllineage.

[reata]

Upstream issue sqlfluff/sqlfluff#5256 as reference.

Once they fix the issue and release a new version, we can upgrade the dependency and get this done.

[reata]

Upstream issue is fixed in sqlfluff==3.0.0a5. Since 3.0.0a5 is an alpha release, we will not upgrade sqllineage dependency and will wait for 3.0.0 instead. But you can manually upgrade your sqlfluff to get unblocked.