metastore=# select d."NAME" as DATABASE,
t."TBL_NAME" as TABLE,
p."PKEY_NAME" as PARTITION_KEY
from "PARTITION_KEYS" p
join "TBLS" t on p."TBL_ID"=t."TBL_ID"
join "DBS" d on t."DB_ID"=d."DB_ID";
database | table | partition_key
----------+-------------+---------------
default | src_union_1 | ds
default | cbo_t1 | dt
default | cbo_t2 | dt
1条答案
按热度按时间ufj5ltwl1#
您可以直接连接到元存储并查询它:
查询元存储的确切语法取决于元存储的特定选择(在我的例子中是postgresql)。