Hi I have a dataset in parquet format with pretty big text field.
If I understand correctly these two query should bring same result
SELECT Distinct filed1 FROM table WHERE text like ‘%sometext%’ - 1 row
SELECT Distinct filed1 FROM table WHERE ilike(text, ‘%sometext%’) - 28 rows
More over when I run aggregated query with like in the where clause I can get complitelly wrong result.