Big integer

The big integer data type (bigint) is used to represent whole numbers that are outside the range of the integer data type and can be stored within 64 bits.

In most cases, columns of type bigint are used in links, selections, and tabulations. Columns of type bigint can also be specified as the G argument in g_functions such as g_sum(G;S;O;X).

Columns of type big integer can store information that cannot be represented within 32 bits such as:

  • Keys
  • Universally unique identifiers

Values in a column of type big integer are -9,223,372,036,854,775,806 to 9,223,372,036,854,775,806.

In some places in the 1010data Insights platform, the big integer data type (bigint) is also represented as j.

(Available as of version 11.25)