最后编辑于2022-04
我们有不少动态表,想查这些动态表的当前properties怎么查呢?比如创建时的语句可能如下:
CREATE TABLE mytbl
(...)
PROPERTIES
(
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.end" = "2",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1",
"replication_num" = "2",
"in_memory" = "false",
"storage_format" = "V2"
...
)
我想查看当前该表各个properties参数的值如何查啊?比如想看dynamic_partition.buckets 等等参数
我了解可直接用alter重新设定这些属性值。但历史原因我们各个表在创建时的properties设定的不一样,在修改前想确认一下这些参数
收藏
点赞
0
个赞
请登录后评论
TOP
切换版块
SHOW CREATE TABLE XXXX 可查到