I stumbled on this post:
https://medium.com/@vkrava4/fighting-with-apache-phoenix-secondary-indexes-163495bcb361 and the bug: https://issues.apache.org/jira/browse/PHOENIX-5287 I had a similar very frustrating experience with Phoenix, In addition to various performance issues, you can found one of my posts about the reliability issue on the mail-list. https://lists.apache.org/thread.html/231b175fce8811d474cceb1fe270a3dd6b30c9eff2150ac42ddef0dc@%3Cuser.phoenix.apache.org%3E just wondering others experience if you could share