APPLY Table Operator Data Types| Open Analytics Framework | Teradata VantageCloud Lake - APPLY Table Operator Data Types - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
The APPLY table operator supports the following Teradata data types:
  • Date and Time:
    Teradata Data Type Required Format Examples
    DATE YYYY-MM-DD 2001-01-01

    9999-12-31
    TIME HH:MM:SS.S(F) 07:46:39.604876

    22:11:59.84

    01:05:38
    TIME WITH TIME ZONE HH:MM:SS.S(F)Z 22:45:21.46-06:30

    22:36:42.565-02:01
    TIMESTAMP YYYY-MM-DD HH:MM:SS.S(F) 2001-01-01 07:46:39.604876

    2001-05-18 22:11:59.84

    2002-11-28 01:05:38
    TIMESTAMP WITH TIME ZONE YYYY-MM-DD HH:MM:SS.S(F)Z 2001-02-15 22:45:21.46-06:30

    1979-08-02 22:36:42.565-02:01
  • String: CHAR, VARCHAR.
  • Numeric: BIGINT, BYTEINT, DECIMAL, FLOAT, INTEGER, SMALLINT.
  • LOB data types: BLOB, CLOB.
The script writer needs to format their data with the required data type format to successfully load the input data from the script in the database.