Re: Atomic UPSERT on indexed tables

2018-06-11 Thread James Taylor
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

[ANNOUNCE] Apache Phoenix 4.14 released

2018-06-11 Thread James Taylor
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

Columns casing in Phoenix tables

2018-06-11 Thread Ali Anwar
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