Author: stoty Date: Fri Jul 16 16:01:24 2021 New Revision: 48853 Log: Apache phoenix-queryserver 6.0.0RC5
Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/ dev/phoenix/phoenix-queryserver-6.0.0RC5/CHANGES.md dev/phoenix/phoenix-queryserver-6.0.0RC5/RELEASENOTES.md dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz (with props) dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.asc dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz (with props) dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.asc dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.sha512 Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/CHANGES.md ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC5/CHANGES.md (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC5/CHANGES.md Fri Jul 16 16:01:24 2021 @@ -0,0 +1,132 @@ + +<!--- +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. +--> +# PHOENIX Changelog + +## Release queryserver-6.0.0 - Unreleased (as of 2021-07-16) + + + +### IMPORTANT ISSUES: + +| JIRA | Summary | Priority | Component | +|:---- |:---- | :--- |:---- | +| [PHOENIX-5446](https://issues.apache.org/jira/browse/PHOENIX-5446) | Support Protobuf shaded clients (thin + thick) | Major | . | + + +### NEW FEATURES: + +| JIRA | Summary | Priority | Component | +|:---- |:---- | :--- |:---- | +| [PHOENIX-5938](https://issues.apache.org/jira/browse/PHOENIX-5938) | Support impersonation in the python driver | Major | python, queryserver | +| [PHOENIX-5880](https://issues.apache.org/jira/browse/PHOENIX-5880) | Add SQLAchemy support to python driver | Major | python, queryserver | +| [PHOENIX-5642](https://issues.apache.org/jira/browse/PHOENIX-5642) | Add HTTPS support to Phoenix Query Server and thin client | Major | queryserver | + + +### IMPROVEMENTS: + +| JIRA | Summary | Priority | Component | +|:---- |:---- | :--- |:---- | +| [PHOENIX-6508](https://issues.apache.org/jira/browse/PHOENIX-6508) | add -bin suffix to queryserver binary assembly name | Trivial | queryserver | +| [PHOENIX-6488](https://issues.apache.org/jira/browse/PHOENIX-6488) | Bump Avatica version to 1.18.0 in queryserver | Major | queryserver | +| [PHOENIX-6473](https://issues.apache.org/jira/browse/PHOENIX-6473) | Add Hadoop JMXServlet as /jmx endpoint | Major | queryserver | +| [PHOENIX-6398](https://issues.apache.org/jira/browse/PHOENIX-6398) | Returns uniform SQL dialect in calcite for the PQS | Major | queryserver | +| [PHOENIX-5869](https://issues.apache.org/jira/browse/PHOENIX-5869) | Use symlinks to reduce size of phoenix queryserver assembly | Major | queryserver | +| [PHOENIX-5829](https://issues.apache.org/jira/browse/PHOENIX-5829) | Make it possible to build/test queryserver against all supported versions | Major | queryserver | +| [PHOENIX-6006](https://issues.apache.org/jira/browse/PHOENIX-6006) | Bump queryserver version to 6.0 | Major | queryserver | +| [PHOENIX-5999](https://issues.apache.org/jira/browse/PHOENIX-5999) | Have executemany leverage ExecuteBatchRequest | Major | python | +| [PHOENIX-6007](https://issues.apache.org/jira/browse/PHOENIX-6007) | PhoenixDB error handling improvements | Major | queryserver | +| [PHOENIX-5778](https://issues.apache.org/jira/browse/PHOENIX-5778) | Remove the dependency of KeyStoreTestUtil | Major | queryserver | +| [PHOENIX-5964](https://issues.apache.org/jira/browse/PHOENIX-5964) | Rename queryserver subprojects | Major | queryserver | +| [PHOENIX-5907](https://issues.apache.org/jira/browse/PHOENIX-5907) | Remove unused part from phoenix\_utils.py | Major | queryserver | +| [PHOENIX-5904](https://issues.apache.org/jira/browse/PHOENIX-5904) | Add log if the configed kerberos principal login failed | Minor | queryserver | +| [PHOENIX-5826](https://issues.apache.org/jira/browse/PHOENIX-5826) | Remove guava from queryserver | Major | queryserver | +| [PHOENIX-5844](https://issues.apache.org/jira/browse/PHOENIX-5844) | Feature parity for the python client | Major | python | +| [PHOENIX-5827](https://issues.apache.org/jira/browse/PHOENIX-5827) | Let PQS act as a maven repo | Major | queryserver | +| [PHOENIX-4112](https://issues.apache.org/jira/browse/PHOENIX-4112) | Allow JDBC url-based Kerberos credentials via sqlline-thin.py | Major | queryserver | +| [PHOENIX-5814](https://issues.apache.org/jira/browse/PHOENIX-5814) | disable trimStackTrace | Major | connectors, core, omid, queryserver, tephra | +| [PHOENIX-5777](https://issues.apache.org/jira/browse/PHOENIX-5777) | Unify the queryserver config keys to use QueryServerProperties | Major | queryserver | +| [PHOENIX-5702](https://issues.apache.org/jira/browse/PHOENIX-5702) | Add https support to sqlline-thin script | Major | queryserver | +| [PHOENIX-5454](https://issues.apache.org/jira/browse/PHOENIX-5454) | Phoenix scripts start foreground java processes as child processes | Minor | core, queryserver | +| [PHOENIX-5459](https://issues.apache.org/jira/browse/PHOENIX-5459) | Enable running the test suite with JDK11 | Major | . | +| [PHOENIX-5393](https://issues.apache.org/jira/browse/PHOENIX-5393) | Perform \_HOST principal expansion for SPENGO QueryServer principal | Blocker | queryserver | + + +### BUG FIXES: + +| JIRA | Summary | Priority | Component | +|:---- |:---- | :--- |:---- | +| [PHOENIX-6512](https://issues.apache.org/jira/browse/PHOENIX-6512) | Fix PQS Apache RAT check problems | Major | queryserver | +| [PHOENIX-6407](https://issues.apache.org/jira/browse/PHOENIX-6407) | phoenixdb for Python silently ignores placeholders \< placeholder arguments | Minor | python | +| [PHOENIX-6461](https://issues.apache.org/jira/browse/PHOENIX-6461) | sqlline-thin does not include slf4j logging backend | Major | queryserver | +| [PHOENIX-6324](https://issues.apache.org/jira/browse/PHOENIX-6324) | Queryserver IT suite incompatible with phoenix 5.1+ / 4.16+ shading | Major | queryserver | +| [PHOENIX-6489](https://issues.apache.org/jira/browse/PHOENIX-6489) | Adopt PQS ITs to use Phoenix 5.1 | Major | queryserver | +| [PHOENIX-6463](https://issues.apache.org/jira/browse/PHOENIX-6463) | PQS jar hosting doesn't include pom's | Major | queryserver | +| [PHOENIX-6414](https://issues.apache.org/jira/browse/PHOENIX-6414) | Access to Phoenix from Python using SPNEGO | Major | python, queryserver | +| [PHOENIX-6177](https://issues.apache.org/jira/browse/PHOENIX-6177) | Queryserver Avatica and Jetty versions are incompatible | Blocker | queryserver | +| [PHOENIX-6325](https://issues.apache.org/jira/browse/PHOENIX-6325) | Adapt queryserver build to the new phoenix-client artifactIds | Blocker | queryserver | +| [PHOENIX-6294](https://issues.apache.org/jira/browse/PHOENIX-6294) | javax.servlet relocation added by PHOENIX-6151 breaks PQS | Blocker | queryserver | +| [PHOENIX-6238](https://issues.apache.org/jira/browse/PHOENIX-6238) | Fix missing executable permission because of MASSEMBLY-941 | Major | connectors, queryserver | +| [PHOENIX-6162](https://issues.apache.org/jira/browse/PHOENIX-6162) | Apply PHOENIX-5594 to the phoenix-queryserver repo | Major | queryserver | +| [PHOENIX-5994](https://issues.apache.org/jira/browse/PHOENIX-5994) | SqlAlchemy schema filtering incorrect semantics | Major | queryserver | +| [PHOENIX-5901](https://issues.apache.org/jira/browse/PHOENIX-5901) | Add LICENSE and NOTICE files to phoenix-queryserver | Blocker | queryserver | +| [PHOENIX-5959](https://issues.apache.org/jira/browse/PHOENIX-5959) | python scripts not working for phoenix-queryserver | Major | queryserver | +| [PHOENIX-5936](https://issues.apache.org/jira/browse/PHOENIX-5936) | sqlAlchemy get\_columns KeyError: None | Major | queryserver | +| [PHOENIX-5831](https://issues.apache.org/jira/browse/PHOENIX-5831) | Make Phoenix queryserver scripts work with Python 3 | Critical | queryserver | +| [PHOENIX-5852](https://issues.apache.org/jira/browse/PHOENIX-5852) | The zkConnectionString in LoadBalance is incorrect | Major | queryserver | +| [PHOENIX-5879](https://issues.apache.org/jira/browse/PHOENIX-5879) | Fix recently introduced python 2.7 incompatibilities and flake8 warning | Major | queryserver | +| [PHOENIX-5873](https://issues.apache.org/jira/browse/PHOENIX-5873) | Fix loadbalancer packaging problem for queryserver scripts | Major | queryserver | +| [PHOENIX-5830](https://issues.apache.org/jira/browse/PHOENIX-5830) | Fix python printing in query-server | Major | queryserver | +| [PHOENIX-5761](https://issues.apache.org/jira/browse/PHOENIX-5761) | sqlline-thin kerberos logic too aggressive | Major | queryserver | +| [PHOENIX-5741](https://issues.apache.org/jira/browse/PHOENIX-5741) | Spurious protobuf version property in queryserver-client pom | Trivial | queryserver | +| [PHOENIX-5670](https://issues.apache.org/jira/browse/PHOENIX-5670) | Add the neccesary Synchronisation to the tests in the PQS repo | Major | queryserver | +| [PHOENIX-5234](https://issues.apache.org/jira/browse/PHOENIX-5234) | Create patch scripts for phoenix-connectors and phoenix-queryserver projects | Major | connectors, queryserver | +| [PHOENIX-5421](https://issues.apache.org/jira/browse/PHOENIX-5421) | Phoenix Query server tests race condition issue on creating keytab folder | Blocker | queryserver | +| [PHOENIX-5394](https://issues.apache.org/jira/browse/PHOENIX-5394) | Integration tests not running for phoenix-queryserver, general build cruft. | Blocker | queryserver | +| [PHOENIX-5221](https://issues.apache.org/jira/browse/PHOENIX-5221) | Phoenix Kerberos Integration tests failure on Redhat Linux | Blocker | queryserver | + + +### SUB-TASKS: + +| JIRA | Summary | Priority | Component | +|:---- |:---- | :--- |:---- | +| [PHOENIX-5846](https://issues.apache.org/jira/browse/PHOENIX-5846) | Let the python client parse options from the JDBC URL | Major | python, queryserver | +| [PHOENIX-5859](https://issues.apache.org/jira/browse/PHOENIX-5859) | Add Array support to the python driver | Major | python, queryserver | +| [PHOENIX-5858](https://issues.apache.org/jira/browse/PHOENIX-5858) | Add commit/rollback support to the python client | Major | python, queryserver | +| [PHOENIX-5857](https://issues.apache.org/jira/browse/PHOENIX-5857) | Get the python test suite working | Major | python, queryserver | +| [PHOENIX-5848](https://issues.apache.org/jira/browse/PHOENIX-5848) | Add DIGEST auth support to the python client | Major | python, queryserver | +| [PHOENIX-5847](https://issues.apache.org/jira/browse/PHOENIX-5847) | Add BASIC auth support to the python client | Major | python, queryserver | +| [PHOENIX-5856](https://issues.apache.org/jira/browse/PHOENIX-5856) | Switch the python driver to requests\_gssapi | Major | python, queryserver | +| [PHOENIX-5845](https://issues.apache.org/jira/browse/PHOENIX-5845) | Add HTTPS support to the python client | Major | python, queryserver | + + +### OTHER: + +| JIRA | Summary | Priority | Component | +|:---- |:---- | :--- |:---- | +| [PHOENIX-5759](https://issues.apache.org/jira/browse/PHOENIX-5759) | Reduce thin client JAR size / classpath noise | Major | queryserver | +| [PHOENIX-6065](https://issues.apache.org/jira/browse/PHOENIX-6065) | Add OWASP dependency check, and update the flagged direct dependencies | Major | connectors, core, queryserver | +| [PHOENIX-5939](https://issues.apache.org/jira/browse/PHOENIX-5939) | Publish PhoenixDB to PyPI | Major | python, queryserver | +| [PHOENIX-6060](https://issues.apache.org/jira/browse/PHOENIX-6060) | Create release script for python-phoenixdb ASF releases | Major | python, queryserver | +| [PHOENIX-5771](https://issues.apache.org/jira/browse/PHOENIX-5771) | Make standalone queryserver assembly useful again | Major | queryserver | +| [PHOENIX-5824](https://issues.apache.org/jira/browse/PHOENIX-5824) | Add dependency:analyze to queryserver build | Major | queryserver | +| [PHOENIX-5772](https://issues.apache.org/jira/browse/PHOENIX-5772) | Streamline the kerberos logic in thin client java code | Major | queryserver | +| [PHOENIX-5680](https://issues.apache.org/jira/browse/PHOENIX-5680) | remove psql.py from phoenix-queryserver | Minor | queryserver | + + + Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/RELEASENOTES.md ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC5/RELEASENOTES.md (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC5/RELEASENOTES.md Fri Jul 16 16:01:24 2021 @@ -0,0 +1,58 @@ + +<!--- +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you under the Apache License, Version 2.0 (the +# "License"); you may not use this file except in compliance +# with the License. You may obtain a copy of the License at +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. +--> +# PHOENIX queryserver-6.0.0 Release Notes + +These release notes cover new developer and user-facing incompatibilities, important issues, features, and major improvements. + + +--- + +* [PHOENIX-6488](https://issues.apache.org/jira/browse/PHOENIX-6488) | *Major* | **Bump Avatica version to 1.18.0 in queryserver** + +Avatica version has been update to 1.18.0 + + +--- + +* [PHOENIX-6473](https://issues.apache.org/jira/browse/PHOENIX-6473) | *Major* | **Add Hadoop JMXServlet as /jmx endpoint** + +New HTTP endpoint is available at \<pqs\_url\>/jmx to expose all read-only JMX values in JSON format. + + +--- + +* [PHOENIX-5446](https://issues.apache.org/jira/browse/PHOENIX-5446) | *Major* | **Support Protobuf shaded clients (thin + thick)** + +**WARNING: No release note provided for this change.** + + +--- + +* [PHOENIX-5772](https://issues.apache.org/jira/browse/PHOENIX-5772) | *Major* | **Streamline the kerberos logic in thin client java code** + +The java thin client library has been refactored. It no longer includes Hadoop libraries, and uses the Java SE Kerberos implementation directly. + +The sqlline library has also been removed from the thin client JAR. + +The standalone sqlline JAR is now included in the lib/ directory, and is now added to the classpath by the sqlline-thin.py script. + +Some default parameters that were picked up from hbase-site.xml by the java thin client are now also handled by sqlline-thin.py + + + Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz ============================================================================== Binary file - no diff available. Propchange: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.asc ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.asc (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.asc Fri Jul 16 16:01:24 2021 @@ -0,0 +1,11 @@ +-----BEGIN PGP SIGNATURE----- + +iQEzBAABCgAdFiEEglIDpwQFvIOuz199lzUcG3lEM8cFAmDxrUMACgkQlzUcG3lE +M8e1pwf+NDONUiWx57FrOftkDogpMjayvUkOFscOOtII3RABZ2KXvANmyHqD/s17 +wd16coDWam1k2v/Vu0BqjWg3VXLkw82C+OCmfDJeeiVWgu12MHKZOUcYmVScC4U8 +mnT29h5ypKqWWVPVMeJ3U5g94vu+3yfBdu3NUA26vGxsPsrwyrUHIrZxCTWoZ6G3 +x5ahP9p6Ne90PQGX5o7asXx3suKyVbrH6mbT3BIe7Hg4q6qKGp7gSv/Tylu6FsdZ ++sgVODrFkJeJkirQyD8iNWrJgoGddX6urNVhGy09J/EvFvFcOxWEnH5Fhl+jCyV1 +GxwZI28jqpasmqCQa6tb0ep+cqd7Lg== +=2CmY +-----END PGP SIGNATURE----- Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 Fri Jul 16 16:01:24 2021 @@ -0,0 +1,4 @@ +phoenix-queryserver-6.0.0-bin.tar.gz: 6E63BE67 84CD3613 719B41C2 5D6E767C + 44BCC1D8 99081D92 D49AFCE7 E5E1A7BE + D4351521 F1B38544 8770A456 05EC73BA + 8AF115F4 B875D414 0AA79214 2B840D59 Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz ============================================================================== Binary file - no diff available. Propchange: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.asc ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.asc (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.asc Fri Jul 16 16:01:24 2021 @@ -0,0 +1,11 @@ +-----BEGIN PGP SIGNATURE----- + +iQEzBAABCgAdFiEEglIDpwQFvIOuz199lzUcG3lEM8cFAmDxqs0ACgkQlzUcG3lE +M8fyAQgAl3bGDkoGQEOJCVSMOo3t7SIXQAAhwamwM/wX/VWT+MUdrMVfSw+ftdkQ +m5az+mj1STR5wS7s0tOhBissMyRVawscDxPJMCuLTWUlY7mJWxaUSUuYqBxfhDFb +nNylHnAmDh2Ho3cNz5neID21oWWtls5Zphwu1acT3hu1ZUk/5m0CcYMN+itvZHc1 +jihgrFyVyYOHSsT7SSArvp2RrNUK+QX0pTtEQFQpxdZnMCCR5u40iHQiWGPAcSff +CjtSf93A3K9e0PU+xNECGxEZ2d6gRSaegDPXO79uVZBZr8oJmMoJpxzd95d8VFHW +koYRS4OBDUZIPv+A0NLUhHJU9VwzSA== +=CJv6 +-----END PGP SIGNATURE----- Added: dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.sha512 ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.sha512 (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC5/phoenix-queryserver-6.0.0-src.tar.gz.sha512 Fri Jul 16 16:01:24 2021 @@ -0,0 +1,4 @@ +phoenix-queryserver-6.0.0-src.tar.gz: E6A5B801 C039F1F7 3331D9FA 2011E5CA + 414B9394 8BCE6BF0 006E8722 03DDF8B5 + 325648D3 CB0CBE73 7C4EF3D5 CCAA6940 + D92351C6 32BD0BE3 2B5FE965 33336537