You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Divya Gehlot <di...@gmail.com> on 2017/02/12 04:02:37 UTC

Difference between join and inner join

Hi ,
What's the difference between" join " and "inner join" in hive ?

Thanks ,
Divya

Re: Difference between join and inner join

Posted by hadoop hive <ha...@gmail.com>.

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 <di...@gmail.com>, wrote:
> Hi ,
> What's the difference between" join " and "inner join" in hive ?
>
> Thanks ,
> Divya
>

Re: Difference between join and inner join

Posted by Devopam Mittra <de...@gmail.com>.

+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" <di...@gmail.com> wrote:

> Hi ,
> What's the difference between" join " and "inner join" in hive ?
>
> Thanks ,
> Divya
>
>

Re: Difference between join and inner join

Posted by Mich Talebzadeh <mi...@gmail.com>.

join is by default inner join as in Oracle or Sybase.

HTH

Dr Mich Talebzadeh

LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*

http://talebzadehmich.wordpress.com

*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.

On 12 February 2017 at 04:13, balajee venkatesh <
balajee.venkatesh1667@gmail.com> wrote:

> 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 Gehlot" <di...@gmail.com> wrote:
>
> Hi ,
> What's the difference between" join " and "inner join" in hive ?
>
> Thanks ,
> Divya
>
>
>

Re: Difference between join and inner join

Posted by balajee venkatesh <ba...@gmail.com>.

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 Gehlot" <di...@gmail.com> wrote:

Hi ,
What's the difference between" join " and "inner join" in hive ?

Thanks ,
Divya