Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenix query on multiple index values

Phoenix query on multiple index values

New Contributor


I am new to Phoenix and would like to know the following execution for the query:

Let’s say I. Have a table with columns as A,B , C. Now I have A to be primary key . I create a global secondary index on B. What is the execution of the following:

Select A,B from table where B=x. OR B=y Or B=z ; Will it result in index scan or full table scan?


Re: Phoenix query on multiple index values

Super Collaborator


can't guarantee this, but the global index in Phoenix is as per documentation for 'heavy read' usage. So if this should make sense, your query should result in using the secondary index (of course only when using Phoenix).


Don't have an account?
Coming from Hortonworks? Activate your account here