6. Getting Started With Kyuubi and DataGrip¶
6.1. What is DataGrip¶
DataGrip is a multi-engine database environment released by JetBrains, supporting MySQL and PostgreSQL, Microsoft SQL Server and Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby, and H2.
6.2.1. Get DataGrip And Install¶
Please go to Download DataGrip to get and install an appropriate version for yourself.
6.2.2. Get Kyuubi Started¶
Get kyuubi server started before you try DataGrip with kyuubi.
For debugging purpose, you can use
tail -f or
tailf to track the server log.
6.3.1. Start DataGrip¶
After you install DataGrip, just launch it.
6.3.2. Select Database¶
Substantially, this step is to choose a JDBC Driver type to use later. We can choose Apache Hive to set up a driver for Kyuubi.
6.3.3. Datasource Driver¶
You should first download the missing driver files. Just click on the link below, DataGrip will download and install those.
6.3.4. Generic JDBC Connection Settings¶
After install drivers, you should configure the right host and port which you can find in kyuubi server log. By default, we use
10009 to configure.
Of course, you can fill other configs.
After generic configs, you can use test connection to test.
6.4. Interacting With Kyuubi Server¶
Now, you can interact with Kyuubi server.
The left side of the photo is the table, and the right side of the photo is the console.
You can interact through the visual interface or code.
6.5. The End¶
There are many other amazing features in both Kyuubi and DataGrip and here is just the tip of the iceberg. The rest is for you to discover.