[jira] [Commented] (HIVE-10875) Select query with view in subquery adds underlying table as direct input

2016-07-12 Thread niklaus xiao (JIRA) 

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

niklaus xiao commented on HIVE-10875:
-

Seems this query has the same issue
{code}
select * from V union all select * from V;
{/code}

[~thejas] Can you take a look?

> Select query with view in subquery adds underlying table as direct input
> 
>
> Key: HIVE-10875
> URL: https://issues.apache.org/jira/browse/HIVE-10875
> Project: Hive
>  Issue Type: Bug
>Reporter: Thejas M Nair
>Assignee: Thejas M Nair
> Fix For: 1.2.1
>
> Attachments: HIVE-10875.1.patch, HIVE-10875.2.patch
>
>
> In the following case, 
> {code}
> create view V as select * from T;
> select * from (select * from V) A;
> {code}
> The semantic analyzer inputs contain input table T as a direct input instead 
> of adding it as an indirect input.



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

[jira] [Commented] (HIVE-10875) Select query with view in subquery adds underlying table as direct input

2015-06-01 Thread Thejas M Nair (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-10875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14567644#comment-14567644
 ] 

Thejas M Nair commented on HIVE-10875:
--

Thanks for the review [~ashutoshc]!
Patch committed to master and branch-1.2


 Select query with view in subquery adds underlying table as direct input
 

 Key: HIVE-10875
 URL: https://issues.apache.org/jira/browse/HIVE-10875
 Project: Hive
  Issue Type: Bug
Reporter: Thejas M Nair
Assignee: Thejas M Nair
 Fix For: 1.2.1

 Attachments: HIVE-10875.1.patch, HIVE-10875.2.patch


 In the following case, 
 {code}
 create view V as select * from T;
 select * from (select * from V) A;
 {code}
 The semantic analyzer inputs contain input table T as a direct input instead 
 of adding it as an indirect input.



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

[jira] [Commented] (HIVE-10875) Select query with view in subquery adds underlying table as direct input

2015-06-01 Thread Prasad Mujumdar (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-10875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14568199#comment-14568199
 ] 

Prasad Mujumdar commented on HIVE-10875:


[~thejas] Thanks for catching the issue and patch. Looks fine to me.

 Select query with view in subquery adds underlying table as direct input
 

 Key: HIVE-10875
 URL: https://issues.apache.org/jira/browse/HIVE-10875
 Project: Hive
  Issue Type: Bug
Reporter: Thejas M Nair
Assignee: Thejas M Nair
 Fix For: 1.2.1

 Attachments: HIVE-10875.1.patch, HIVE-10875.2.patch


 In the following case, 
 {code}
 create view V as select * from T;
 select * from (select * from V) A;
 {code}
 The semantic analyzer inputs contain input table T as a direct input instead 
 of adding it as an indirect input.



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

[jira] [Commented] (HIVE-10875) Select query with view in subquery adds underlying table as direct input

2015-05-31 Thread Thejas M Nair (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-10875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1450#comment-1450
 ] 

Thejas M Nair commented on HIVE-10875:
--

This results in SQLStdauthorization (and the HiveAuthorizerAPI) consider the 
input table T as an input on which user needs access.

The problem is that in such queries, the PlanUtils.getParentViewInfo does not 
find the input view. Fixing this would also benefit other optimization code 
which tries to find input view for a table.

cc [~ashutoshc] [~prasadm] 


 Select query with view in subquery adds underlying table as direct input
 

 Key: HIVE-10875
 URL: https://issues.apache.org/jira/browse/HIVE-10875
 Project: Hive
  Issue Type: Bug
Reporter: Thejas M Nair
Assignee: Thejas M Nair

 In the following case, 
 {code}
 create view V as select * from T;
 select * from (select * from V) A;
 {code}
 The semantic analyzer inputs contain input table T as a direct input instead 
 of adding it as an indirect input.



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

[jira] [Commented] (HIVE-10875) Select query with view in subquery adds underlying table as direct input

2015-05-31 Thread Ashutosh Chauhan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-10875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14566914#comment-14566914
 ] 

Ashutosh Chauhan commented on HIVE-10875:
-

+1 LGTM

 Select query with view in subquery adds underlying table as direct input
 

 Key: HIVE-10875
 URL: https://issues.apache.org/jira/browse/HIVE-10875
 Project: Hive
  Issue Type: Bug
Reporter: Thejas M Nair
Assignee: Thejas M Nair
 Attachments: HIVE-10875.1.patch, HIVE-10875.2.patch


 In the following case, 
 {code}
 create view V as select * from T;
 select * from (select * from V) A;
 {code}
 The semantic analyzer inputs contain input table T as a direct input instead 
 of adding it as an indirect input.



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