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-date

MAX_PART_DATE Function - PL/HQL

MAX_PART_DATE function finds the maximum value for the specified partition column of type DATE.

Syntax:

MAX_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 maximum value

Return Value:

  • The maximum 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 maximum value of the partition:

MAX_PART_DATE(db.orders); 

Result: 2014-12-04

Example 2:

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

country=US/local_date=2014-12-02
country=US/local_date=2014-12-03
country=UK/local_date=2014-12-04

Find the maximum value for local_date partition column for country US:

MAX_PART_DATE(db.sales, local_date, country='US'); 

Result: 2014-12-03

Compatibility: PL/HQL extension.

Version: PL/HQL 0.01

See also: