HPL/SQL is included to Apache Hive since version 2.0
You can use the VALUES INTO statement to assign values to variables in PL/HQL.
If the variable was not explicitly declared before the assignment, a new variable is created and its data type is derived from the assignment expression.
VALUES expression INTO var; | VALUES (expression [, expression2, ...]) INTO (var [, var2, ...]);
VALUES 'A' INTO code; VALUES (0, 100) INTO (count, limit);
Compatibility: IBM DB2
Version: PL/HQL 0.03