[FLINK-31018] SQL Client -j option does not load user jars to classpath.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: 1.17.0, 1.16.1
• Component/s: Table SQL / Client
• Assignee: Unassigned
• Reporter: Krzysztof Chmielewski
• Created: 10/Feb/23 15:05
• Updated: 10/Feb/23 17:41
• Resolved: 10/Feb/23 17:39

Description

SQL Client '-j' option does not load custom jars to classpath as it was for example in Flink 1.15
As a result Flink 1.16 SQL Client is not able to discover classes through Flink's Factory discovery mechanism throwing an error like:

[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.table.api.ValidationException: Could not find any factories that implement 'com.getindata.connectors.http.LookupQueryCreatorFactory' in the classpath.

The same Jar and sample job are working fine with Flink 1.15.

Flink 1.15.2
./bin/sql-client.sh -j flink-http-connector-0.9.0.jar

Flink 1.16.1
./bin/sql-client.sh -j flink-http-connector-0.9.0.jar

ADD JAR command does not solve " Could not find any factories" issue although jar seems to be added: