Hi folks, In a case where the lookup join returns null values for some rows, how can we filter out the null? I am trying something like:

select lookup('tableB', 'username', 'orgId', orgId, 'userId', userId) as username  from tableA where username is not null limit 10

But I see an error with

Unsupported predicate type: IS_NOT_NULL

Full Error screenshot attached