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

Teradata Aster® R User GuideUpdate 3

Product
Aster R
Release Number
7.00.02.01
Published
December 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
fop1497542774450.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
fbp1477004286096
lifecycle
previous
Product Category
Software

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)