Modifying SQL Parser?


#1

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?

Thanks!


#2

Hi,

We do actually support the implicit join.

What error do you see when executing your query?

regards


#3

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