Support Questions
Find answers, ask questions, and share your expertise

Ho to Identify Maximum Partitions

Explorer

Need to identify a way to query HiveMetastore(Mysql) and gather output in following format

DB_NAME, TABLE_NAME, PARTITION_COUNT


We have about 1.2 Mil Partitions, There is a scope to delete unwanted partitions of older dates to save on query latency.