Re: Understanding Hive's execution plan

Try this, it has a chapter on hive http://hdl.handle.net/10919/5122 3 On Thursday, March 26, 2015, Daniel Haviv wrote: > Hi, > Can anyone direct me to a good explanation on understanding Hive's > execution plan? > > Thanks, > Daniel >

Re: Understanding Hive's execution plan

Hi Daniel - the below link can shed some light on it. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain --Bala G. On Thu, Mar 26, 2015 at 10:26 AM, Daniel Haviv < daniel.ha...@veracity-group.com> wrote: > Hi, > Can anyone direct me to a good explanation on understanding Hi

RE: Understanding Hive's execution plan

recipient to ensure that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Daniel Haviv [mailto:daniel.ha...@veracity-group.com] Sent: 27 March 2015 08:13 To: user@hive.apache.org Subject: Re: Understanding Hive&#

Re: Understanding Hive's execution plan

Hi Mich, For the future, please refrain from hijacking threads and ask your questions in a separate one. Thanks, Daniel > On 27 במרץ 2015, at 00:44, Mich Talebzadeh wrote: > > I am very new to hive optimiser > > Here I have a table with 4 million rows imported from Oracle via sqoop/hive. >

RE: Understanding Hive's execution plan

I am very new to hive optimiser Here I have a table with 4 million rows imported from Oracle via sqoop/hive. In this table object_id column is unique. Oracle table has primary key constraint on object_id column which is basically a unique B-tree index. I do a very simple query to see how