Created 03-25-2017 05:41 PM
Created 03-26-2017 03:48 AM
Please check below links are help full
1) Explain plan Jira:- https://issues.apache.org/jira/browse/PHOENIX-2702
2) FAQ for Phoenix :- https://phoenix.apache.org/faq.html
Created 03-28-2017 01:54 PM
+---------------------------------------------------------------------------------------------+ | PLAN | +---------------------------------------------------------------------------------------------+ | CLIENT 32-CHUNK PARALLEL 32-WAY ROUND ROBIN RANGE SCAN OVER SCHEMA:TABLE [1,'PREDICATE'] | | SERVER FILTER BY FIRST KEY ONLY | +---------------------------------------------------------------------------------------------+
3. It seems "CHUNK" goes together with salt bucket as well. Please correct me if I am wrong.
Created 04-02-2017 11:52 AM
https://phoenix.apache.org/tuning_guide.html
Currently with explain plan ,there is no way to determine that all your regionservers are getting used for the query , although if there is full table scan ,then all the regions will be scanned but still you can't be sure that all regionservers are getting used as it depends upon your balancer policy and the distribution can be checked from master UI.
https://phoenix.apache.org/tuning_guide.html
it depends , for eg:- if you are applying hour(ts) where 'ts' is the first part of the primary key and you don't have functional index on it, then the query may be turned into full table scan where the impact range could be anything.
although, processing time of evaluating the function on the column value depends upon the function complexity and no. of rows you are scanning.