INT type

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Represents 4-byte signed integer numbers.

Syntax 

{ INT | INTEGER }

Limits

The range of numbers is from -2,147,483,648 to 2,147,483,647.

Literals 

[ + | - ] digit [ ... ]

digit: Any numeral from 0 to 9.

If the literal is outside of the range for an INT it will be implicitly turned into a BIGINT.

Examples 

> SELECT +1;
  1

> SELECT CAST('5' AS INT);
  5

> SELECT typeof(-2147483649);
  BIGINT