phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Randy Gelhausen (JIRA)" <>
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
             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 =

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

View raw message