Hive2 Interactive LLAP fails to start

2019-01-16 Thread Abhishek Gupta
I have been trying to start Hive2 Interactive on HDP 2.6.5 that ships with Hive 2.1.0. I have followed the guidelines mentioned in the following articles about how to size and tune LLAP with Yarn https://community.hortonworks.com/articles/149486/llap-sizing-and-setup.html But LLAP daemon fails to

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

2019-01-16 Thread Jan Adona
Hi, Just a follow up, I think that JOIN is not the problem here since this error also occurs when I am querying 2 tables even without a join and you include the map column in the select statement. I'm going to rewrite the schema and queries that I've sent before because I mistakenly formatted the

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