> (BLOOMBERG/ PRINCETON ) , Peter Babinski
> (BLOOMBERG/ PRINCETON ) , Bernat Gabor
> (BLOOMBERG/ LONDON ) , Shashank Singh (BLOOMBERG/
> PRINCETON )
> Subject: Re: Issues with aggregating on map values
>
> Hey Nakul!
>
> It's not clear which version you are usin
kul Khanna (BLOOMBERG/
LONDON ) , user@hive.apache.org
Cc: Jacky Lee (BLOOMBERG/ PRINCETON ) , He Chen (BLOOMBERG/ PRINCETON ) ,
Peter Babinski (BLOOMBERG/ PRINCETON ) , Bernat Gabor (BLOOMBERG/ LONDON ) ,
Shashank Singh (BLOOMBERG/ PRINCETON )
Subject: Re: Issues with aggregating on map v
Hey Nakul!
It's not clear which version you are using;
I've checked this issue on apache/master and the 3.1.2 release - and both of
them returned accurate results.
You could execute: 'select version()' ; or run 'hive --version' in a commandline
cheers,
Zoltan
On 2/11/20 11:38 AM, Nakul Khanna
Creating the table
CREATE TABLE foo
(tags MAP, size int);
INSERT INTO foo VALUES
(map("country", "USA"), 10),
(map("country", "USA"), 20),
(map("country", "UK"), 30);
SELECT * FROM foo
++---+
| foo.tags | foo.size |
++---
