About navendugarg

navendugarg · ‎02-15-2017

I've tried it on SQL Workbench and Aginity Workbench, and I get errors on both clients. Column is a varchar(9). Here is what I discovered. A table with column names that have spaces (e.g. `account year`), this feature fails. When I added an underscore to the column (account_year), the masking started to work.

navendugarg · ‎02-10-2017

I am logged-in as a user that is in the "select user". So yes, this user has permissions to run the query.

navendugarg · ‎02-09-2017

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. Unfortunately, when I execute the following query in a hive client: select * from <tablename> limit 100; I get the following error: [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()}? If I disable the above policy, the query runs successfully.

Online	Offline
Last Visited	‎05-15-2017 01:29 AM

Member Since	‎02-09-2017 02:15 AM
Last Visited	‎05-15-2017 01:29 AM
Posts	4
Kudos received	1

Cloudera Community

Re: Querying a Hive Table (via Hiveserver2) with C...

Re: Querying a Hive Table (via Hiveserver2) with C...

Querying a Hive Table (via Hiveserver2) with Colum...