=========查询分区的大小=========

select d.NAME,t.TBL_NAME,p.PART_NAME,prm.PARAM_KEY,prm.PARAM_VALUE

from TBLS t

left join DBS d   on t.DB_ID = d.DB_ID

left join PARTITIONS p   on t.TBL_ID = p.TBL_ID

left join PARTITION_PARAMS prm  on p.PART_ID=prm.PART_ID

where d.NAME='novel'

and t.TBL_NAME='textfile_table'

and p.PART_NAME like 'event_day=20180402/event_hour=%'

and prm.PARAM_KEY = 'totalSize';

=========查询分区信息=========

select d.NAME,t.TBL_NAME,p.PART_NAME,p.PART_ID

from TBLS t

left join DBS d   on t.DB_ID = d.DB_ID

left join PARTITIONS p   on t.TBL_ID = p.TBL_ID

where d.NAME='novel'

and t.TBL_NAME='textfile_table'