NOT LIKE keyword Error

1

My Source type is MongoDB.
When I was used NOT LIKE keyword in Dremio sql editor it’s throwing below error
MongoQueryException: Query failed with error code 2 and error message ‘unknown top level operator: $not’ on server 127.0.0.1:27017
MY Query : SELECT * FROM sales WHERE customer NOT LIKE (%john%)

2

Hello @Dineshlkumar

Can we get the query profile.

Thanks,
@Rakesh_Malugu