Why NOT LIKE condition not works dremio query?

1

Hi ,
I used below query I’m getting error “Unexpected Error Occured”.

SELECT title, ROUND(“title Count”,2) AS “title Count” FROM (SELECT CAST(title AS VARCHAR) AS title,COUNT(CAST(title AS VARCHAR)) AS “title Count” FROM (select * from “60a5feaf776116f1b2440458_5c592f6716209a24f4125001”.“60a5feb0776116f1b244045a”)
WHERE ( title NOT LIKE ‘%a%’ ) GROUP BY title ORDER BY “title Count” DESC )

Here I used NOT LIKE condition but not works can anyone help me to solve this issue.

2

@Arun Can you please provide the profile for the failed job