>From Hive manual, there is only "left semi join", no "semi join", nor "inner
>semi join".
>From the Database world, it is just a traditional name for this kind of join:
>"LEFT semi join", as a reminder to the reader that the resultset comes o
Hello,
We were approached to add support for Hive SQL in jOOQ [1], which might be
useful for a greater community in general. I've gone through the Hive SQL
syntax and I've encountered this interesting clause: The LEFT SEMI JOIN clause
[2]
Example:
SELECT a.key, a.val
FROM a LEFT S
>>>
>>> C4
>>>
>>> 12
>>>
>>> 3
>>>
>>> C5
>>>
>>> 1
>>>
>>> 8
>>>
>>> C6
>>>
>>>
>>>
>>> I want to formulate a table which would look like
look like (*Table 4*)
>>
>> ID_1
>>
>> ID_1_Value
>>
>> ID_2
>>
>> ID_2_value
>>
>> Other_Column1
>>
>> 1
>>
>> V11
>>
>> 3
>>
>> V13
>>
>> C1
>>
>> 2
>>
>> V12
gt;
> V12
>
> C3
>
> 4
>
> NULL / Empty
>
> 9
>
> NULL / Empty
>
> C4
>
> 12
>
> NULL / Empty
>
> 3
>
> V13
>
> C5
>
> 1
>
> V11
>
> 8
>
> NULL / Empty
>
> C6
>
>
> On Thu, Dec 27, 2012 at 9:
cely here, so thank
> you for doing that.
>
> Why don't you use INNER JOIN instead of LEFT SEMI JOIN? You can express
> the same query as INNER JOIN with no restrictions on what can be included
> in the SELECT clause. LEFT SEMI JOIN just implements an "exists" like
Souvik,
Let me begin by saying that simplifying the problem goes a long way in
helping us answer your question. You did it really nicely here, so thank
you for doing that.
Why don't you use INNER JOIN instead of LEFT SEMI JOIN? You can express the
same query as INNER JOIN with no restrictio
