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 !