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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×