Remove 2003 Remove Business Intelligence Remove Snapshot Remove Testing
article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

Materialized views are valuable for accelerating common classes of business intelligence (BI) queries that consist of joins, group-bys and aggregate functions. Subsequently, these snapshot IDs are used to determine the delta changes that should be applied to the materialized view rows.

article thumbnail

How to Use Apache Iceberg in CDP’s Open Lakehouse

Cloudera

With Iceberg in CDP, you can benefit from the following key features: CDE and CDW support Apache Iceberg: Run queries in CDE and CDW following Spark ETL and Impala business intelligence patterns, respectively. 6 2003 6488540. Let’s see the data as of the second snapshot: select year, count(*) from flights_v3.