GPU-Accelerated Querying in Kyvos

Kyvos introduces GPU-accelerated querying to deliver lightning-fast performance for large-scale analytical workloads. This capability is designed to work seamlessly across all raw data sources supported by Kyvos' No-Spark architecture, making it ideal for high-performance, modern BI environments.

How It Works

To enable GPU-based query optimization, Kyvos relies on a key configuration property:

• Property: kyvos.parquet.cuboid.enable

• Value: true

When this property is set to true, Kyvos stores aggregated cuboids (pre-aggregated data structures generated during semantic model builds) in Parquet format—a highly efficient, columnar storage format optimized for GPU processing.

Key Benefits

• Accelerated Query Performance: GPU-based execution significantly reduces query response times.

• Optimized Storage: Parquet format enables efficient disk usage and faster data access.

• Broad Compatibility: Works across all raw data sources within the No-Spark architecture.

• Scalability: Designed to handle massive datasets and complex analytical models.

Deployment Requirements

• Supported Platform: GPU acceleration is currently supported in AWS Enterprise environments only.

• Instance Type: Kyvos recommends using the g6.2xlarge instance type when creating Kyvos resources to enable GPU-based query execution.

Upgrade Guidelines

For AWS, during upgrades Kyvos and its components, ensure the drutdb_jdbc file is uploaded using either the Path-based or File-based method via the Upgrades page in Kyvos Manager. This enables detection and visibility of the hardware and execution configurations required for GPU support.

Points to know

• If GPU execution is unavailable, queries will automatically fall back to CPU execution without failure.

• The Query Details dialog box displays the execution mode—CPU or Hybrid—along with the percentage of the query processed by CPU or GPU.

• Kyvos currently supports only NVIDIA GPUs. Other GPU types are not supported.

• Columns with the BigDecimal data type are not supported for GPU-based querying.

• Only Base Aggregates are supported. Smart Aggregates are not supported.

• GPU-based querying is supported only for non-Spark-based semantic models. Queries on Spark-based models are not supported.

• Regardless of the instance’s GPU memory size, Kyvos currently utilizes up to 16 GB of GPU memory.

• After a fresh deployment with GPU support enabled, the query engine may require an additional restart to begin utilizing GPU resources effectively.

Known Behavior

• If a query does not complete GPU execution within 2 seconds (success or failure), it will timeout and automatically fall back to CPU execution.

• GPU-based querying is supported only on the amd64 (x86_64) architecture.
  arm64 architectures are not supported.

• When semantic models are built with Parquet-based cuboids, the following features are not supported:

  • Advanced hierarchies

  • Many-to-many relationships

  • Slowly Changing Dimensions (SCD)

  • Semi-additive measures

Read more advanced configurations:

• AS_GPU_MIN_CHUNK_SIZE 

• AS_GPU_MAX_CHUNK_SIZE