after the upgrade to 3.1.2 version of the product, i cant join anymore a table more than once.
select count(*) from flights f join airports a on f.dest=a.iata join airports b f.origin=b.iata
returns this exception
Exception: Hash join failed, reason: A hash table is already built for the table of this column
on 3.1.1 the same query worked.
as a workaround i created a view (create view as select * from v_airports) and i rewrote the query using the view for the second join
select count(*) from flights f join airports a on f.dest=a.iata join v_airports b f.origin=b.iata;
if i try to use the view twice in the query i get this exception
Exception: Query couldn’t keep the entire working set of columns in GPU memory