Error : ORDER BY in subqueries not allowed

Problem

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

Solution

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:http://stackoverflow.com/questions/2101908/is-order-by-clause-allowed-in-a-subquery
Properties

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

Feedback