Full outer join


#1

I tested a FULL OUTER JOIN on mapdql. I suspected it would not work since it is not mentioned on the documentation.

I then got

Exception: Join type (full) not supported

Is there a work-around query I ca do to accomplish this query type on MapD ?

Is adding a FULL OUTER JOIN on the road map ? and if so when ?


#2

Hi @jfvillal - currently we dont support full outer joins. While this is possible, our focus as a columnar GPU-based analytics engine means that this type of query (where you have to materialize a potentially large set of unaggregated data) would make it much slower than acceptable for omnisci (i.e we typically run large cardinality joins on the order of milliseconds). We are looking to add support for UNION ALL shortly which may help in certain cases.