phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Randy Gelhausen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3234) Support selects from parameterized views
Date Wed, 31 Aug 2016 20:56:20 GMT
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)

Mime
View raw message