Page Comparison

...

...

...

...

...

...

...

...

...

...

...

...

Applies to:Image ModifiedKyvos Enterprise  Image ModifiedKyvos Cloud  Image ModifiedKyvos Azure Marketplace  Image ModifiedKyvos Single Node Installation

Image ModifiedKyvos Single Node Standard Installation  Image ModifiedKyvos Free

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

...

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
   title 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

      Info
      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. 

...