HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
RETURN statement is used to return from a routine.
Syntax:
RETURN [expr];
Parameters:
Parameter | Type | Value | Description |
expr | INT | Variable or expression | Return value |
Notes:
Examples:
RETURN;
Return the result of an expression:
RETURN NVL(v1, 1);
Compatibility: Oracle, IBM DB2, SQL Server, Teradata, PostgreSQL, MySQL, Netezza.
Version: PL/HQL 0.01