Versions Compared

Old Version 1

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Prerequisites

...

Important points for no-Hadoop and no-Spark

...

  • Network File System (NFS) must be mounted on compute nodes.

  • Python version 3.6.8 must be installed.

  • The Kyvos Manager OS commands must be installed. The OS commands are utilized by Kyvos Manager and Kyvos. Therefore, these commands must be present on all cluster nodes. 

  • Required permissions.

...

deployments

  • No Spark types: Kyvos Native (Shared QE) or Kyvos Native (Compute)

    • Kyvos Native (Shared QE): In this deployment mode, a semantic model is processed on Query Engines itself.

    • Kyvos Native (Compute): In this deployment mode, a semantic model is processed on a dedicated node. This ensures that query performance is not impacted by issues such as a failure in semantic model processing.

  • A Compute Server can be deployed on any dedicated node, or it can even share nodes with any of the existing services. You can also configure multiple instances of Compute Server service on the same node.

  • Java options for Compute Service server can be configured from Kyvos Manager on the Java Options page.

  • Kyvos Manager offers a way to manage service of dedicated Query Engine or Compute Server from Kyvos Dashboard page as offered for other services of cluster.

  • Logs of dedicated Compute Server service can be viewed and downloaded on the Monitor > Logs page from Kyvos Manager.

  • Kyvos Manager offers a way to add, delete, or migrate Compute Server in a deployed on-premises cluster.

  • Migration of Kyvos Native (Shared QE) cluster to Kyvos native (Compute) is NOT supported. You must redeploy the cluster.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

Before deploying no Hadoop and no Spark, the same Network File System (NFS) must be mounted on each compute node of cluster.

To deploy No-Hadoop and No-Spark Cluster, perform the following steps.

  1. Download the setup . After downloading, untar it, and then start Kyvos manager.

  2. Select Kyvos platform as OnPrem.

    image-20240701-140213.pngImage Removed

  3. Select Compute Cluster Type as Kyvos Native in Ecosystem.

    image-20240701-140255.pngImage Removed

  4. Select HTTP in the Security tab.

    image-20240701-140406.pngImage Removed

  5. Uncheck the Use YARN checkbox in the Kyvos tab of the installer page.

    image-20240701-140539.pngImage Removed

  6. Select Local as the value for the Default Cuboid Replication Type dropdown in the Kyvos tab of the installer page.provided by your admin/Kyvos Support team. Untar the setup bundle and start the Kyvos Manager.
    The Kyvos Installer page is displayed.

  7. Enter details as:

Aura tab collection
paramsJTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA==
Aura tab
summary1. Cluster Details
paramsJTdCJTIydGl0bGUlMjIlM0ElMjIxLiUyMENsdXN0ZXIlMjBEZXRhaWxzJTIyJTdE

  1. In the Cluster Details section, enter the details to deploy Kyvos on Premises environment. For cluster details, see the Creating Kyvos Cluster for On-prem Environment section.

  2. After completing the cluster details, click Next. The Ecosystem tab is displayed.

image-20240809-085409.pngImage Added
Aura tab
summary2. Ecosystem
paramsJTdCJTIydGl0bGUlMjIlM0ElMjIyLiUyMEVjb3N5c3RlbSUyMiU3RA==

  1. Select one of the following options from the Compute Cluster Type list:

    • Kyvos Native (Dedicated Compute): To process semantic model on dedicated nodes.

    • Kyvos Native (Shared QE): To use the Query Engine as a compute engine for processing semantic model.

  2. Click Next, the Security tab is displayed.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

If you select Kyvos Native (Dedicated Compute or Shared QE), the Hadoop Ecosystem Configuration will be disabled.

image-20240809-090534.pngImage Added
Aura tab
summary3. Security
paramsJTdCJTIydGl0bGUlMjIlM0ElMjIzLiUyMFNlY3VyaXR5JTIyJTdE

  1. On the Security tab, the HTTP option is selected by default.

  2. Click Next,the Kyvos tab is displayed.

image-20240809-091249.pngImage Added
Aura tab
summary4. Kyvos
paramsJTdCJTIydGl0bGUlMjIlM0ElMjI0LiUyMEt5dm9zJTIyJTdE
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

On the Ecosystem tab,

  • If you select the Kyvos Native (Dedicated Compute) option, the Compute Server Configuration section will be displayed.

  • If you select the Kyvos Native (Shared QE) option, in the Query Engine Configuration section, the option to select Analytical Store Max Memory for Processing will be displayed.

The Kyvos configuration page enables you to upload the Kyvos license and define the settings for BI Server, Query Engine, Kyvos Web Portal, and so on. You can also define High availability and node mapping configurations here.
For cluster details, see the Configuring Kyvos properties from Kyvos Manager section.

  • Kyvos Native (Dedicated Compute):Enter the following Compute Server Configuration details.

Parameter/Field

Comments/Description

Listener Port

Enter the listener port for compute server configuration.

Maximum  Heap Memory

Enter the maximum memory available for compute server configuration.

Additional Java Options

Use this to define custom Java properties for your compute server configuration.

Analytical Store Maximum Memory

Enter the maximum Analytical Store memory available for compute server configuration.

image-20240809-093855.pngImage Added

  • Kyvos Native (Shared QE): If you select thisoption, in the Query Engine Configuration section, the option to select Analytical Store Max Memory for Processing is displayed. Select the required processing memory.

After configuring the Kyvos properties, click Next. The Summary tab is displayed.

image-20240809-094454.pngImage Added

Aura tab
summary5. Summary
paramsJTdCJTIydGl0bGUlMjIlM0ElMjI1LiUyMFN1bW1hcnklMjIlN0Q=

The Summary tab page displays all the settings completed so far. Collapse or expand the Cluster,

...

Security, or Kyvos areas to hide or view the corresponding details.

...

 

Creating connection

 To create no Hadoop and no Spark connection, perform the following steps.

...

Select WAREHOUSE as Category value.

...

Select GENERIC as Provider value.

...

Provide "com.microsoft.sqlserver.jdbc.SQLServerDriver" in the driver class field.

...

Provide the URL, username, and password.

...

Provide JDBC as value in Spark Read Method field.

...

Add a new property by clicking the Properties link.

  1. Enter property’s name as kyvos.connection.isRead

  2. Enter its value as True.

...

After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.

...

Click the Previous button to go back and make any changes (if needed).

Click Next, the Validations tab is displayed.

image-20240809-100822.pngImage Added
Aura tab
summary5. Validations
paramsJTdCJTIydGl0bGUlMjIlM0ElMjI1LiUyMFZhbGlkYXRpb25zJTIyJTdE

The system validates the information entered so far and displays the results, as shown in the following figure.

You can check Validation logs and Validation Status.

image-20240809-101608.pngImage Addedimage-20240809-101620.pngImage Added

  1. To proceed with the deployment, click the Install button.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

 Note

In case of No Hadoop No Spark deployments, data reading is supported via MSSQL and Postgres. To create connection for MSSQL warehouse, see the Working with MSSQL Warehouse Connection section.

Tip

Tip

To save the information as a new template, click the Save as Template. 

For more template management-related features, refer to the section Managing templates.