Author: stoty Date: Tue Jul 13 18:01:13 2021 New Revision: 48809 Log: Apache phoenix-queryserver 6.0.0RC3
Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/ dev/phoenix/phoenix-queryserver-6.0.0RC3/CHANGES.md dev/phoenix/phoenix-queryserver-6.0.0RC3/RELEASENOTES.md dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz (with props) dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.asc dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz (with props) dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.asc dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.sha512 Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/CHANGES.md ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC3/CHANGES.md (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC3/CHANGES.md Tue Jul 13 18:01:13 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-13) + + + +### 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.0RC3/RELEASENOTES.md ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC3/RELEASENOTES.md (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC3/RELEASENOTES.md Tue Jul 13 18:01:13 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.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz ============================================================================== Binary file - no diff available. Propchange: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.asc ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.asc (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.asc Tue Jul 13 18:01:13 2021 @@ -0,0 +1,11 @@ +-----BEGIN PGP SIGNATURE----- + +iQEzBAABCgAdFiEEglIDpwQFvIOuz199lzUcG3lEM8cFAmDt1NcACgkQlzUcG3lE +M8cufwgAgq2cz+AZFcnryVwAWxscTdUyO3rkIF2APvpg1GGLHkoGMKsA8bMt2tJ4 +4wl8yuJ8CktRQITJf5tyGwrbbI1u2uJIXiLf1+iaanNzFRMxARgr6vz1mirlQ+rT +/7TFPgRoQ+49MstoiGqaMaPJDWH4cqC9JpoF+rl52VuQc04ux1uRI5b4kRRilhUt +/uyaYrLIMndi0YMfULOemdtXdG0aOLaxSgBHwvLAeMgCxFkSHVK1fIhAbVebeDr6 ++5NtFaB7bb6/FUIRxHOmTfd34Prhe3Bm/UdBXK28Lc5PT4zVD/JfPQP83zxxzX5O +V0XRg+PzuCokhQ59ytqUMSoUsp5PvQ== +=KNrw +-----END PGP SIGNATURE----- Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-bin.tar.gz.sha512 Tue Jul 13 18:01:13 2021 @@ -0,0 +1,4 @@ +phoenix-queryserver-6.0.0-bin.tar.gz: 7BDB85FA 9723FA86 D8225531 6AF1FEB3 + 5A24780A 6E2ADF09 2A8320EF A2BC37ED + 19D78837 B0AC84B4 0A7BDD63 185686D9 + 9EA9A8B8 75602DA6 BE38B786 C8835A4E Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz ============================================================================== Binary file - no diff available. Propchange: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.asc ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.asc (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.asc Tue Jul 13 18:01:13 2021 @@ -0,0 +1,11 @@ +-----BEGIN PGP SIGNATURE----- + +iQEzBAABCgAdFiEEglIDpwQFvIOuz199lzUcG3lEM8cFAmDt03IACgkQlzUcG3lE +M8c/Dgf/Shn3ulH/sy0wInl0cph8dN85l4ePk5l7/ELqGMDH0/QhV+3M7W5ZVtIV +UQTcpI0SIJRNfJiP9kI0yYJ6SERO61MwxpPk8y/gvsMnAH4pDJJ/QPz5QbzBwm7v +whXqa5ZswjQ/uREcYbpPB6rdYsMkJPXhOO4NxCL4kXQRWdaYENqlzQdFOmhnBr4f +ci5c9SGGCXYQA+Yfty9+mdCJOkSBujHe5buVBXmnzPL0vEz01+I5cZxcZ1lmjrax +OupYVBRzowWEG0RBnf6FW+HdNlan3Bg5USxB22zi2VxS7VoP3/eQD0BBjJPF/yBY +5u5G5jHUzz/eEEncNiJaH+CpkVHoOw== +=B6Gm +-----END PGP SIGNATURE----- Added: dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.sha512 ============================================================================== --- dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.sha512 (added) +++ dev/phoenix/phoenix-queryserver-6.0.0RC3/phoenix-queryserver-6.0.0-src.tar.gz.sha512 Tue Jul 13 18:01:13 2021 @@ -0,0 +1,4 @@ +phoenix-queryserver-6.0.0-src.tar.gz: B5E275EC 96D94242 544CC0E4 76843888 + 61F58B8C BEB5BF54 B14371FB 51E9E392 + 1C25DACB 8BB85605 09E1AE55 A814045F + 53645248 EF5998EA 8D35D126 28AD9FA4