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

Posted to user@ignite.apache.org by DS <de...@aline-consulting.com> on 2019/10/24 11:03:19 UTC

Does ignite support FULL OUTER JOIN ?

I am giving the syntax as :

SELECT * FROM person  Outer join  city ON person.city_id = city.city_id 

Same query works well with inner ,left ,right join . 
Please correct me if i am doing something wrong.

P.S. 
Both tables have index over city_id column



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Does ignite support FULL OUTER JOIN ?

Posted by Ivan Pavlukhin <vo...@gmail.com>.

Hi,

FULL OUTER JOIN  is not supported as it is not supported in H2 [1]
(Ignite uses H2 internally for query processing).

[1] https://github.com/h2database/h2database/issues/457

чт, 24 окт. 2019 г. в 14:03, DS <de...@aline-consulting.com>:
>
> I am giving the syntax as :
>
> SELECT * FROM person  Outer join  city ON person.city_id = city.city_id
>
> Same query works well with inner ,left ,right join .
> Please correct me if i am doing something wrong.
>
> P.S.
> Both tables have index over city_id column
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/



-- 
Best regards,
Ivan Pavlukhin