<!--- # 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 |