[ 
https://issues.apache.org/jira/browse/HIVE-14158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15370254#comment-15370254
 ] 

Pengcheng Xiong commented on HIVE-14158:
----------------------------------------

[~ashutoshc] and [~hagleitn]. The previous patch 03 does not work for (1) 
enforced view column names and (2) existing view column authorization 
mechanism. Thus I worked out patch 04. It will solve both the view auto 
generated column alias problem and the virtual column problem. The design is 
that (1) give a different auto generated column alias. (to solve the view  auto 
generated column alias problem) and (2) add the virtual columns for masking 
tables and unparse translate the "*". It seems that the price is that we have 
to go through genOp twice, i.e., the first time, unparse the "select *", the 
second time, add all the virtual columns. See the below query
{code}
select * from maskTable
{code}
If we only go through genOp once, then it will be rewritten to 
{code}
select * from (select key, mask(value) as value, ROW__ID... etc )maskTable
{code}
It will change the RR of the maskTable to the outside.


> deal with derived column names
> ------------------------------
>
>                 Key: HIVE-14158
>                 URL: https://issues.apache.org/jira/browse/HIVE-14158
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Security
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>             Fix For: 2.1.0
>
>         Attachments: HIVE-14158.01.patch, HIVE-14158.02.patch, 
> HIVE-14158.03.patch, HIVE-14158.04.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to