libenchao commented on PR #20140:
URL: https://github.com/apache/flink/pull/20140#issuecomment-1208843267

   >  I believe JdbcFilterPushdownVisitor needs to produce strings or some 
equivalent data, so that it can be used by 
JdbcDynamicTableSource::getScanRuntimeProvider, how should I make use of 
PrepareStatement here? Maybe I am missing something?
   
   @qingwei91 Currently `JdbcRowDataInputFormat` already uses 
`PreparedStatement`, and 'scan.partition' is implemented using it, hence we can 
do it. `JdbcFilterPushdownVisitor` does not necessarily need to return 
`String`, it can  return anything we need.
   We may need to rethink about the design, especially for the following points:
   1. What functions should we support, e.g. `IN`, `BETWEEN`?
   2. Are these functions supported in all JDBC dialects, and do they use the 
same operator? If not, how should we abstract it out to make it dialect 
specific?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to