Hive

Определение количества партиций таблицы

В БД, что под HMS:

SELECT COUNT(*) AS partition_count
FROM "PARTITIONS"
WHERE "TBL_ID" = (
    SELECT t."TBL_ID"
        FROM "TBLS" t
    	JOIN "DBS" d ON t."DB_ID" = d."DB_ID"
    	WHERE d."NAME" = 'db_name'
      		AND t."TBL_NAME" = 'table_name'
    	LIMIT 1
	);