Re: SQL Syntax for pivots

Not right now. On Wed, Nov 16, 2016 at 10:44 PM, Niranda Perera wrote: > Hi all, > > I see that the pivot functionality is being added to spark DFs from 1.6 > onward. > > I am interested to see if there is a Spark SQL syntax available for > pivoting? example: Slide 11 of [1] > > *pandas (Python

SQL Syntax for pivots

Hi all, I see that the pivot functionality is being added to spark DFs from 1.6 onward. I am interested to see if there is a Spark SQL syntax available for pivoting? example: Slide 11 of [1] *pandas (Python) - pivot_table(df, values='D', index=['A', 'B'], columns=['C'], aggfunc=np.sum) * *resha