Cloudera Labs
Provide feedback on Cloudera Labs
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Slow query on one Secondary Index and fast on other

Slow query on one Secondary Index and fast on other

New Contributor

I have two salted global secondary indexes (A and B) on a table with row key (primary key) as the covered column. For both of them, the read single row latency is fine with less QPS, but as QPS increases from the client side, query on one of the indexes (A) becomes 10x slow, while the other (B) remain unaffected. Also, I have noticed that the transmitted bytes in the hbase region server increase drastically while querying on index A. Can you explain this behaviour?