Randy Gelhausen created PHOENIX-3234:
----------------------------------------

             Summary: Support selects from parameterized views
                 Key: PHOENIX-3234
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3234
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Randy Gelhausen


If views are made to support subqueries, there will be

Considering the view definition:
create view leads as
select * from leads
join (
  select id from newlead where indexedCol1 = 'a', indexedCol2 = 'b', etc.
) a
where leads.id = a.id

A natural next attempt will be to:
select * from leads_view where indexedCol1 = 1 and indexedCol2 = 2;

It would be very useful to support pushing view predicates down to the view 
definition dynamically, instead of forcing hardcoded values.



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

Reply via email to