Error : ORDER BY in subqueries not allowed


When performing a RevoScaleR operation on an In-Teradata data source, the error "ORDER BY in subqueries" is reported.


Even though the SQL query string used to create the query passed to RevoScaleR function may not be a subquery, the query object passed to Teradata is treated as a subquery. The SQL supplied to the RevoScaleR function for an In-Teradata operation must be a valid subquery.  Further discussion can be found here:

Article ID: 3103855 - Last Review: 1 Nov 2015 - Revision: 1