available datasource factories, with the available driver. For instance, once you installed the jdbc feature, you can install pax-jdbc-postgresql feature, providing the PostgreSQL datasource factory: database you want to connect: jdbc:ds-create The jdbc:ds-create command automatically creates a datasource definition file by leveraging pax-jdbc. The jdbc:ds-create command requires either: • the --driverName argument is required. It’s the name of the datasource. The name is used to identify the datasource, and to create the datasource definition file ( deploy/datasource- [name].xml ). • the -u option is optional

# DataSource to use dataSource.target=(osgi.jndi.service.name=jdbc/decanter) # SQL Query to retrieve data query=select * from TABLE This configuration file allows you to configure the datasource to and the SQL query to perform: • the datasource.name property contains the name of the JDBC datasource to use to connect to the database. You can create this datasource using the Karaf jdbc:create command Decanter JDBC Appender Configuration ####################################### # Name of the JDBC datasource datasource.name=jdbc/decanter # Name of the table storing the collected data table.name=decanter #

JDBC datasource is powered by HiKariCP, for datasource properties, please specify them with the prefix: kyuubi.metadata.store.jdbc. datasource. For example, kyuubi.metadata.store.jdbc. datasource.connectionTime following: The list of driver library files - Referencing the JDBC Driver Libraries. The Driver or DataSource class - Registering the Driver Class. The connection URL for the driver - Building the Connection choose a JDBC Driver type to use later. We can choose Apache Hive to set up a driver for Kyuubi. Datasource Driver You should first download the missing driver files. Just click on the link below, DataGrip

JDBC driver. Note that: The JDBC datasource is powered by HiKariCP, for datasource properties, please specify them with the prefix: kyuubi.metadata.store.jdbc. datasource. For example, strin g 1.6.0 Key Key Default Meaning Type Since kyuubi.metadata.store.jdbc. datasource.connectionTime out=10000. kyuubi.metadata.st ore.jdbc.driver JDBC driver class name for server jdbc metadata store. following: The list of driver library files - Referencing the JDBC Driver Libraries. The Driver or DataSource class - Registering the Driver Class. The connection URL for the driver - Building the Connection

JDBC driver. Note that: The JDBC datasource is powered by HiKariCP, for datasource properties, please specify them with the prefix: kyuubi.metadata.store.jdbc. datasource. For example, strin g 1.6.0 Key Key Default Meaning Type Since kyuubi.metadata.store.jdbc. datasource.connectionTime out=10000. kyuubi.metadata.st ore.jdbc.driver JDBC driver class name for server jdbc metadata store. following: The list of driver library files - Referencing the JDBC Driver Libraries. The Driver or DataSource class - Registering the Driver Class. The connection URL for the driver - Building the Connection

following: • The list of driver library files - Referencing the JDBC Driver Libraries. • The Driver or DataSource class - Registering the Driver Class. • The connection URL for the driver - Building the Connection Apache Hive to set up a driver for Kyuubi. 104 Chapter 3. What’s Next Kyuubi, Release 1.7.0 Datasource Driver You should first download the missing driver files. Just click on the link below, DataGrip Chapter 3. What’s Next Kyuubi, Release 1.7.0 Using as JDBC Datasource programmingly # Loading data from Kyuubi via HiveDriver as JDBC datasource jdbcDF = spark.read \ .format("jdbc") \ .options(driver="org

following: • The list of driver library files - Referencing the JDBC Driver Libraries. • The Driver or DataSource class - Registering the Driver Class. • The connection URL for the driver - Building the Connection Apache Hive to set up a driver for Kyuubi. 108 Chapter 3. What’s Next Kyuubi, Release 1.7.0 Datasource Driver You should first download the missing driver files. Just click on the link below, DataGrip Chapter 3. What’s Next Kyuubi, Release 1.7.0 Using as JDBC Datasource programmingly # Loading data from Kyuubi via HiveDriver as JDBC datasource jdbcDF = spark.read \ .format("jdbc") \ .options(driver="org

following: • The list of driver library files - Referencing the JDBC Driver Libraries. • The Driver or DataSource class - Registering the Driver Class. • The connection URL for the driver - Building the Connection Apache Hive to set up a driver for Kyuubi. 104 Chapter 3. What’s Next Kyuubi, Release 1.7.0 Datasource Driver You should first download the missing driver files. Just click on the link below, DataGrip Chapter 3. What’s Next Kyuubi, Release 1.7.0 Using as JDBC Datasource programmingly # Loading data from Kyuubi via HiveDriver as JDBC datasource jdbcDF = spark.read \ .format("jdbc") \ .options(driver="org

JDBC datasource is powered by HiKariCP, for datasource properties, please specify them with the prefix: kyuubi.metadata.store.jdbc. datasource. For example, kyuubi.metadata.store.jdbc. datasource.connectionTime following: The list of driver library files - Referencing the JDBC Driver Libraries. The Driver or DataSource class - Registering the Driver Class. The connection URL for the driver - Building the Connection choose a JDBC Driver type to use later. We can choose Apache Hive to set up a driver for Kyuubi. Datasource Driver You should first download the missing driver files. Just click on the link below, DataGrip

following: • The list of driver library files - Referencing the JDBC Driver Libraries. • The Driver or DataSource class - Registering the Driver Class. • The connection URL for the driver - Building the Connection can choose Apache Hive to set up a driver for Kyuubi. 3.6. Clients 107 Kyuubi, Release 1.7.3 Datasource Driver You should first download the missing driver files. Just click on the link below, DataGrip refer to Spark’s JDBC To Other Databases. Using as JDBC Datasource programmingly # Loading data from Kyuubi via HiveDriver as JDBC datasource jdbcDF = spark.read \ .format("jdbc") \ .options(driver="org