Support Questions
Find answers, ask questions, and share your expertise
Announcements
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

Highlighted

Phoenix query on multiple index values

New Contributor

Hi,

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?

1 REPLY 1

Re: Phoenix query on multiple index values

Super Collaborator

Hi,

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).

Regards
Harald