Hi Mike, Yes, this is a known missing feature in Apache Avatica, the tech behind the thin client/query server. I've recently committed the implementation in Avatica, we just need to cut a new release upstream and also here in Phoenix.
The workaround is to use the thick client or avoid the use of arrays with the thin client at present. On May 3, 2017 13:07, "Mike Prendergast" <mikeprenderg...@iotait.com> wrote: 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 type. When I remove the Array columns from the select clause, the query runs without error. I did some research on this problem and it seems to be a bug documented in issues.apache.org/jira/browse/CALCITE-1050. We would like to know if this behavior was reported to you before, and if so, what is your recommended workaround or solution. Thanks for looking at this Michael Prendergast *iota IT* Vice President / Software Engineer (cell) 703.594.1053 <(703)%20594-1053> (office) 571.386.4682 <(571)%20386-4682> (fax) 571.386.4681 <(571)%20386-4681> This e-mail and any attachments to it are intended only for the identified recipient(s). It may contain proprietary or otherwise legally protected information of Iota IT, Inc. Any unauthorized distribution, use or disclosure of this communication is strictly prohibited. If you have received this communication in error, please notify the sender and delete or otherwise destroy the e-mail and all attachments immediately.
