[ https://issues.apache.org/jira/browse/HIVE-15666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15853435#comment-15853435 ]
Niklaus Xiao commented on HIVE-15666: ------------------------------------- [~aihuaxu] this is my test result with the latest version, 2.2.0-SNAPSHOT: MR + CBO on -> issue exists MR + CBO off -> issue doesnot exists Spark + CBO on -> issue exists > Select query with view adds base table partition as direct input in spark > engine > -------------------------------------------------------------------------------- > > Key: HIVE-15666 > URL: https://issues.apache.org/jira/browse/HIVE-15666 > Project: Hive > Issue Type: Bug > Components: Authorization > Affects Versions: 1.3.0 > Reporter: Niklaus Xiao > Assignee: Aihua Xu > Attachments: TestViewEntityInSparkEngine.patch > > > repro steps: > {code} > set hive.execution.engine=spark; > create table base(id int) partitioned by (dt string); > alter table base add partition(dt='2017'); > create view view1 as select * from base where id < 10; > select * from view1; > {code} > it requires the access not only for view1 but also for base@dt=2017 > partition, which should not be required. -- This message was sent by Atlassian JIRA (v6.3.15#6346)