Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error : ORDER BY in subqueries not allowed

Error : ORDER BY in subqueries not allowed

View products that this article applies to.

Problem

When performing a RevoScaleR operation on an In-Teradata data source, the error "ORDER BY in subqueries" is reported.

↑ Back to the top

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

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 3103855
Revision : 1
Created on : 1/7/2017
Published on : 11/1/2015
Exists online : False
Views : 68