Any insight here..?
On Fri, Mar 16, 2018 at 7:23 PM, Flavio Pompermaier
wrote:
> Thanks everybody for the help.
> I'm just curios to understand why the first query didn't complete. The
> query is quite complex but the available memory should be more than enough.
>
> MYTABLE has 222,547,674 rows.
Jay,
I'm not sure what lead your infrastructure team to come to this
conclusion. My only guess is that they have observed some now-stale
documentation. PQS is supported and has plenty of information available,
both via the Apache Phoenix website and the Apache Avatica website.
https://phoeni
Hello
have the following query
select *
from lhs left join rhs on lhs.id = rhs.parent.id
where lhs.user_id = 123;
there is global index on lhs.user_id and there is global index on
rhs.parent.id.
condition by lhs.user_id is very selective so I would like the following
execution plan:
filter table L