HyukjinKwon commented on pull request #29126:
URL: https://github.com/apache/spark/pull/29126#issuecomment-661029664


   The previous exception message doesn't particularly wrong to me if you're 
arguing:
   
   ```
   LATERAL cannot be used together with PIVOT in FROM clause
   ```
   
   doesn't explain the case below:
   
   ```sql
   SELECT * FROM person
   PIVOT (
   count(distinct age) as a
   for name in ('Mary','John')
   )
   lateral view outer explode(array(30,60)) tabelName as c_age
   lateral view explode(array(40,80)) as d_age
   ```
   
   because it already clarifies `FROM` and `PIVOT`.
   
   


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



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to