https://community.cloudera.com/t5/Support-Questions/Querying-a-Hive-Table-via-Hiveserver2-with-Column-Masking/m-p/167260#M129592 <P>I am running a HDP 2.5.3 cluster with HiveServer2 enabled on an edge node. Ranger is enforcing security. In addition, I've created a policy in ranger that redacts a certain column with pii on select.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="12247-y2sye.png" style="width: 1920px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/20306i4E8375CD11BEF6CC/image-size/medium?v=v2&amp;px=400" role="button" title="12247-y2sye.png" alt="12247-y2sye.png" /></span></P><P>Unfortunately, when I execute the following query in a hive client:</P><P>select * from &lt;tablename&gt; limit 100;</P><P>I get the following error:</P><P><STRONG>[42000]: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.ParseException: line 1:62 rule Identifier failed predicate: {allowQuotedId()}? line 1:74 rule Identifier failed predicate: {allowQuotedId()}? line 1:94 rule Identifier failed predicate: {allowQuotedId()}? line 1:117 rule Identifier failed predicate: {allowQuotedId()}?</STRONG></P><P>If I disable the above policy, the query runs successfully. </P> Sun, 18 Aug 2019 11:09:47 GMT navendugarg 2019-08-18T11:09:47Z