LEAVE statement

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 16.3 and above

Terminates the execution of an iteration of a looping statement and exits the loop.

This statement may only be used within a compound statement.

Syntax

LEAVE label

Parameters

  • label

    The label identifies a statement to leave that directly or indirectly contains the LEAVE statement. In Databricks SQL and Databricks Runtime 18.0 and above, you can specify the label with the IDENTIFIER clause, for example LEAVE IDENTIFIER('my_loop').

Examples

-- sum up all odd numbers from 1 through 10
-- Iterate over even numbers and leave the loop after 10 has been reached.
> BEGIN
    DECLARE sum INT DEFAULT 0;
    DECLARE num INT DEFAULT 0;
    sumNumbers: LOOP
      SET num = num + 1;
      IF num > 10 THEN
        LEAVE sumNumbers;
      END IF;
      IF num % 2 = 0 THEN
        ITERATE sumNumbers;
      END IF;
      SET sum = sum + num;
    END LOOP sumNumbers;
    VALUES (sum);
  END;
25
  • Viimeksi päivitetty