Forum: Building VoltDB Clients

Post: VoltDB could support Left Outer join or Right Outer join ?

VoltDB could support Left Outer join or Right Outer join ?
wcpy
May 13, 2013
I 'm try query data from 2 table and use left outer join. but result is wrong.
example table :
Table A has 2 field (id,order)
Table B has 2 field(order,name)

Exemple data :
Table A id order
1 1
2 2
3 null

Table B order name
1 test1
2 test2

SQL Statement Query : Select TableA.id,TableA.order,TableB.name from TableA left outer join TableB on TableA.order = TableB.order

I want to result 3 row as
id order name
1 1 test1
2 2 test2
3 null null

but it return result 2 row as
id order name
1 1 test1
2 2 test2


Please tell me, I'm do anything to wrong or it is Correct.
pmartel
May 24, 2013
Left and right outer join support are newly available in a limited form in VoltDB release 3.3.
The current limitation is that outer joins are limited to queries joining two tables.
General multi-table inner joins continue to be supported, and general multi-table support for outer joins is currently in development (yet with no announced release date).
I'll post future developments here.

Some recent VoltDB releases prior to release 3.3 contained a regression to the error detection code that had formerly rejected outer joins with an explicit error message.
We apologize for any confusion this may have caused.

Release 3.3 also has restored this error detection so that unsupported outer join cases will be flagged as an error when the query is planned, if it can not be supported.
This currently includes outer joins of more than two tables.
It also includes a case in which table partitioning prevents a reasonable "partitioning out" of the query's join processing, a case that would require unacceptable rematerialization of un-filtered bulk data to one server execution site.