SHOW ICEBERG TABLES¶
SHOW ICEBERG TABLES列出当前账户可见的 Iceberg 表映射。
描述¶
结果包含 catalog、namespace、table、ref、read_mode 和 write_mode 列。可以使用下列目录和命名空间形式缩小范围。为兼容语法而解析的 LIKE 和 WHERE 子句在执行时不受支持。
语法¶
SHOW ICEBERG TABLES
SHOW ICEBERG TABLES FROM catalog_name
SHOW ICEBERG TABLES FROM catalog_name.namespace
SHOW ICEBERG TABLES IN CATALOG catalog_name
SHOW ICEBERG TABLES IN NAMESPACE namespace
SHOW ICEBERG TABLES IN NAMESPACE namespace IN CATALOG catalog_name
示例¶
SHOW ICEBERG TABLES;
SHOW ICEBERG TABLES FROM prod_catalog;
SHOW ICEBERG TABLES FROM prod_catalog.sales;
SHOW ICEBERG TABLES IN CATALOG prod_catalog;
SHOW ICEBERG TABLES IN NAMESPACE sales;
SHOW ICEBERG TABLES IN NAMESPACE sales IN CATALOG prod_catalog;