User Tools

Site Tools


Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

max-part-int

====== MAX_PART_INT Function - PL/HQL ====== MAX_PART_INT function finds the maximum value for the specified partition column of type INT. **Syntax**: <code language="sql"> MAX_PART_INT([db_name.]table_name [, column_name [, part_col=filter, ...]]); </code> **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 maximum value * If the partition contains non-integer values they are ignored **Return Value:** * The maximum 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 | | country=US/local_dt=2014-12-05/hour=2 | | country=US/local_dt=2014-12-05/hour=3 | | country=US/local_dt=2014-12-05/hour=UNKNOWN | Find the maximum value of the partition //hour//: <code language="sql"> MAX_PART_INT(db.orders, hour); </code> Result: 3 **Example 2:** Table //db.sales// is partitioned by //country//, //local_date// and //hour// has the following partitions: | country=US/local_dt=2014-12-06/hour=1 | | country=US/local_dt=2014-12-07/hour=2 | | country=US/local_dt=2014-12-07/hour=UNKNOWN | | country=US/local_dt=2014-12-08/hour=3 | Find the maximum value for //hour// partition for local_date '2014-12-07': <code language="sql"> MAX_PART_INT(db.sales, hour, local_date='2014-12-07'); </code> Result: 2 **Compatibility**: PL/HQL extension. **Version:** PL/HQL 0.01 See also: * [[min-part-int|MIN_PART_INT(table, colname, partition_spec)]] * [[max-part-string|MAX_PART_STRING(table, colname, partition_spec)]] * [[min-part-string|MIN_PART_STRING(table, colname, partition_spec)]] * [[max-part-date|MAX_PART_DATE(table, colname, partition_spec)]] * [[min-part-date|MIN_PART_DATE(table, colname, partition_spec)]]