phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Toal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2106) Support correlated-subquery conditions
Date Fri, 10 Jul 2015 06:41:04 GMT
Brian Toal created PHOENIX-2106:
-----------------------------------

             Summary: Support correlated-subquery conditions
                 Key: PHOENIX-2106
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2106
             Project: Phoenix
          Issue Type: New Feature
            Reporter: Brian Toal
            Priority: Minor


Would be nice to see support for support correlated-subquery conditions.

One way to find the max/min value of a partition of rows in a table is to do a self join via
EXIST clause with a predicate that is used to single out the max/min combination.

Would be nice to see this behavior supported.  When I attempt to run similar queries, execution
fails, saying correlated-subquery conditions not supported.


-- select
--   t.cnt,
--   s.id,
--   f.package,
--   f.class,
--   f.method
-- from 
--   profiler.stack s,
--   profiler.frame f
-- where
--   s.frame_id = f.id and
--   exists (
--     select
--       1
--     from
--       profiler.stack si
--     where 
--       si.id = s.id and
--       si.pos >= s.pos
--   );



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

Mime
View raw message