Reading an Iceberg table
You see an example of how to read an Apache Iceberg table, and understand the advantages of Iceberg.
iceberg.table_identifier is not set in Cloudera Data Warehouse,
so you can use the familiar <db_name.<table_name> in queries.
- You must meet the prerequisites to query Iceberg tables from a Virtual Warehouse mentioned earlier.
In a Hive or Impala Virtual Warehouse, open Hue, and select a database.
Query an Iceberg table partitioned by city.
SELECT * FROM ice_t2 WHERE city="Bangalore";