Row ordering on each AMP by a single NUSI column: either value-ordered or hash-ordered.
You cannot order rows on a BLOB, CLOB, Period, UDT, XML, Geospatial, JSON, or DATASET column.
See Teradata Vantage™ - SQL Fundamentals, B035-1141 for the rules for naming database objects.
Rules for using an ORDER BY clause are shown in the following table:
- If you specify ORDER BY with VALUES, then the ORDER BY column_name must be numeric with four bytes or less.
- If you specify ORDER BY without also specifying either HASH or VALUES, then Vantage assumes VALUES by default.
- If you specify ORDER BY with a column name, then the ORDER BY column_name must be one of the columns in the INDEX list of columns.
- VALUES
- Value-ordering for the ORDER BY column.
- HASH
- Hash-ordering for the ORDER BY column.
- order_column_name
- A column in the INDEX list of columns that specifies the sort order to be used.