7.00.02.01 - Mapping between integer64 in R and bigint in the Aster Database - Aster R

Teradata Aster® R User GuideUpdate 3

prodname
Aster R
vrm_release
7.00.02.01
created_date
December 2017
category
Programming Reference
User Guide
featnum
B700-1033-700K

R does not support 64-bit integers without the installation of an external library. Because of this limitation, 9,223,372,036,854,775,807 is stored as a numeric data type, which changes the original value to 9,223,372,036,854,775,808.

Users can use one of these two methods to resolve the issue:

  • Install the bit64 R package. Aster R supports the mapping between "integer64" in R and "bigint" in the Aster Database.
  • Store 9,223,372,036,854,775,807 as a character. For example:
    > bi <- c("-9223372036854775808", "9223372036854775807", NULL, "2147483647", "-2147483648")
    > mydata<-data.frame(bi)
    > ta.push("test_bigint", mydata)