<< (lt lt sign) operator

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

Returns expr bitwise left shifted by n bits. This operator is a synonym for shiftleft function.

Syntax

expr << n

Arguments

  • expr: An INTEGER or BIGINT expression.
  • n: An INTEGER expression.

Returns

The result matches the type of expr.

The effective shift distance is n modulo 32 for an INTEGER expr and modulo 64 for a BIGINT expr.

Examples

> SELECT 2 << 1;
 4
> SELECT 1 << -1;
 -2147483648
  • อัปเดตล่าสุดเมื่อ