16.20 - Restrictions - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.