RE: Aggregate Multiple Columns

2012-08-16 Thread richin.jain
@hive.apache.org Subject: Re: Aggregate Multiple Columns Hi Richin, Do you mean summing the values from two columns into one number, or calculating sum of both columns into two sums in one query? Both is possible, the first can be done simply as SUM(col1 + col2), the second can be accomplished with two

Re: Aggregate Multiple Columns

2012-08-16 Thread Jan DolinĂ¡r
question? Best regards, Jan On Thu, Aug 16, 2012 at 4:28 PM, wrote: > Hello, > > ** ** > > Is there a way to aggregate multiple columns in Hive? > > I can do it in two separate queries but is there something similar to > sum(col1,col2)? > > ** ** > > Thanks, > > Richin >

Aggregate Multiple Columns

2012-08-16 Thread richin.jain
Hello, Is there a way to aggregate multiple columns in Hive? I can do it in two separate queries but is there something similar to sum(col1,col2)? Thanks, Richin