Reply
New Contributor
Posts: 2
Registered: ‎09-18-2018

Slow query on one Secondary Index and fast on other

[ Edited ]

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?

Announcements

Currently incubating in Cloudera Labs:

Envelope
HTrace
Ibis
Impyla
Livy
Oryx
Phoenix
Spark Runner for Beam SDK
Time Series for Spark
YCSB