HPL/SQL is included to Apache Hive since version 2.0
This is an old revision of the document!
You can use + arithmetic operator to add two numbers, concatenate two strings, or add an interval to a DATE value.
expr + expr
When you add two integer values the result of the operation also has an integer value.
|3 + 1||4||Integer|
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.
|DATE '2014-12-31' + 1||DATE '2015-01-01'||DATE|