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:
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 3103855 - Last Review: 11/01/2015 16:02:00 - Revision: 1.0

Revolution Analytics

  • KB3103855