pass mybatis bitmap through the stream to query

[yanye666]

I want to pass mybatis bitmap through the stream to query, can it be implemented?

Like this, can you pass it to bitmap and filter it with another table?

[zhicwu]

Yes, via an external or temporary table. Should be similar as: https://github.com/ClickHouse/clickhouse-java/blob/main/examples/jdbc/src/main/java/com/clickhouse/examples/jdbc/Advanced.java#L63-L83

[yanye666]

java.sql.SQLException: External table, input function, and query parameter cannot be used together in PreparedStatement.

Can't support parameters?

[yanye666]

@zhicwu

[zhicwu]

java.sql.SQLException: External table, input function, and query parameter cannot be used together in PreparedStatement.

Yes, you have to pick one but not all of them due to limitation of current implementation. I hope it can be addressed later when I add new SQL parser in clickhouse-parser.

Meanwhile, perhaps you can break down the query into two and execute them within a session? For example: first query to create the temp table, and then the second for table join with custom filter/parameter.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last year. It will be closed in 30 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!