16.20 - Restrictions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

The following rules and restrictions apply to the use of the RANDOM function.

  • RANDOM can only be called in one of the following SELECT query clauses:
    • WHERE
    • GROUP BY
    • ORDER BY
    • HAVING/QUALIFY
  • RANDOM cannot be referenced by position in a GROUP BY or ORDER BY clause.
  • RANDOM cannot be nested inside aggregate or ordered analytical functions.
  • RANDOM cannot be used in the expression list of an INSERT statement to create a primary index or partitioning column value.

    For example:

       INSERT t1 (RANDOM(1,10),...) 

    RANDOM causes an error to be reported in this case if the first column in the table is a primary index or partitioning column.