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)