zhicwu
commented
2 years ago 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')Open zhongyi-peng opened 2 years ago
zhicwu
commented
2 years ago 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')
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)