JAR Statements

JAR statements are used to add user jars into the classpath or remove user jars from the classpath or show added jars in the classpath in the runtime.

Flink SQL supports the following JAR statements for now:

  • ADD JAR
  • SHOW JARS
  • REMOVE JAR

Run a JAR statement

SQL CLI

The following examples show how to run JAR statements in SQL CLI.

SQL CLI

  1. Flink SQL> ADD JAR '/path/hello.jar';
  2. [INFO] Execute statement succeed.
  4. Flink SQL> ADD JAR 'hdfs:///udf/common-udf.jar';
  5. [INFO] Execute statement succeed.
  7. Flink SQL> SHOW JARS;
  8. +----------------------------+
  9. |                       jars |
  10. +----------------------------+
  11. |            /path/hello.jar |
  12. | hdfs:///udf/common-udf.jar |
  13. +----------------------------+
  15. Flink SQL> REMOVE JAR '/path/hello.jar';
  16. [INFO] The specified jar is removed from session classloader.

ADD JAR

  1. ADD JAR '<path_to_filename>.jar'

Add a JAR file to the list of resources, it supports adding the jar locates in a local or remote file system. The added JAR file can be listed using SHOW JARS statements.

Limitation

Please don’t use ADD JAR statement to load Hive source/sink/function/catalog. This is a known limitation of Hive connector and will be fixed in the future version. Currently, it’s recommended to follow this instruction to setup Hive integration.

SHOW JARS

  1. SHOW JARS

Show all added jars which are added by ADD JAR statements.

REMOVE JAR

  1. REMOVE JAR '<path_to_filename>.jar'

Remove the specified jar that is added by the ADD JAR statements.

Attention REMOVE JAR statement only work in the SQL CLI.