You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Niklaus Xiao (JIRA)" <ji...@apache.org> on 2017/02/06 02:00:44 UTC
[jira] [Commented] (HIVE-15666) Select query with view adds base
table partition as direct input in spark engine
[ 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)