Selecting 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 CDP, so you can use the
familiar <db_name.<table_name> in queries.
- You must meet the prerequisites to query Iceberg tables mentioned earlier.
Use a database.
Query an Iceberg table partitioned by city.
SELECT * FROM ice_t2 WHERE city="Bangalore";