DBeaver SQL tool

Applies to:Kyvos Enterprise  Kyvos Cloud  Kyvos Azure Marketplace  Kyvos Single Node Installation

Kyvos Single Node Standard Installation  Kyvos Free

Kyvos supports the DBeaver SQL tool to query on the Kyvos semantic model. 

To connect DBeaver to Kyvos Server, perform the following steps. 

1. Download the DBeaver SQL tool. You can also download it Microsoft Store. 
2. Install and launch DBeaver. 

3. Download the Hive JDBC driver and Apache license from GitHub.

   Info

   Configuring the Hive JDBC driver and Apache license from GitHub is a one-time activity. 

   For this, do the following: 

   1. On the DBeaver Home page, go to Database > Manage Driver and search for Apache Hive, and then click Edit. 
      
   2. On the Edit Driver dialog box, click the Libraries tab.
   3. If you don't have a Hive driver, click Download, then click the driver link, and Download it. Similarly, click the license link and then click Download.
      
      -or- 
      If you already have a Hive driver and you want to add it, then on the Edit Driver dialog, click the Libraries tab, and then click Add file and provide a path for the Hive driver.
      
   4. Click Find Class and select the Hive Driver from the Driver Class list, and then click ok.
      
4. Go to the DBeaver home page, select Create new Database connection, and then select Apache Hive. 
   
5. Click Next. 
6. To create a new connection, do the following: 

   1. Host: Specify host details as: 
      hostname:port/;transportMode=http;httpPath=kyvos/sql

      In case of SSL enabled server, enter hostname: port/;transportMode=http;httpPath=kyvos/sql; ssl=true

   2. Port: Keep the port field blank. 
   3. Provide your respected Database username and password.
      
   4. Click Test Connection to verify whether you are able to connect or not. If you can successfully connect, click Finish. 
7. After establishing the connection, you can query the Kyvos semantic model. 

Running a SQL query 

To run a SQL query, perform the following steps. 

1. In the left pane, right-click the connection you have created, and then select SQL Editor > New SQL script.
   
2. Write the query on the right of the window, and then click the arrow to execute the SQL statement. 
   
   You will see the result for the executed SQL query.