search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

'Like' and comparisons don't work with Joins #685

Open rtvt123 opened 10 years ago

rtvt123 commented 10 years ago

looks like only equality clauses are supported (ON a.column=b.column), but not something like this:

SELECT * FROM TABLE a JOIN TABLE b ON b.column LIKE '%'+ a.column +'%'

or

SELECT * FROM TABLE a JOIN TABLE b ON b.column >a.column

jtaylor-sfdc commented 10 years ago

@alexdl - that's a known limitation. Do you have a use case that requires this?

@maryannxue - would you mind writing up a one-pager on hash joins highlighting known limitations? Please work with @mujtabachohan on this, as we'd want to put this on our Apache website (http://phoenix.incubator.apache.org/). You should have all the perms you need.

maryannxue commented 10 years ago

@jtaylor-sfdc Ok, no problem.