mdayakar commented on code in PR #115: URL: https://github.com/apache/hive-site/pull/115#discussion_r3913873428
########## content/docs/latest/user/hive-hplsql/functions/part-count.md: ########## @@ -0,0 +1,72 @@ +--- +title: "Apache Hive : PART_COUNT Function" +date: 2026-08-12 +--- + +# Apache Hive : PART_COUNT Function + +PART_COUNT function returns the number partitions in the specified table. + +**Syntax**: + +``` +PART_COUNT([db_name.]table_name, part_col=filter, ...); +``` + +**Parameters:** + +| [dbname.]table_name | Identifier, variable or expression | Review Comment: Fixed ########## content/docs/latest/user/hive-hplsql/functions/min-part-date.md: ########## @@ -0,0 +1,82 @@ +--- +title: "Apache Hive : MIN_PART_DATE Function - HPL/SQL" +date: 2026-08-12 +--- + +# Apache Hive : MIN_PART_DATE Function - HPL/SQL + +MIN_PART_DATE function finds the minimum value for the specified partition column of type DATE. + +**Syntax**: + +``` +MIN_PART_DATE([db_name.]table_name [, column_name [, part_col=filter, ...]]); +``` + +**Parameters:** + +| **Parameter** | **Type** | **Value** | **Description** | +| --- | --- | --- | --- | +| [dbname.]table_name | VARCHAR | Identifier, variable or expression | Table name | +| column_name | VARCHAR | Identifier, variable or expression | Partition column name | +| part_col=filter | | | Partition filter | + +**Notes**: + +- If column name is not specified, the first partition column is used +- Partition filter applied before finding the minimum value + +**Return Value:** + +- The minimum date for the specified partition +- NULL if the table or partition do not exist, or the table is empty + +**Return Type:** + +DATE. + +**Example 1:** + +Table *db.orders* is partitioned by *local_date* and has the following partitions: + +| local_date=2014-12-02 | +| --- | +| local_date=2014-12-03 | +| local_date=2014-12-04 | + +Find the minimum value of the partition: + +``` +MIN_PART_DATE(db.orders); +``` + +Result: 2014-12-02 + +**Example 2:** + +Table *db.sales* is partitioned by *country* and *local_date* and has the following partitions: + +| country=US/local_date=2014-12-02 | 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]
