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: Nakul Khanna

Re: Issues with aggregating on map values

2020-02-12 Thread Zoltan Haindrich
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

Error communicating with the metastore | org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset

2020-02-12 Thread Bernard Quizon
Hi, everyone. We're getting this error on Hive 3.1.0: org.apache.hadoop.hive.ql.lockmgr.LockException: Error communicating with the metastore at org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.getValidWriteIds(DbTxnManager.java:714) at org.apache.hadoop.hive.ql.Driver.recordValidWriteIds(Driver.ja