Github user Tagar commented on the issue:

    https://github.com/apache/spark/pull/21187
  
    Would be great to make `FOR` section optional.
    E.g. - make `FOR year IN (2012, 2013)` optional in one of your examples.
    Currently `pivot()` when called programmatically, doesn't require to have 
list of values 
    defined up-front. 
    Otherwise it'll be a big inconvenience/limitation in `PIVOT` when called 
from SQL.
    
    Notice that Oracle's PIVOT when used on XML doesn't require list of values 
either -
    https://community.oracle.com/thread/2183084 



---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to