Teradata Database Message 9480 - 9480 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Message
- ROWID must be specified with an alias for a column-partitioned join index.
- Explanation
- The system-derived column ROWID with an alias must be specified in the select expression list of a CREATE JOIN INDEX statement when column partitioning is specified for the join index. The name ROWID must not be referenced in the column grouping if column grouping is specified in the COLUMN clause of the PARTITION BY clause; use the alias instead.
- Generated By
- RES module.
- For Whom
- End User.
- Notes
- None
- Remedy
- Specify an alias for ROWID in the select expression list and, if column grouping is specified in the COLUMN clause of the PARTITION BY clause and you want to reference it in the grouping clause, reference its alias (not ROWID) in the column grouping and resubmit.