**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]]
Sidebar
leave
LEAVE Statement - PL/HQL Reference
LEAVE statement exits the loop or block marked by the given label. If the label is not specified, LEAVE exists the innermost loop.
Syntax:
LEAVE [label];
Example:
lbl:
WHILE count > 0 DO
SET count = count - 1;
IF count = 0 THEN
LEAVE lbl;
END IF;
END WHILE;
lbl:
WHILE 1=1 DO
lbl1:
WHILE 1=1 DO
LEAVE lbl;
END WHILE;
END WHILE;
Compatibility: Teradata, IBM DB2 and MySQL.
Page Tools
