Versions Compared

Key

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

...

  1. Add the kyvos.connection.readUsingCustomFS.jobs.internal=NONE property from the Kyvos connections page

  2. Modify the values of the following properties in the advance properties of semantic model job:

    • kyvos.process.compute.type=KYVOS_COMPUTE

    • kyvos.build.aggregate.type=TABULAR

  3. Set the kyvos.process.datastore.properties propertyon Hadoop Connection properties and set the value as SET disabled_optimizers = 'join_order';SET memory_limit='40GB';SET threads TO 1;

  4. Restart Kyvos services.

Changing Kyvos compute cluster mode

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

  • From the Kyvos Connection page, do the following:

    • For ROLAP queries, set the kyvos.connection.defaultsqlengine property’s value as True.

    • Add the kyvos.connection.isRead property and set is value as True.

  • Modify the value of the following semantic model advanced properties on Kyvos Web Portal:

    • kyvos.sqlwarehouse.catalog = ‘Your catalog name’ 

    • kyvos.sqlwarehouse.tempdb = ‘Your Database name’ 

    • kyvos.build.aggregate.type = TABULAR 

    • Kyvos.process.compute.type = Kyvos Compute 

  • You can also set subtype at semantic model via property, for this navigate to Kyvos Properties page and update the KYVOS_PROCESS_COMPUTE_SUBTYPE property

...

  • and restart Kyvos services.