dilipbiswal commented on issue #24150: [SPARK-27209][SQL] Split parsing of 
SELECT and INSERT into two top-level rules in the grammar file.
URL: https://github.com/apache/spark/pull/24150#issuecomment-475702047
 
 
   @cloud-fan and the error if we specify the from clause on a multi select 
query to add to the confusion :-)
   ```
   spark-sql> from foo
            > select c1 from foo where c1 = 1
            > select c1 from foo where c1 = 2;
   Error in query: 
   Multi-Insert queries cannot have a FROM clause in their individual SELECT 
statements(line 2, pos 0)
   
   == SQL ==
   from foo
   select c1 from foo where c1 = 1
   ^^^
   select c1 from foo where c1 = 2
   ```
   Please note the reference to "insert" .. even though there is no insert in 
the query. 

----------------------------------------------------------------
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]

Reply via email to