IllegalArgumentException: The argument 'pattern' of Function 'like' has to be constant!

1

Hello everybody

I am trying to run the next query:

SELECT
nested_0.name,
nested_0.address,
join_country.name AS name1,
join_country.names
FROM (
SELECT name, address
FROM DataBase
) nested_0
INNER JOIN country AS join_country
ON (nested_0.name LIKE CONCAT(’%’,join_country.names[0], ‘%’) )

Somebody have had the same issue?

There is a way to sove it?

2

Hi @hatshex,

how did you resolve your issue?
I’m having the same issue when using LIKE within JOIN.

regards

3

@Muffex

Please send the Dremio query profile

Thanks
Bali