Page Comparison

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

Image RemovedKyvos Single Node Standard Installation  Image RemovedKyvos FreeApplies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

...

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.

...

2. Download

...

...

1. the Hive JDBC driver and Apache license from GitHub

...

1. .

...

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

...

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

...

1. 1. Image Added

      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.

...

1. 1. Image Added

   2. Click Find Class and select the Hive Driver from the Driver Class list, and then click ok.

...

1. 1. Image Added

2. Go to the DBeaver home page, select Create new Database connection, and then select Apache Hive. 

...

1. Image Added

2. Click Next. 

3. To create a new connection, do the following: 

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

...

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

...

1. 1. Image Added

   2. Click Test Connection to verify whether you are able to connect or not. If you can successfully connect, click Finish. 

2. After establishing the connection, you can query the Kyvos semantic model. 

Running a SQL query 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.

...

1. Image Added

2. Write the query on the right of the window, and then click the arrow to execute the SQL statement. 

...

1. Image Added

   
   You will see the result for the executed SQL query. 

...

1. Image Added