User Tools

Site Tools

A PCRE internal error occured. This might be caused by a faulty plugin

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

plus

====== Addition Operator (+) ====== You can use + arithmetic operator to add two numbers, concatenate two strings, or add an interval to a DATE value. **Syntax:** <code> expr + expr </code> ===== 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 | ===== Concatenate Two Strings ===== When you use + for string operand the result of the operation is the concatenated string. **Example:** | **Expression** | **Result** | **Result Type** | | 'Ab' + 'c' | 'Abc' | String | ===== 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 |