Applies To
Revolution Analytics

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.