HPL/SQL is included to Apache Hive since version 2.0
LEAVE statement exits the loop or block marked by the given label. If the label is not specified, LEAVE exists the innermost loop.
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.