Issues with aggregating on map values

2020-02-11 Thread Nakul Khanna (BLOOMBERG/ LONDON)
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 | ++---

Re: Issues with aggregating on map values

2020-02-12 Thread Nakul Khanna (BLOOMBERG/ LONDON)
Hey Zoltan, Thanks for the response. When I call "select version()" I get: 3.1.0.3.1.4.0-315 re8d79f440455fa4400daf79974666b3055f1730f So a couple of patch versions old - any idea if this was a known bug before? Regards, Nakul From: user@hive.apache.org At: 02/12/20 12:31:33To: Na