snuyanzin commented on code in PR #23743: URL: https://github.com/apache/flink/pull/23743#discussion_r1397996410
########## docs/content/docs/dev/table/jdbcDriver.md: ########## @@ -51,16 +55,79 @@ You can also add dependency of Flink JDBC driver in your maven or gradle project </dependency> ``` -## Use with a JDBC Tool -### Use with Beeline +## JDBC Clients + +The Flink JDBC driver is not included with the Flink distribution. You can download it from [Maven](https://repo.maven.apache.org/maven2/org/apache/flink/flink-sql-jdbc-driver-bundle/). + +You may also need the [SLF4J](https://repo1.maven.org/maven2/org/slf4j/slf4j-api/) (`slf4j-api-{slf4j.version}.jar`) jar. + +### SQLLine + +[SQLLine](https://github.com/julianhyde/sqlline) is a lightweight JDBC command line tool that supports general JDBC drivers. + +To use SQLLine you will need to clone [the GitHub repository](https://github.com/julianhyde/sqlline) and compile the project first (`./mvnw package -DskipTests`). + +1. Download the following JARs and add them both to the `target` directory of SQLLine project: + 1. [Flink JDBC Driver](https://repo.maven.apache.org/maven2/org/apache/flink/flink-sql-jdbc-driver-bundle/) (`flink-jdbc-driver-bundle-{VERSION}.jar`) + 2. [SLF4J](https://repo1.maven.org/maven2/org/slf4j/slf4j-api/) (`slf4j-api-{slf4j.version}.jar`) +2. Run SQLLine with command `./bin/sqlline` +3. From SQLLine, connect to a Flink SQL gateway using the `!connect` command. + + Since the Flink SQL gateway currently ignores user names and passwords just leave them empty. + + ```sql + sqlline version 1.13.0 Review Comment: where did you get it? The latest sqlline version is 1.12.0 (i was a release manager there btw =)) -- 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