[jira] [Comment Edited] (PHOENIX-5451) Column pruning for Subselect

["chenglei (Jira)" <ji...@apache.org>]

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

chenglei edited comment on PHOENIX-5451 at 9/5/19 7:54 AM:
-----------------------------------------------------------

[~tdsilva]，thank you very much  for the review.
Added more comments and uploaded v2 patch.
Pushed to 4.x-HBase-1.3, 4.x-HBase-1.4, 4.x-HBase-1.5 and master.


was (Author: comnetwork):
[~twdsilva@gmail.com]，thank you very much  for the review.
Added more comments and uploaded v2 patch.
Pushed to 4.x-HBase-1.3, 4.x-HBase-1.4, 4.x-HBase-1.5 and master.

> Column pruning for Subselect
> ----------------------------
>
>                 Key: PHOENIX-5451
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5451
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.14.2
>            Reporter: chenglei
>            Assignee: chenglei
>            Priority: Major
>             Fix For: 4.15.0, 5.1.0
>
>         Attachments: PHOENIX-5451_v1-4.x-HBase-1.4.patch, PHOENIX-5451_v2-4.x-HBase-1.4.patch
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Phoenix has already could prune column for single flat table query, but for subselect in subquery or join, column pruning is not implemented.
> Consider following join sql :
> {code:java}
> select  a.aid,b.bid from 
>  (select aid,age from table1 where age >=11 and age<=33 order by age limit 3) a inner join 
>  (select bid,code from table2 order by code limit 1) b on a.aid=b.bid 
>  {code}
> for LHS, {{table1.age}} is not referenced by outer join, and for RHS, {{table2.code}} is also not referenced by outer join,  {{table1.age}} and {{table2.code}} could both be pruned when executing query for LHS and RHS, but now Phoenix does not prune them.
> Another example is subquery sql:
> {code:java}
> SELECT t.eid id,  t.bstr b FROM 
> (SELECT entity_id eid, a_string astr, b_string bstr  FROM table  WHERE a_byte + 1 < 9 limit 2)  t ORDER BY b,id
> {code}
> for inner subselect sql, {{a_string}} is never used by outer sql, so {{a_string}} could be pruned when executing query for inner subselect, but now Phoenix does not prune it.
> Some existing test cases could be optimized by this patch.



--
This message was sent by Atlassian Jira
(v8.3.2#803003)