Re: Difference between join and inner join

2017-02-13 Thread Mich Talebzadeh
ere is nothing specific to point as a difference between Join and > Inner Join in Hadoop. > Hope it helps. > > Thanks, > Balajee Venkatesh > > > On 12-Feb-2017 9:32 am, "Divya Gehlot" wrote: > > Hi , > What's the difference between" join " and "inner join" in hive ? > > Thanks , > Divya > > >

Re: Difference between join and inner join

2017-02-11 Thread balajee venkatesh
Hi Divya, If you don't specify the Join type then by default it performs Inner Join on the tuples under action. So, there is nothing specific to point as a difference between Join and Inner Join in Hadoop. Hope it helps. Thanks, Balajee Venkatesh On 12-Feb-2017 9:32 am, "Divya Gehl

Re: Difference between join and inner join

2017-02-11 Thread Devopam Mittra
+1 to this question. I will appreciate if someone can shed light on behind the scenes for this one. Might give us ideas for best practice. Regards Devopam On 11 Feb 2017 8:02 pm, "Divya Gehlot" wrote: > Hi , > What's the difference between" join " and &q

Re: Difference between join and inner join

2017-02-11 Thread hadoop hive
They are functionally equivalent, but INNER JOIN can be a bit clearer to read, especially if the query has other join types (i.e. LEFT or RIGHT or CROSS) included in it. Regards Vikas Srivastava On 12 Feb 2017, 12:02 PM +0800, Divya Gehlot , wrote: > Hi , > What's the difference be

Difference between join and inner join

2017-02-11 Thread Divya Gehlot
Hi , What's the difference between" join " and "inner join" in hive ? Thanks , Divya