mdayakar commented on code in PR #115: URL: https://github.com/apache/hive-site/pull/115#discussion_r3913863740
########## content/docs/latest/user/hive-hplsql/functions/part-count-by.md: ########## @@ -0,0 +1,72 @@ +--- +title: "Apache Hive : PART_COUNT_BY Function" +date: 2026-08-12 +--- + +# Apache Hive : PART_COUNT_BY Function + +PART_COUNT_BY function returns the number partitions grouped by specified partition columns in the table. + +**Syntax**: + +``` +PART_COUNT_BY([db_name.]table_name, [part_col, ...]); +``` + +**Parameters:** + +| [dbname.]table_name | Identifier, variable or expression | +| --- | --- | +| part_col | One or more partition columns used for aggregation | + +**Return Value:** + +- The number of top-level partitions if *part_col* is not specified +- Partition value and total number of existing partitions with the same value if *part_col* is not specified + +**Examples:** + +Table *db.orders* is partitioned by *dt* and *region* columns and has the following partitions: + +| dt=2015-09-01/region=1 | Review Comment: Fixed -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
