...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note To use When using semantic models with Kyvos Analytical storeStore, you must process the full data of the semantic model if it has already not been processed before. Additionally, it is recommended not to use the semantic model that was previously processed if you have enabled to avoid using a previously processed semantic model after enabling the Kyvos Analytical Store. After enabling Kyvos Analytical Store, the This is because executing queries on a previously processed semantic model may slow down the query execution time due to the as a result of new memory configurationcalculations. |
Certified Providers and supported Operating Systems for Kyvos Analytical Store
...
Add Kyvos Analytical Store Jar in classpath
The value of ENABLE_KYVOS_ANALYTICAL_STORE property should be set as Yes.
The value of ELASTIC_DEPLOYMENT should be set as Disable.
The value of kyvos.cuboid.replication.type property should be set as Local on the semantic model.
...
Adding Kyvos Analytical Store Jar in classpath
To add Kyvos Analytical Store Jar in classpath, perform the following steps.
Login to Kyvos and navigate to the Connections page.
On the Connections page, click Properties.
On the Edit Properties dialog box, search “kyvos.connection.classpath.common.jar” and enter the ../lib/duckdb_jdbc.jar value in the existing class path.
Restart Kyvos services.
...
Kyvos Analytical Store memory calculations
Parameter | Memory CalculationsCalculation |
|---|---|
HEAP_MEMORY | VM_TOTAL_MEMORY / 4 |
OFF_HEAP_MEMORY | VM_TOTAL_MEMORY / 8 |
KYVOS_ANALYTICAL_STORE_MEMORY | VM_TOTAL_MEMORY / 4 |
For example, If you have a 64 GB QE VMQuery Engine Virtual Machine, the following will be the memory calculations are as follows:
HEAP_MEMORY = 16 GB
OFF_HEAP_MEMORY= 8 GB
KYVOS_ANALYTICAL_STORE_MEMORY= 16 GB
...