I don't want to get any aggregation, just want to know rather saying distinct to all columns any other better approach ?
On Wed, May 30, 2018 at 12:16 AM, Irving Duran <irving.du...@gmail.com> wrote: > Unless you want to get a count, yes. > > Thank You, > > Irving Duran > > > On Tue, May 29, 2018 at 1:44 PM Chetan Khatri <chetan.opensou...@gmail.com> > wrote: > >> Georg, I just want to double check that someone wrote MSSQL Server script >> where it's groupby all columns. What is alternate best way to do distinct >> all columns ? >> >> >> >> On Wed, May 30, 2018 at 12:08 AM, Georg Heiler <georg.kf.hei...@gmail.com >> > wrote: >> >>> Why do you group if you do not want to aggregate? >>> Isn't this the same as select distinct? >>> >>> Chetan Khatri <chetan.opensou...@gmail.com> schrieb am Di., 29. Mai >>> 2018 um 20:21 Uhr: >>> >>>> All, >>>> >>>> I have scenario like this in MSSQL Server SQL where i need to do >>>> groupBy without Agg function: >>>> >>>> Pseudocode: >>>> >>>> >>>> select m.student_id, m.student_name, m.student_std, m.student_group, >>>> m.student_d >>>> ob from student as m inner join general_register g on m.student_id = >>>> g.student_i >>>> d group by m.student_id, m.student_name, m.student_std, >>>> m.student_group, m.student_dob >>>> >>>> I tried to doing in spark but i am not able to get Dataframe as return >>>> value, how this kind of things could be done in Spark. >>>> >>>> Thanks >>>> >>> >>