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