User Tools

Site Tools


Sidebar

HPL/SQL is included to Apache Hive since version 2.0

plus

This is an old revision of the document!


Addition Operator (+) - PL/HQL

You can use + arithmetic operator to add two numbers, or add an interval to a DATE value.

Syntax:

expr + expr

Add Two Integers

When you add two integer values the result of the operation also has an integer value.

Example:

Expression Result Result Type
3 + 1 4 Integer

Add an Integer to Date

When you add an integer to a DATE value, PL/HQL adds the number of days to the DATE and the result of the operation is a DATE value.

Example:

Expression Result Result Type
DATE '2014-12-31' + 1 DATE '2015-01-01' DATE