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.

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.