Re: PostgresSql queries vs spark sql

I found it. We can use pivot which is similar to cross tab In postgres. Thank you. On Oct 17, 2016 10:00 PM, "Selvam Raman" wrote: > Hi, > > Please share me some idea if you work on this earlier. > How can i develop postgres CROSSTAB function in spark. > > Postgres Example > >

PostgresSql queries vs spark sql

Hi, Please share me some idea if you work on this earlier. How can i develop postgres CROSSTAB function in spark. Postgres Example Example 1: SELECT mthreport.* FROM *crosstab*('SELECT i.item_name::text As row_name, to_char(if.action_date, ''mon'')::text As bucket,