...
AWS: You can use no Spark model processing to deploy Kyvos through Query Engine.
Azure: For Kubernetes, Kyvos processes the semantic model using Azure’s managed service AKS (Azure Kubernetes Service). The Azure cluster is deployed via ARM templates. You can create a cluster without Spark or process the semantic model utilizing Spark Mode within ARM templates.
GCP: For Kubernetes, Kyvos processes the semantic model using Google Cloud's managed service GKE (Google Kubernetes Engine). The GKE cluster is deployed through GCP Installation Files. Using the scripts, you can select a No-Spark-based cluster or process the semantic model using Spark Mode.
To proceed with a no-spark-based deployment mode, you must use a Dataproc cluster (either new or existing).
For more details about how to deploy Kyvos on GCP using the no-Spark model, see the following section:
Post deployment for all clouds (AWS, Azure and GCP)
...
Add the kyvos.connection.readUsingCustomFS.jobs.internal=NONE property from the Kyvos connections page
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
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;
Restart Kyvos services.
Post deployment for Azure
The following post-deployment steps are required to be performed because the Datalake connection is blank on the Azure no-Spark cluster.
Launch Kyvos Manager from terminal.
Navigate to /data/kyvos/app/kyvos/olapengine/conf/providerInfo.xml file.
Add Hadoop Cluster in the providerInfo.xml file for Azure provider list on Kyvos Manager node, and complete the following details:
Code Block |
---|
<DEPLOYMENT_PROVIDER_MAPPING PROVIDERLIST="5">
<TYPE NAME="AZURE"></TYPE>
</DEPLOYMENT_PROVIDER_MAPPING>
<PROVIDERLIST NAME="5">
<ALLOWED_PROVIDERS><![CDATA[HADOOP_CLUSTER,LOCAL_PROCESS_CLUSTER,DATABRICKS,PRESTO,ATHENA,POSTGRESQL,AZURESQLDB,GENERIC,SNOWFLAKE]]></ALLOWED_PROVIDERS>
</PROVIDERLIST> |
Update the snapshot Bundle for Kyvos BI server configurations.
Restart the services.
Other important points to know
...