[SPARK-12745] Limit is not supported inside Set Operation

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Later
• Affects Version/s: 1.6.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Xiao Li
• Created: 11/Jan/16 01:10
• Updated: 12/Jan/16 01:48
• Resolved: 12/Jan/16 01:48

Description

The current SQLContext allows the following query, which is copied from a test case in SQLQuerySuite:

     checkAnswer(sql(
       """
         |select key from ((select * from testData limit 1)
         |  union all (select * from testData limit 1)) x limit 1
       """.stripMargin),
       Row(1)
     )

However, it is rejected in the Hive parser.

Issue Links

• links to: [Github] Pull Request #10689 (gatorsmile)