In this above query where condition should be executed only when operationType column is present in the table. If operationType column is not present where condition is no needed. Answer Try This:
Tag: apache-drill
How can I restrict access to sensitive columns in Apache Drill view based on user permissions in another view?
Background: I have users connect to Apache Drill with Kerberos authentication to read from a Parquet file so basically a single table with multiple columns. Some of the columns in that file are known to be sensitive and only certain users can see them. Apart from the data table Drill has access to another table with information who has access