Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ho to Identify Maximum Partitions

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.

Don't have an account?
Coming from Hortonworks? Activate your account here