7.00.02.01 - Statistics Functions Behavior for bool, char, bit, and varbit Data Types - 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

The behavior of the bool, char, bit, and varbit data types for statistics functions is:

  • For character columns, the values can contain "", "NA", or an all digit string. For example, "123".
  • For boolean columns, the Aster boolean is:
    • converted to 1 or 0 (numeric) through RODBC
    • converted to "t" or "f" through ta.pull
    • converted to "t" or "f" in the STREAM Rexec call
  • For bit and varbit columns, the values only contain "1" and "0".

In each case, RODBC will recognize the data type value as a numeric (double or integer) values. As a result, statistics functions do not detect non-numeric columns before executing the SQL.