Seems like you would want the results as:
7
3
Here is one way to get the maximum value for a collection of columns with a
case statement.
(this not done in Hive but hive case statements should work same way)
## data in table xyz
select * from xyz ;
c1 | c2 | c3
++
2 | 1 | 3
3
doop setup I have in
> another VM. It also worked correctly. (I don't have Hive v0.9.0
> available in the MapR VM.)
>
> Hope this helps.
>
> dean
>
> On Tue, Nov 20, 2012 at 9:43 AM, John Morrison
> wrote:
>>
>> Hi,
>>
>>
>>
>>
Hi,
New to hive in last few weeks and could use some help with JOINs.
Using MapR (version 0.9.0)/usr/bin/hive ->
/opt/mapr/hive/hive-0.9.0/bin/hive
I have 2 tables I am wanting to join by date (order_t and date_t). DDL at
bottom.
I have reduced this to 1 column and 1 row and still can't
