查看全部分区
show partitions tmp.test
>>>
dt=20220807/num=0
dt=20220807/num=1
dt=20220807/num=2
dt=20220807/num=3
dt=20220808/num=0
dt=20220808/num=1
dt=20220808/num=2
dt=20220808/num=3
dt=20220809/num=0
dt=20220809/num=1
dt=20220809/num=2
dt=20220809/num=3
dt=20220810/num=0
dt=20220810/num=1
dt=20220810/num=2
dt=20220810/num=3
查看特定分区
show partitions tmp.test partition (dt=20220810)
>>>
dt=20220810/num=0
dt=20220810/num=1
dt=20220810/num=2
dt=20220810/num=3
show partitions tmp.test partition (num=0)
>>>
dt=20220807/num=0
dt=20220808/num=0
dt=20220809/num=0
dt=20220810/num=0