How to use LIKE as in the following example?

Hi community,

How can I do the following query in dremio?

SELECT * FROM table1,table2 WHERE table1.x LIKE table2.y + '%'

The LIKE operator only works if I compare with a string. But I want to do a LIKE between two columns and always I get an error.

Is there a way to do it or does dremio not support this type of queries?

Thanks for help !

@panyu1512 In which database/tool does this query run? can you please provide the full query from that tool?