Re: [SPAM] Customized Aggregation Query on Spark SQL

2015-04-30 Thread Wenlei Xie
20 C20 >> >> The desired output would be >> Name AgeOther >> A 30 A30 >> B 15 B15 >> C 20 C20 >> >> Thank you so much for t

Re: [SPAM] Customized Aggregation Query on Spark SQL

2015-04-30 Thread Zhan Zhang
M, ayan guha mailto:guha.a...@gmail.com>> wrote: can you give an example set of data and desired output> On Sat, Apr 25, 2015 at 2:32 PM, Wenlei Xie mailto:wenlei@gmail.com>> wrote: Hi, I would like to answer the following customized aggregation query on Spark SQL 1. Group the tab

Re: Customized Aggregation Query on Spark SQL

2015-04-24 Thread ayan guha
the help! > > On Sat, Apr 25, 2015 at 12:41 AM, ayan guha wrote: > >> can you give an example set of data and desired output> >> >> On Sat, Apr 25, 2015 at 2:32 PM, Wenlei Xie wrote: >> >>> Hi, >>> >>> I would like to answer the follo

Re: Customized Aggregation Query on Spark SQL

2015-04-24 Thread ayan guha
can you give an example set of data and desired output> On Sat, Apr 25, 2015 at 2:32 PM, Wenlei Xie wrote: > Hi, > > I would like to answer the following customized aggregation query on Spark > SQL > 1. Group the table by the value of Name > 2. For each group, choose t

Customized Aggregation Query on Spark SQL

2015-04-24 Thread Wenlei Xie
Hi, I would like to answer the following customized aggregation query on Spark SQL 1. Group the table by the value of Name 2. For each group, choose the tuple with the max value of Age (the ages are distinct for every name) I am wondering what's the best way to do it on Spark SQL? Should