[
https://issues.apache.org/jira/browse/HIVE-22822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17563782#comment-17563782
]
Quanlong Huang commented on HIVE-22822:
---------------------------------------
Resolving this as it duplicates HIVE-20628.
> Column masking policies on complex column will cause unrelative query failures
> ------------------------------------------------------------------------------
>
> Key: HIVE-22822
> URL: https://issues.apache.org/jira/browse/HIVE-22822
> Project: Hive
> Issue Type: Bug
> Reporter: Quanlong Huang
> Priority: Major
>
> Create a table with complex types columns:
> {code:sql}
> CREATE TABLE customers(
> id int,
> name string,
> email_preferences
> struct<email_format:string,frequency:string,categories:struct<promos:boolean,surveys:boolean>>,
>
> addresses
> map<string,struct<street_1:string,street_2:string,city:string,state:string,zip_code:string>>,
>
> orders
> array<struct<order_id:string,order_date:string,items:array<struct<product_id:int,sku:string,name:string,price:double,qty:int>>>>
> ) stored as ORC;
> {code}
> In Ranger, add a column masking policy on the 'addresses' column to nullify
> the values. Then run "select id from customers" in Hive. Hit the error:
> {code:java}
> Error while compiling statement: FAILED: SemanticException
> org.apache.hadoop.hive.ql.parse.ParseException: line 1:101 cannot recognize
> input near 'map' '<' 'string' in primitive type specification
> {code}
> The query just reads the "id" column and the failure looks like relative to
> the masked "address" column. It should not fail.
> I use Hive3 in testing.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
