mdayakar commented on code in PR #115: URL: https://github.com/apache/hive-site/pull/115#discussion_r3913867965
########## content/docs/latest/user/hive-hplsql/functions/min-part-int.md: ########## @@ -0,0 +1,86 @@ +--- +title: "Apache Hive : MIN_PART_INT Function - HPL/SQL" +date: 2026-08-12 +--- + +# Apache Hive : MIN_PART_INT Function - HPL/SQL + +MIN_PART_INT function finds the minimum value for the specified partition column of type INT. + +**Syntax**: + +``` +MIN_PART_INT([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 +- If the partition contains non-integer values they are ignored + +**Return Value:** + +- The minimum INT value for the specified partition +- NULL if the table or partition do not exist, or the table is empty + +**Return Type:** + +INT. + +**Example 1:** + +Table *db.orders* is partitioned by *country*, *local_dt* and *hour* and has the following partitions: + +| country=US/local_dt=2014-12-05/hour=1 | Review Comment: Fixed ########## content/docs/latest/user/hive-hplsql/statements/open.md: ########## @@ -0,0 +1,59 @@ +--- +title: "Apache Hive : OPEN Statement - HPL/SQL Reference" +date: 2026-08-12 +--- + +# Apache Hive : OPEN Statement - HPL/SQL Reference + +OPEN statement opens a cursor. + +**Syntax**: + +``` +OPEN cursor_name [FOR expression | select_statement]; +``` + +**Description:** +| cursor_name | The name of the previously declared cursor if FOR clause is not specified | 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]
