Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

...

Teradata Data Type

CDAP Schema Data Type

Support

Comment

BYTEINT

Schema.Type.INT+

SMALLINT

Schema.Type.INT+

INTEGER

Schema.Type.INT+

BIGINT

Schema.Type.LONG+

DECIMAL/NUMERIC

Schema.LogicalType.DECIMAL+

FLOAT/REAL/DOUBLE PRECISION

Schema.Type.DOUBLE+

NUMBER

Schema.LogicalType.DECIMAL+

BYTE

Schema.Type.BYTES

+

VARBYTE

Schema.Type.BYTES+
BLOBSchema.Type.BYTES+

CHAR

Schema.Type.STRING+

VARCHAR

Schema.Type.STRING+
CLOBSchema.Type.STRING+

DATE

Schema.Type.DATE+

TIME

Schema.LogicalType.TIME_MICROS+

TIMESTAMP

Schema.LogicalType.TIMESTAMP_MICROS+

TIME WITH TIME ZONE




TIMESTAMP WITH TIME ZONE




INTERVAL YEAR




INTERVAL YEAR TO MONTH




INTERVAL MONTH




INTERVAL DAY




INTERVAL DAY TO HOUR




INTERVAL DAY TO MINUTE




INTERVAL DAY TO SECOND




INTERVAL HOUR




INTERVAL HOUR TO MINUTE




INTERVAL HOUR TO SECOND




INTERVAL MINUTE




INTERVAL MINUTE TO SECOND




INTERVAL SECOND




PERIOD(DATE)




PERIOD(TIME)




PERIOD(TIME WITH TIME ZONE)




PERIOD(TIMESTAMP)




PERIOD(TIMESTAMP WITH TIME ZONE)




JSON


SET


ARRAY


XML


ST_Geometry




MBR




...