[FLINK-17361] Support creating of a JDBC table using a custom query

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Flavio Pompermaier
• Reporter: Flavio Pompermaier
• Created: 23/Apr/20 21:52
• Updated: 16/Oct/20 10:54
• Resolved: 19/May/20 17:51

Description

In a long discussion on the mailing list it has emerged how it is not possible to create a JDBC table that extract data using a custom query.
A temporary workaround could be to assign as 'connector.table' the target query.
However this is undesirable.

Moreover, in relation to https://issues.apache.org/jira/browse/FLINK-17360, a query could be actually a statement that requires parameters to be filled by the custom parameter values provider

Issue Links

• links to: GitHub Pull Request #11986