Re: JOIN on map value results to HiveException: Unexpected column vector type MAP

2019-01-29 Thread Jan Adona
e map data type. So, after setting atleast one of these configurations to "false", the cross product query successfully runs. Of course, there might be some performance loss since we're turning off the vectorization and Map Join. Regards, Jan Charles On Thu, Jan 17, 2019 at 1:57 PM

Re: JOIN on map value results to HiveException: Unexpected column vector type MAP

2019-01-16 Thread Jan Adona
.init(MapRecordProcessor.java:335) ... 17 more Also, I'm running this query on an HDP 3.0.1 cluster with Apache Hive 3.1.0. Thanks, Jan Charles On Wed, Jan 16, 2019 at 7:46 PM Jan Adona wrote: > Hi, > I'm trying out a JOIN query on 2 tables using a map value (which is a >

JOIN on map value results to HiveException: Unexpected column vector type MAP

2019-01-16 Thread Jan Adona
Hi, I'm trying out a JOIN query on 2 tables using a map value (which is a BIGINT) on the 1st table and a BIGINT column on the 2nd table. So here is the schema: *CREATE TABLE test_table0(userid BIGINT, mapCol map)* *COMMENT 'Test table 0'* *STORED AS SEQUENCEFILE;* *CREATE TABLE test_table1(userid