It's possible that local indexes could be allowed for atomic upserts, but
global indexes are problematic (in that under load your cluster would
probably die). The reason is that there'd be a cross RS call made for each
row being atomically upserted. If the call hangs due to the RS hosting the
data
The Apache Phoenix team is pleased to announce the immediate availability
of the 4.14.0 release. Apache Phoenix enables SQL-based OLTP and
operational analytics for Apache Hadoop using Apache HBase as its backing
store and providing integration with other projects in the Apache ecosystem
such as
I've gotten started with Apache Phoenix by creating some tables and running
some queries. Mostly, I've noticed that Phoenix will uppercase the column
names. However, I have one table with lowercase column names; it is named
'shapes':
[image: image.png]
I am able to run select * queries against