Using-where-condition is not supported in ck-jdbc-bridge?

[zhongyi-peng]

configured ok based on https://clickhouse.com/docs/en/integrations/jdbc/jdbc-with-clickhouse
using select * from jdbc('mysql10', 'schema_name', 'table_name') successful and get results right
but this bridge does not support using where condition? Such as where rownum=10?
any solution? or create a view in original database?(that's tough)

[zhicwu]

Hi @zhongyi-peng, you can pass the query to JDBC bridge directly, for example:

select * from jdbc('mysql10', 'select * from myschema.mytable where col1=1 limit 5')