Partition-Based Analytical Views

This section describes Arcadia Data's partition-based analytical views, and how they work to accelerate queries.

The refresh mechanism for these analytical views depends on the analytical views and the base table being partitioned on the same columns. Arcadia Engine detects changes to partitions of the base table, and determines which partitions of the analytical view it must refresh. Release 4.5.0.0, partition-based analytical views work for tables stored in HDFS, S3, and ADLS.

• Operations for Partition-Based Analytical Views

  • CREATE ANALYTICAL VIEW; Partition-Based
  • REFRESH ANALYTICAL VIEW; Partition-Based
  • SHOW ANALYTICAL VIEWS
  • DROP ANALYTICAL VIEW
• Using Partition-Based Analytical Views
  • Creating Base Tables
  • Loading or Inserting Data into Base Tables
  • Creating Analytical Views
  • Refreshing Analytical Views (populating data into analytical views)
  • Processing User Queries

• Best Practices for Partition-Based Analytical Views