Apache Hive : HPL/SQL - MAX_PART_STRING Function

MAX_PART_STRING function finds the maximum value (last in alphabetical order) for the specified partition column of type STRING (VARCHAR/CHAR).

Syntax:

MAX_PART_STRING([db_name.]table_name [, column_name [, part_col=filter, ...]]); 

Parameters:

Notes:

• If column name is not specified, the first partition column is used
• Partition filter applied before finding the maximum value

Return Value:

• The maximum string for the specified partition
• NULL if the table or partition do not exist, or the table is empty

Return Type:

STRING (VARCHAR/CHAR).

Example 1:

Table db.orders is partitioned by country and has the following partitions:

Find the maximum value of the partition:

MAX_PART_STRING(db.orders); 

Result: US

Example 2:

Table db.sales is partitioned by country and local_date and has the following partitions:

Find the maximum value for country partition column for local_date ‘2014-12-04’:

MAX_PART_STRING(db.sales, country, local_date='2014-12-04'); 

Result: UK

Compatibility: HPL/SQL extension.

See also:

• MIN_PART_STRING(table, colname, partition_spec)
• MAX_PART_INT(table, colname, partition_spec)
• MIN_PART_INT(table, colname, partition_spec)
• MAX_PART_DATE(table, colname, partition_spec)
• MIN_PART_DATE(table, colname, partition_spec)