Join query on key like

Apache Druid Q&A Google Groups
#1

Does sql in druid support join query using LIKE clause?

e.g:

select *
from A
left join B on A.key like B.key || ‘%’

Thank you

#2

As of today - The condition must involve only equalities.

Look at this for more details on druid Join-

https://druid.apache.org/docs/latest/querying/datasource.html#join

Thanks and Regards,
Vaibhav

#3

But when used with literal string, e.g:

select *
from A
inner join B on A.key like ‘some string%’

It can. So i thought there’s the way to do it with column.

But again, the documentation say so, okay then.

Thanks.

Regards,
Erickson