AWS EMR Spark Integration

Hi, Has anyone successfully integrated Phoenix with Spark on Amazon EMR? I'm using EMR release version emr-5.5.0, which is phoenix 4.9.0 and spark 2.1.0. This is causing me issues when I try to run the below in a zeppelin notebook (from here):

Array data types

We are getting a “Remote driver error: UnsupportedOperationException: Currently not supported” error when querying an hbase table in an EMR 5.4 cluster using the phoenix-4.9.0-HBase-1.2-thin-client.jar. The error occurs when doing a select on a table that has one or more columns with Array data

Mujtaba Chohan has shared a document on Google Docs with you

Mujtaba Chohan has invited you to view the following document: Open in Docs

ORDER BY not working with UNION ALL

I get "Undefined column family. familyName=f" whenever I run the following query,it works without the ORDER BY and works with the ORDER BY if its not a union and just one select statement SELECT p.name FROM person p JOIN friends f

Re: Fwd: Apache Phoenix

I'll not recommend keeping two similar system(Kafka and kinesis) back to back, as it will be a waste of servers. If you are worried about network connectivity for Kinesis then you should also worry about Kafka going down because of corrupted partitions or anything, It's better to have some

Cant stop queryserver

When I run "$PHOENIX_HOME/bin/bin/queryserver.py stop" I get "no Query Server to stop because PID file not found, /tmp/phoenix/root-queryserver.pid" Regards, Cheyenne O. Forbes