dongjoon-hyun commented on a change in pull request #24348: [SPARK-27444][SQL]
multi-select can be used in subquery
URL: https://github.com/apache/spark/pull/24348#discussion_r274508547
##########
File path:
sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/parser/PlanParserSuite.scala
##########
@@ -132,15 +132,19 @@ class PlanParserSuite extends AnalysisTest {
table("a").select(star()).union(table("a").where('s <
10).select(star())))
intercept(
"from a select * select * from x where a.s < 10",
- "Multi-select queries cannot have a FROM clause in their individual
SELECT statements")
+ "This select statement can not have FROM cause as its already specified
upfront")
intercept(
"from a select * from b",
- "Individual select statement can not have FROM cause as its already
specified in " +
- "the outer query block")
+ "This select statement can not have FROM cause as its already specified
upfront")
assertEqual(
"from a insert into tbl1 select * insert into tbl2 select * where s <
10",
table("a").select(star()).insertInto("tbl1").union(
table("a").where('s < 10).select(star()).insertInto("tbl2")))
+ assertEqual(
+ "select * from (from a select * select *)",
Review comment:
Thank you for adding this.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
