Re: Issue using ANY ARRAY feature

2019-12-09 Thread Josh Elser
Hi Simon, Thanks for replying back with your fix. We appreciate when folks do this so that others can also see the solution. http://phoenix.apache.org/download.html only publishes the "latest" release for a line that we're maintaining. That's why you'll see 4.14.3 listed on the website, not

Re: Issue using ANY ARRAY feature

2019-12-08 Thread Simon Mottram
Update: Just in case anyone hits this issue in future with the AWS managed HBase, the fix is to use a very specific version of the driver For thick client: org.apache.phoenix phoenix-core 4.14.1-HBase-1.4 For thin client:

Issue using ANY ARRAY feature

2019-11-17 Thread Simon Mottram
Phoenix Version: 4.14.2-HBase-1.4 HBase Version: AWS EMR Release label:emr-5.24.1 Hadoop distribution:Amazon Applications:Phoenix 4.14.1, Hue 4.4.0, HBase 1.4.9 Having an issue where ANY(ARRAY[]) stops the query returning any results when used in a 'AND' conjunction e.g (fielda = 'a') AND (fiel