Re: INSERT OVERWRITE partition while SELECT is going on

Actually, hive.support.concurrency is false by default so you should set it to true for locking. -- Lefty On Fri, Apr 3, 2015 at 4:52 PM, Lefty Leverenz wrote: > I'm no e

Re: Is it possible to do a LEFT JOIN LATERAL in Hive?

Lateral view does support outer if that helps. On Sunday, April 5, 2015, @Sanjiv Singh wrote: > Hi Jeremy, > > Adding to my response > > 1. Hive doesn't support named insertion , so need to use other ways of > insertion data in hive table .. > > 2. As you know , hive doesn't support LEFT J

How efficient is memory allocation in tez.

My tez query seems to error out. I have a map join in which the smaller tables together are 200 MB and trying to have one block of main table be processed by one tez task. Using the following formula to calculate the tez container size Small table size + each block size + memory for sort + some

Re: Is it possible to do a LEFT JOIN LATERAL in Hive?

Hi Jeremy, Adding to my response 1. Hive doesn't support named insertion , so need to use other ways of insertion data in hive table .. 2. As you know , hive doesn't support LEFT JOIN LATERAL. Query , I given , is producing same result . hope that it can help you formulate things and achi

Re: Is it possible to do a LEFT JOIN LATERAL in Hive?

-- create table lhs create table lhs ( subject_id int, date_time BIGINT ); -- insert some records in table lhs , named insertion will not work in case of hive insert into table lhs select 1,1000 from tmpTableWithOneRecords limit 1; insert into table lhs select 1,1100 from tmpTableWi