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)
