Modifying SQL Parser?


Hi There,

I noticed that Mapd is not supporting SQL-89 style JOIN (or implicit JOIN) like:
'select * from user as a, db as b, host as c where a.User = b.User and b.User = c.Host;'
But it seems not to be a problem for any other DBs, can I know the reason? And if possible, which part of code can I modify to let this kind of SQL work?




We do actually support the implicit join.

What error do you see when executing your query?



With this syntax the join would be performed with this plan

Two Cartesian products and a filtering phase.

If you want hash joins you have to rewrite the query with sql99 explicit join