Sidebar

HPL/SQL is included to Apache Hive since version 2.0

break

BREAK Statement - PL/HQL Reference

BREAK statement exits the innermost loop.

Syntax:

BREAK;

Example:

DECLARE count INT DEFAULT 3;
WHILE 1=1 BEGIN
  SET count = count - 1;
  IF count = 0
    BREAK;
END

Compatibility: Microsoft SQL Server.