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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.