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
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.
Properties

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

Revolution Analytics

  • KB3103855
Feedback