<!---
# 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 5.2.0 - Unreleased (as of 2024-04-06)
### NEW FEATURES:
| JIRA | Summary | Priority | Component |
|:---- |:---- | :--- |:---- |
| [PHOENIX-7038](
https://issues.apache.org/jira/browse/PHOENIX-7038) | Implement Connection Query Service Metrics | Major | . |
| [PHOENIX-6973](
https://issues.apache.org/jira/browse/PHOENIX-6973) | Add option to CREATE TABLE to skip verification of HBase table | Major | core |
| [PHOENIX-6491](
https://issues.apache.org/jira/browse/PHOENIX-6491) | Phoenix High Availability | Major | core |
| [PHOENIX-6692](
https://issues.apache.org/jira/browse/PHOENIX-6692) | Add HBase 2.5 support | Major | core |
| [PHOENIX-6681](
https://issues.apache.org/jira/browse/PHOENIX-6681) | Enable new indexes to be optionally created in CREATE\_DISABLED state | Major | . |
| [PHOENIX-6413](
https://issues.apache.org/jira/browse/PHOENIX-6413) | Having cannot resolve alias | Major | . |
| [PHOENIX-6405](
https://issues.apache.org/jira/browse/PHOENIX-6405) | Disallow bulk loading into non-empty tables with global secondary indexes | Major | core |
| [PHOENIX-6457](
https://issues.apache.org/jira/browse/PHOENIX-6457) | Optionally store schema version string in SYSTEM.CATALOG | Major | . |
### IMPROVEMENTS:
| JIRA | Summary | Priority | Component |
|:---- |:---- | :--- |:---- |
| [PHOENIX-7253](
https://issues.apache.org/jira/browse/PHOENIX-7253) | Metadata lookup performance improvement for range scan queries | Critical | . |
| [PHOENIX-7275](
https://issues.apache.org/jira/browse/PHOENIX-7275) | Update HBase 2.5 default version to 2.5.8 | Minor | core |
| [PHOENIX-7258](
https://issues.apache.org/jira/browse/PHOENIX-7258) | Query Optimizer should pick Index hint even for point lookup queries | Major | . |
| [PHOENIX-7229](
https://issues.apache.org/jira/browse/PHOENIX-7229) | Leverage bloom filters for single key point lookups | Major | . |
| [PHOENIX-7230](
https://issues.apache.org/jira/browse/PHOENIX-7230) | Optimize rpc call to master if all indexes are migrated to new coprocs | Major | . |
| [PHOENIX-7216](
https://issues.apache.org/jira/browse/PHOENIX-7216) | Bump Hadoop version to 3.2.4 for 2.5.x profile | Major | core |
| [PHOENIX-7144](
https://issues.apache.org/jira/browse/PHOENIX-7144) | TableLevel Phoenix Metrics returns base tableName when queried for Index Table. | Major | . |
| [PHOENIX-7220](
https://issues.apache.org/jira/browse/PHOENIX-7220) | Make HBase 2.5 profile the default | Major | core |
| [PHOENIX-7218](
https://issues.apache.org/jira/browse/PHOENIX-7218) | Drop HBase 2.4.0 support in 5.2 | Major | core |
| [PHOENIX-7157](
https://issues.apache.org/jira/browse/PHOENIX-7157) | Upgrade to phoenix-thirdparty 2.1.0 | Major | core |
| [PHOENIX-7213](
https://issues.apache.org/jira/browse/PHOENIX-7213) | Add option for unlimited phoenix.query.QueueSize | Major | . |
| [PHOENIX-7188](
https://issues.apache.org/jira/browse/PHOENIX-7188) | Remove Omid TTable.getTableDescriptor() calls | Critical | core |
| [PHOENIX-7106](
https://issues.apache.org/jira/browse/PHOENIX-7106) | Data Integrity issues due to invalid rowkeys returned by various coprocessors | Blocker | . |
| [PHOENIX-7187](
https://issues.apache.org/jira/browse/PHOENIX-7187) | Improvement of Integration test case with Explain Plan for Partial Index | Major | . |
| [PHOENIX-7181](
https://issues.apache.org/jira/browse/PHOENIX-7181) | Do not declare commons-configuration2 dependency | Major | core |
| [PHOENIX-7043](
https://issues.apache.org/jira/browse/PHOENIX-7043) | Split FailoverPhoenixConnectionIT | Minor | core |
| [PHOENIX-7156](
https://issues.apache.org/jira/browse/PHOENIX-7156) | Run integration tests based on @Category | Major | . |
| [PHOENIX-7140](
https://issues.apache.org/jira/browse/PHOENIX-7140) | Update Apache Parent and Maven Plugin Versions in Core | Major | core |
| [PHOENIX-6053](
https://issues.apache.org/jira/browse/PHOENIX-6053) | Split Server Side Code into a Separate Module | Major | core |
| [PHOENIX-7101](
https://issues.apache.org/jira/browse/PHOENIX-7101) | Explain plan to output local index name if it is used | Major | . |
| [PHOENIX-7063](
https://issues.apache.org/jira/browse/PHOENIX-7063) | Track and account garbage collected phoenix connections | Major | . |
| [PHOENIX-7067](
https://issues.apache.org/jira/browse/PHOENIX-7067) | View indexes should be created only on non overlapping updatable views | Major | . |
| [PHOENIX-6523](
https://issues.apache.org/jira/browse/PHOENIX-6523) | Support for HBase Registry Implementations through Phoenix connection URL | Major | core |
| [PHOENIX-7066](
https://issues.apache.org/jira/browse/PHOENIX-7066) | Specify -Xms for tests | Major | core |
| [PHOENIX-7055](
https://issues.apache.org/jira/browse/PHOENIX-7055) | Usage improvements for sqline.py | Major | . |
| [PHOENIX-7051](
https://issues.apache.org/jira/browse/PHOENIX-7051) | Remove direct dependency on Google Guice from phoenix-core | Critical | core |
| [PHOENIX-6900](
https://issues.apache.org/jira/browse/PHOENIX-6900) | Enable paging feature when the phoenix query is made on a table snapshot. | Major | . |
| [PHOENIX-7036](
https://issues.apache.org/jira/browse/PHOENIX-7036) | Copy the Java version specific profiles for JVM options from HBase | Major | connectors, core, queryserver |
| [PHOENIX-6907](
https://issues.apache.org/jira/browse/PHOENIX-6907) | Explain Plan should output region locations with servers | Major | . |
| [PHOENIX-6995](
https://issues.apache.org/jira/browse/PHOENIX-6995) | HA client connections ignore additional jdbc params in the jdbc string | Major | . |
| [PHOENIX-6986](
https://issues.apache.org/jira/browse/PHOENIX-6986) | Add property to disable server merges for hinted uncovered indexes | Major | core |
| [PHOENIX-6983](
https://issues.apache.org/jira/browse/PHOENIX-6983) | Add hint to disable server merges for uncovered index queries | Major | core |
| [PHOENIX-6984](
https://issues.apache.org/jira/browse/PHOENIX-6984) | Fix fallback to skip-join-merge for hinted global indexes | Major | phoenix |
| [PHOENIX-6981](
https://issues.apache.org/jira/browse/PHOENIX-6981) | Bump Jackson version to 2.14.1 | Major | . |
| [PHOENIX-6944](
https://issues.apache.org/jira/browse/PHOENIX-6944) | Randomize mapper task ordering for Index MR tools | Major | core |
| [PHOENIX-6560](
https://issues.apache.org/jira/browse/PHOENIX-6560) | Rewrite dynamic SQL queries to use Preparedstatement | Major | core |
| [PHOENIX-6918](
https://issues.apache.org/jira/browse/PHOENIX-6918) | ScanningResultIterator should not retry when the query times out | Major | . |
| [PHOENIX-6832](
https://issues.apache.org/jira/browse/PHOENIX-6832) | Uncovered Global Secondary Indexes | Major | . |
| [PHOENIX-6821](
https://issues.apache.org/jira/browse/PHOENIX-6821) | Batching with auto-commit connections | Major | . |
| [PHOENIX-6914](
https://issues.apache.org/jira/browse/PHOENIX-6914) | Refactor phoenix-pherf to use java.time instead of Joda-Time | Major | core |
| [PHOENIX-6881](
https://issues.apache.org/jira/browse/PHOENIX-6881) | Implement the applicable Date/Time features from JDBC 4.2 | Major | core |
| [PHOENIX-6899](
https://issues.apache.org/jira/browse/PHOENIX-6899) | Query limit not enforced in UncoveredIndexRegionScanner | Major | . |
| [PHOENIX-6880](
https://issues.apache.org/jira/browse/PHOENIX-6880) | Remove dynamicFilter from BaseQueryPlan | Trivial | . |
| [PHOENIX-6877](
https://issues.apache.org/jira/browse/PHOENIX-6877) | Remove HBase 2.3 support from 5.2 | Major | core |
| [PHOENIX-6889](
https://issues.apache.org/jira/browse/PHOENIX-6889) | Improve extraction of ENCODED\_QUALIFIERs | Major | core |
| [PHOENIX-6776](
https://issues.apache.org/jira/browse/PHOENIX-6776) | Abort scans of closed connections at ScanningResultIterator | Major | . |
| [PHOENIX-6655](
https://issues.apache.org/jira/browse/PHOENIX-6655) | SYSTEM.SEQUENCE should have CACHE\_DATA\_ON\_WRITE set to true | Major | . |
| [PHOENIX-6837](
https://issues.apache.org/jira/browse/PHOENIX-6837) | Switch to Using the -hadoop3 HBase Artifacts Where Available | Major | core |
| [PHOENIX-6761](
https://issues.apache.org/jira/browse/PHOENIX-6761) | Phoenix Client Side Metadata Caching Improvement | Major | . |
| [PHOENIX-6834](
https://issues.apache.org/jira/browse/PHOENIX-6834) | Use Pooled HConnection for Server Side Upsert Select | Major | core |
| [PHOENIX-6818](
https://issues.apache.org/jira/browse/PHOENIX-6818) | Remove dependency on the i18n-util library | Major | core |
| [PHOENIX-6827](
https://issues.apache.org/jira/browse/PHOENIX-6827) | Update hbase-version to 2.4.15 in phoenix master branch | Major | . |
| [PHOENIX-6826](
https://issues.apache.org/jira/browse/PHOENIX-6826) | Don't invalidate meta cache if CQSI#getTableRegionLocation encounters IOException. | Major | core |
| [PHOENIX-6561](
https://issues.apache.org/jira/browse/PHOENIX-6561) | Allow pherf to intake phoenix Connection properties as argument. | Minor | . |
| [PHOENIX-6749](
https://issues.apache.org/jira/browse/PHOENIX-6749) | Replace deprecated HBase 1.x API calls | Major | connectors, core, queryserver |
| [PHOENIX-6767](
https://issues.apache.org/jira/browse/PHOENIX-6767) | Traversing through all the guideposts to prepare parallel scans is not required for salted tables when the query is point lookup | Major | . |
| [PHOENIX-6779](
https://issues.apache.org/jira/browse/PHOENIX-6779) | Account for connection attempted & failure metrics in all paths | Major | . |
| [PHOENIX-6707](
https://issues.apache.org/jira/browse/PHOENIX-6707) | Use Configuration.getLongBytes where applicable | Minor | core |
| [PHOENIX-5274](
https://issues.apache.org/jira/browse/PHOENIX-5274) | ConnectionQueryServiceImpl#ensureNamespaceCreated and ensureTableCreated should use HBase APIs that do not require ADMIN permissions for existence checks | Major | . |
| [PHOENIX-6554](
https://issues.apache.org/jira/browse/PHOENIX-6554) | Pherf CLI option long/short option names do not follow conventions | Minor | core |
| [PHOENIX-6703](
https://issues.apache.org/jira/browse/PHOENIX-6703) | Exclude Jetty and servlet-api from phoenix-client | Major | core |
| [PHOENIX-6690](
https://issues.apache.org/jira/browse/PHOENIX-6690) | Bump HBase 2.4 version to 2.4.11 | Major | core |
| [PHOENIX-6588](
https://issues.apache.org/jira/browse/PHOENIX-6588) | Update to phoenix-thirdparty 2.0.0 | Major | core |
| [PHOENIX-6663](
https://issues.apache.org/jira/browse/PHOENIX-6663) | Use batching when joining data table rows with uncovered local index rows | Major | . |
| [PHOENIX-6501](
https://issues.apache.org/jira/browse/PHOENIX-6501) | Use batching when joining data table rows with uncovered global index rows | Major | . |
| [PHOENIX-6458](
https://issues.apache.org/jira/browse/PHOENIX-6458) | Using global indexes for queries with uncovered columns | Major | . |
| [PHOENIX-6599](
https://issues.apache.org/jira/browse/PHOENIX-6599) | Missing checked exceptions on SchemaRegistryRepository | Major | . |
| [PHOENIX-6247](
https://issues.apache.org/jira/browse/PHOENIX-6247) | Change SYSTEM.CATALOG to allow separation of physical name (Hbase name) from logical name (Phoenix name) | Major | . |
| [PHOENIX-6556](
https://issues.apache.org/jira/browse/PHOENIX-6556) | Log INPUT\_TABLE\_CONDITIONS for MR jobs | Minor | core, spark-connector |
| [PHOENIX-6544](
https://issues.apache.org/jira/browse/PHOENIX-6544) | Adding metadata inconsistency metric | Minor | . |
| [PHOENIX-6387](
https://issues.apache.org/jira/browse/PHOENIX-6387) | Conditional updates on tables with indexes | Major | . |
| [PHOENIX-6450](
https://issues.apache.org/jira/browse/PHOENIX-6450) | Checkstyle creating warnings for line length \> 80 but \< 100 | Major | core |
| [PHOENIX-6500](
https://issues.apache.org/jira/browse/PHOENIX-6500) | Allow 4.16 client to connect to 5.1 server | Major | . |
| [PHOENIX-6495](
https://issues.apache.org/jira/browse/PHOENIX-6495) | Include phoenix-tools jar in assembly | Major | core |
| [PHOENIX-6497](
https://issues.apache.org/jira/browse/PHOENIX-6497) | Remove embedded profile and always build phoenix-client-embedded | Major | . |
| [PHOENIX-6454](
https://issues.apache.org/jira/browse/PHOENIX-6454) | Add feature to SchemaTool to get the DDL in specification mode | Major | . |
| [PHOENIX-6378](
https://issues.apache.org/jira/browse/PHOENIX-6378) | Unbundle sqlline from phoenix-client-embedded, and use it in sqlline.py | Major | core |
| [PHOENIX-6444](
https://issues.apache.org/jira/browse/PHOENIX-6444) | Extend Cell Tags to Delete object for Indexer coproc | Major | core |
| [PHOENIX-6357](
https://issues.apache.org/jira/browse/PHOENIX-6357) | Change all command line tools to use the fixed commons-cli constructor | Major | core |
| [PHOENIX-6422](
https://issues.apache.org/jira/browse/PHOENIX-6422) | Remove CorrelatePlan | Minor | core |
| [PHOENIX-6271](
https://issues.apache.org/jira/browse/PHOENIX-6271) | Effective DDL generated by SchemaExtractionTool should maintain the order of PK and other columns | Minor | . |
| [PHOENIX-6435](
https://issues.apache.org/jira/browse/PHOENIX-6435) | Fix ViewTTLIT test flapper | Blocker | . |
| [PHOENIX-6434](
https://issues.apache.org/jira/browse/PHOENIX-6434) | Secondary Indexes on PHOENIX\_ROW\_TIMESTAMP() | Major | . |
| [PHOENIX-6409](
https://issues.apache.org/jira/browse/PHOENIX-6409) | Include local index uncovered columns merge in explain plan. | Minor | . |
| [PHOENIX-6385](
https://issues.apache.org/jira/browse/PHOENIX-6385) | Not to use Scan#setSmall for HBase 2.x versions | Major | . |
| [PHOENIX-6402](
https://issues.apache.org/jira/browse/PHOENIX-6402) | Allow using local indexes with uncovered columns in the WHERE clause | Blocker | . |
| [PHOENIX-6388](
https://issues.apache.org/jira/browse/PHOENIX-6388) | Add sampled logging for read repairs | Minor | . |
| [PHOENIX-6396](
https://issues.apache.org/jira/browse/PHOENIX-6396) | PChar illegal data exception should not contain value | Major | . |
| [PHOENIX-6380](
https://issues.apache.org/jira/browse/PHOENIX-6380) | phoenix-client-embedded depends on logging classes | Major | core |
### BUG FIXES:
| JIRA | Summary | Priority | Component |
|:---- |:---- | :--- |:---- |
| [PHOENIX-7299](
https://issues.apache.org/jira/browse/PHOENIX-7299) | ScanningResultIterator should not time out a query after receiving a valid result | Major | . |
| [PHOENIX-7295](
https://issues.apache.org/jira/browse/PHOENIX-7295) | Fix getTableRegions failing due to overlap/inconsistencies on region | Major | . |
| [PHOENIX-7291](
https://issues.apache.org/jira/browse/PHOENIX-7291) | Bump up omid to 1.1.2 | Major | . |
| [PHOENIX-7285](
https://issues.apache.org/jira/browse/PHOENIX-7285) | Upgade Zookeeper to 3.8.4 | Major | core |
| [PHOENIX-7234](
https://issues.apache.org/jira/browse/PHOENIX-7234) | Bump org.apache.commons:commons-compress from 1.21 to 1.26.0 | Major | core |
| [PHOENIX-7223](
https://issues.apache.org/jira/browse/PHOENIX-7223) | Make Sure Tools Always Close HBase Connections on Exit | Minor | core |
| [PHOENIX-7160](
https://issues.apache.org/jira/browse/PHOENIX-7160) | Change the TSO default port to be compatible with Omid 1.1.1 | Major | omid |
| [PHOENIX-7175](
https://issues.apache.org/jira/browse/PHOENIX-7175) | Set java.io.tmpdir to the maven build directory for tests | Minor | connectors, core, queryserver |
| [PHOENIX-7089](
https://issues.apache.org/jira/browse/PHOENIX-7089) | TableMetricsManager#getSizeHistogramsForAllTables() is returning empty map | Minor | . |
| [PHOENIX-7193](
https://issues.apache.org/jira/browse/PHOENIX-7193) | Fix cluster override for mapreduce jobs for non-ZK registries | Major | core |
| [PHOENIX-7165](
https://issues.apache.org/jira/browse/PHOENIX-7165) | getTable should retrieve PTable from server if not cached | Major | . |
| [PHOENIX-7191](
https://issues.apache.org/jira/browse/PHOENIX-7191) | Connectionless CQSs don't work with non-ZK registries | Blocker | core |
| [PHOENIX-7141](
https://issues.apache.org/jira/browse/PHOENIX-7141) | Use relocate by default for phoenix-server shading | Blocker | core |
| [PHOENIX-6769](
https://issues.apache.org/jira/browse/PHOENIX-6769) | Align mockito version with Hadoop and HBase | Major | . |
| [PHOENIX-7195](
https://issues.apache.org/jira/browse/PHOENIX-7195) | Exclude reload4j dependencies from Hadoop and add explicit log4j2 test dependencies | Blocker | core |
| [PHOENIX-7194](
https://issues.apache.org/jira/browse/PHOENIX-7194) | Yetus does not run tests in phoenix-core if phoenix-core-client or phoenix-core-server changes | Blocker | core |
| [PHOENIX-7171](
https://issues.apache.org/jira/browse/PHOENIX-7171) | Update Zookeeper to 3.8.3 when building with HBase 2.4+ | Major | core |
| [PHOENIX-7138](
https://issues.apache.org/jira/browse/PHOENIX-7138) | Import netty-bom to make sure all netty 4.1 modules share the same version | Major | core |
| [PHOENIX-7178](
https://issues.apache.org/jira/browse/PHOENIX-7178) | Use skipITs instead of skip to disable failsafe tests | Major | core |
| [PHOENIX-7176](
https://issues.apache.org/jira/browse/PHOENIX-7176) | QueryTimeoutIT#testQueryTimeout fails with incorrect error message | Major | phoenix |
| [PHOENIX-7139](
https://issues.apache.org/jira/browse/PHOENIX-7139) | Create phoenix-mapreduce-byo-shaded-hbase artifact | Major | . |
| [PHOENIX-7137](
https://issues.apache.org/jira/browse/PHOENIX-7137) | Create phoenix-client-lite shaded JAR without server-side dependencies | Major | core |
| [PHOENIX-7152](
https://issues.apache.org/jira/browse/PHOENIX-7152) | SchemaExtractionProcessor package does not match directory | Major | . |
| [PHOENIX-6721](
https://issues.apache.org/jira/browse/PHOENIX-6721) | CSV bulkload tool fails with FileNotFoundException if --output points to the S3 location | Major | core |
| [PHOENIX-7153](
https://issues.apache.org/jira/browse/PHOENIX-7153) | Fix Warnings Flagged as Errors by Eclipse | Trivial | core |
| [PHOENIX-7076](
https://issues.apache.org/jira/browse/PHOENIX-7076) | MetaDataRegionObserver#postOpen hook improvements | Major | . |
| [PHOENIX-7143](
https://issues.apache.org/jira/browse/PHOENIX-7143) | Detect JVM version and add the necessary module flags in startup scripts | Major | core, queryserver |
| [PHOENIX-6909](
https://issues.apache.org/jira/browse/PHOENIX-6909) | Create client/server metrics for phoenix Paging feature. | Major | core |
| [PHOENIX-7109](
https://issues.apache.org/jira/browse/PHOENIX-7109) | Incorrect query results when using OFFSET | Major | phoenix |
| [PHOENIX-7024](
https://issues.apache.org/jira/browse/PHOENIX-7024) | Issues in ServerPaging | Major | . |
| [PHOENIX-7121](
https://issues.apache.org/jira/browse/PHOENIX-7121) | Do not exclude commons-beanutils from Omid dependencies | Major | core |
| [PHOENIX-7095](
https://issues.apache.org/jira/browse/PHOENIX-7095) | Implement Statement.closeOnCompletion() and fix related close() bugs | Major | core |
| [PHOENIX-7102](
https://issues.apache.org/jira/browse/PHOENIX-7102) | phoenix-connectors doesn't compile with core HEAD | Major | connectors, core |
| [PHOENIX-7097](
https://issues.apache.org/jira/browse/PHOENIX-7097) | Allow specifying full JDBC URL string in psql/PhoenixRuntime and sqllline.py | Major | core |
| [PHOENIX-7090](
https://issues.apache.org/jira/browse/PHOENIX-7090) | Hash join throw NullPointerException when subquery return null | Major | core |
| [PHOENIX-7070](
https://issues.apache.org/jira/browse/PHOENIX-7070) | Child View of ReadOnly View is marked as updatable View | Major | . |
| [PHOENIX-5980](
https://issues.apache.org/jira/browse/PHOENIX-5980) | MUTATION\_BATCH\_FAILED\_SIZE metric is incorrectly updated for failing delete mutations | Major | . |
| [PHOENIX-7060](
https://issues.apache.org/jira/browse/PHOENIX-7060) | Compilation fails on 5.1 with Hbase 2.1 or 2.2 | Blocker | . |
| [PHOENIX-7046](
https://issues.apache.org/jira/browse/PHOENIX-7046) | Query results return different values when PKs of view have DESC order | Major | . |
| [PHOENIX-7035](
https://issues.apache.org/jira/browse/PHOENIX-7035) | Index on data table with only pk columns result into invalid state | Major | . |
| [PHOENIX-7062](
https://issues.apache.org/jira/browse/PHOENIX-7062) | Stabilize testDeletingStatsShouldNotFailWithADEWhenTableDropped | Critical | core |
| [PHOENIX-7034](
https://issues.apache.org/jira/browse/PHOENIX-7034) | Disallow mapped view creation when the schema does not exists | Major | . |
| [PHOENIX-7057](
https://issues.apache.org/jira/browse/PHOENIX-7057) | Potential bug in MetadataEndpointImpl#updateIndexState. | Major | . |
| [PHOENIX-7039](
https://issues.apache.org/jira/browse/PHOENIX-7039) | Snapshot scanner should skip replay WAL and update seqid while opening region | Major | . |
| [PHOENIX-7003](
https://issues.apache.org/jira/browse/PHOENIX-7003) | Harden hbase region inconsistencies check in CQSI#getAllTableRegions method | Major | core |
| [PHOENIX-7052](
https://issues.apache.org/jira/browse/PHOENIX-7052) | phoenix-pherf ITs fail because they do not use the miniCluster ZK quorum | Major | core |
| [PHOENIX-7045](
https://issues.apache.org/jira/browse/PHOENIX-7045) | AlterTableWithViewsIT.testCreateViewWithPropsMaintainsOwnProps failing on 5.1 | Major | core |
| [PHOENIX-7042](
https://issues.apache.org/jira/browse/PHOENIX-7042) | Update Jetty to 9.4.52.v20230823 | Major | core, queryserver |
| [PHOENIX-7002](
https://issues.apache.org/jira/browse/PHOENIX-7002) | Insufficient logging in phoenix client when server throws StaleRegionBoundaryCacheException. | Major | . |
| [PHOENIX-6960](
https://issues.apache.org/jira/browse/PHOENIX-6960) | Scan range is wrong when query desc columns | Critical | . |
| [PHOENIX-6920](
https://issues.apache.org/jira/browse/PHOENIX-6920) | PhoenixResultSetMetaData doesn't distinguish between label and column\_name | Major | core |
| [PHOENIX-6864](
https://issues.apache.org/jira/browse/PHOENIX-6864) | create view throwing NPE when referring back to itself | Minor | core |
| [PHOENIX-6942](
https://issues.apache.org/jira/browse/PHOENIX-6942) | Some config properties do not have phoenix prefix | Minor | . |
| [PHOENIX-7019](
https://issues.apache.org/jira/browse/PHOENIX-7019) | ParallelPhoenixConnectionTest failures because of misconfigured EnvironmentEdgeManager | Critical | core |
| [PHOENIX-6945](
https://issues.apache.org/jira/browse/PHOENIX-6945) | Update Surefire plugin to 3.0.0 and switch to TCP forkNode implementation | Major | connectors, core, queryserver |
| [PHOENIX-7009](
https://issues.apache.org/jira/browse/PHOENIX-7009) | Bump commons-codec to 1.16.0 | Major | core |
| [PHOENIX-7010](
https://issues.apache.org/jira/browse/PHOENIX-7010) | Upgrade Jetty to 9.4.51.v20230217 | Major | . |
| [PHOENIX-5833](
https://issues.apache.org/jira/browse/PHOENIX-5833) | Incorrect results with RVCs and AND operator | Critical | core |
| [PHOENIX-7005](
https://issues.apache.org/jira/browse/PHOENIX-7005) | Spark connector tests cannot compile with latest Phoenix | Major | connectors, core, spark-connector |
| [PHOENIX-6897](
https://issues.apache.org/jira/browse/PHOENIX-6897) | Filters on unverified index rows return wrong result | Major | . |
| [PHOENIX-7000](
https://issues.apache.org/jira/browse/PHOENIX-7000) | Always schedule RenewLeaseTasks | Major | . |
| [PHOENIX-6952](
https://issues.apache.org/jira/browse/PHOENIX-6952) | Do not disable normalizer on salted tables | Blocker | core |
| [PHOENIX-6999](
https://issues.apache.org/jira/browse/PHOENIX-6999) | Point lookups fail with reverse scan | Major | core |
| [PHOENIX-6910](
https://issues.apache.org/jira/browse/PHOENIX-6910) | Scans created during query compilation and execution against salted tables need to be more resilient | Major | . |
| [PHOENIX-6961](
https://issues.apache.org/jira/browse/PHOENIX-6961) | Using a covered field in hinted non-covered indexed query fails | Critical | core |
| [PHOENIX-6966](
https://issues.apache.org/jira/browse/PHOENIX-6966) | UngroupedAggregateRegionScanner.insertEmptyKeyValue() writes wrong qualifier for encoded CQ tables | Major | core |
| [PHOENIX-6974](
https://issues.apache.org/jira/browse/PHOENIX-6974) | Move PBaseColumn to test | Minor | core |
| [PHOENIX-6962](
https://issues.apache.org/jira/browse/PHOENIX-6962) | Write javadoc for different mutation plans within DeleteCompiler. | Minor | core |
| [PHOENIX-6969](
https://issues.apache.org/jira/browse/PHOENIX-6969) | Projection bug in hinted uncovered index query with order by | Major | . |
| [PHOENIX-6965](
https://issues.apache.org/jira/browse/PHOENIX-6965) | UngroupedAggregateRegionScanner.insertEmptyKeyValue() generates too many cells | Critical | core |
| [PHOENIX-6950](
https://issues.apache.org/jira/browse/PHOENIX-6950) | PhoenixDriver APIs should unlock closeLock only if thread is able to take lock | Major | . |
| [PHOENIX-6953](
https://issues.apache.org/jira/browse/PHOENIX-6953) | Creating indexes on a table with old indexing leads to inconsistent co-processors | Major | core |
| [PHOENIX-6954](
https://issues.apache.org/jira/browse/PHOENIX-6954) | Fix Category for some index related ITs | Minor | core |
| [PHOENIX-6951](
https://issues.apache.org/jira/browse/PHOENIX-6951) | Missing information on Index Repair Region and Time Taken to Repair | Major | . |
| [PHOENIX-6916](
https://issues.apache.org/jira/browse/PHOENIX-6916) | Cannot handle ranges where start is a prefix of end for desc columns | Critical | core |
| [PHOENIX-6929](
https://issues.apache.org/jira/browse/PHOENIX-6929) | Explicitly depend on org.glassfish:javax.el | Critical | core |
| [PHOENIX-6888](
https://issues.apache.org/jira/browse/PHOENIX-6888) | Fixing TTL and Max Lookback Issues for Phoenix Tables | Major | . |
| [PHOENIX-6903](
https://issues.apache.org/jira/browse/PHOENIX-6903) | Shade or exclude javax.xml.bind:jaxb-api from the shaded client | Major | . |
| [PHOENIX-6904](
https://issues.apache.org/jira/browse/PHOENIX-6904) | Clean up some dependencies | Major | core |
| [PHOENIX-6890](
https://issues.apache.org/jira/browse/PHOENIX-6890) | Remove binds parameters from QueryCompiler | Trivial | . |
| [PHOENIX-5066](
https://issues.apache.org/jira/browse/PHOENIX-5066) | The TimeZone is incorrectly used during writing or reading data | Critical | . |
| [PHOENIX-6893](
https://issues.apache.org/jira/browse/PHOENIX-6893) | Remove explicit dependency declaration on hbase-thirdparty artifacts | Major | core |
| [PHOENIX-6871](
https://issues.apache.org/jira/browse/PHOENIX-6871) | Write threads blocked with deadlock | Major | . |
| [PHOENIX-6873](
https://issues.apache.org/jira/browse/PHOENIX-6873) | Use cached Connection in IndexHalfStoreFileReaderGenerator | Major | core |
| [PHOENIX-6874](
https://issues.apache.org/jira/browse/PHOENIX-6874) | Support older HBase versions with broken ShortCircuitConnection | Major | core |
| [PHOENIX-6872](
https://issues.apache.org/jira/browse/PHOENIX-6872) | Use ServerUtil.ConnectionFactory.getConnection() in UngroupedAggregateRegionScanner | Minor | core |
| [PHOENIX-6395](
https://issues.apache.org/jira/browse/PHOENIX-6395) | Reusing Connection instance object instead of creating everytime in PhoenixAccessController class. | Major | . |
| [PHOENIX-6052](
https://issues.apache.org/jira/browse/PHOENIX-6052) | Include syscat time in mutation time | Major | core |
| [PHOENIX-6720](
https://issues.apache.org/jira/browse/PHOENIX-6720) | CREATE TABLE can't recreate column encoded tables that had columns dropped | Blocker | core |
| [PHOENIX-6855](
https://issues.apache.org/jira/browse/PHOENIX-6855) | Upgrade from 4.7 to 5+ fails if any of the local indexes exist. | Major | core |
| [PHOENIX-6848](
https://issues.apache.org/jira/browse/PHOENIX-6848) | Fix grant and revoke command rule documentation | Major | core |
| [PHOENIX-6843](
https://issues.apache.org/jira/browse/PHOENIX-6843) | Flakey ViewTTLIT | Major | . |
| [PHOENIX-6840](
https://issues.apache.org/jira/browse/PHOENIX-6840) | Very flakey ParallelPhoenixConnectionFailureTest | Critical | core |
| [PHOENIX-6841](
https://issues.apache.org/jira/browse/PHOENIX-6841) | Depend on omid-codahale-metrics | Blocker | core, omid |
| [PHOENIX-6823](
https://issues.apache.org/jira/browse/PHOENIX-6823) | calling Joda-based round() function on temporal PK field causes division by zero error | Major | core |
| [PHOENIX-6835](
https://issues.apache.org/jira/browse/PHOENIX-6835) | Flakey RowTimestampIT.testAutomaticallySettingRowTimestampWithDate | Major | . |
| [PHOENIX-6784](
https://issues.apache.org/jira/browse/PHOENIX-6784) | PhantomJS fails on recent Linux distributions | Blocker | . |
| [PHOENIX-6806](
https://issues.apache.org/jira/browse/PHOENIX-6806) | Protobufs don't compile on ARM-based Macs (Apple Silicon) | Major | . |
| [PHOENIX-6462](
https://issues.apache.org/jira/browse/PHOENIX-6462) | Index build mapper that failed should not be logging into the PHOENIX\_INDEX\_TOOL\_RESULT table | Major | . |
| [PHOENIX-6669](
https://issues.apache.org/jira/browse/PHOENIX-6669) | RVC returns a wrong result | Major | . |
| [PHOENIX-6798](
https://issues.apache.org/jira/browse/PHOENIX-6798) | Eliminate unnecessary reversed scan for AggregatePlan | Major | core |
| [PHOENIX-6751](
https://issues.apache.org/jira/browse/PHOENIX-6751) | Force using range scan vs skip scan when using the IN operator and large number of RVC elements | Critical | . |
| [PHOENIX-6773](
https://issues.apache.org/jira/browse/PHOENIX-6773) | PhoenixDatabaseMetadata.getColumns() always returns null COLUMN\_DEF | Minor | core |
| [PHOENIX-6789](
https://issues.apache.org/jira/browse/PHOENIX-6789) | Remove com.sun.istack.NotNull usage | Minor | core |
| [PHOENIX-6764](
https://issues.apache.org/jira/browse/PHOENIX-6764) | Implement Binary and Hexadecimal literals | Major | core |
| [PHOENIX-6687](
https://issues.apache.org/jira/browse/PHOENIX-6687) | The region server hosting the SYSTEM.CATALOG fails to serve any metadata requests as default handler pool threads are exhausted. | Major | core |
| [PHOENIX-6771](
https://issues.apache.org/jira/browse/PHOENIX-6771) | Allow only "squash and merge" from GitHub UI | Major | . |
| [PHOENIX-6754](
https://issues.apache.org/jira/browse/PHOENIX-6754) | Upgrades from pre 4.10 versions are broken again | Blocker | core |
| [PHOENIX-6766](
https://issues.apache.org/jira/browse/PHOENIX-6766) | Fix failure of sqlline due to conflicting jline dependency pulled from Hadoop 3.3 | Major | . |
| [PHOENIX-6760](
https://issues.apache.org/jira/browse/PHOENIX-6760) | update log4j2 to 2.18.0 | Blocker | connectors, core |
| [PHOENIX-6756](
https://issues.apache.org/jira/browse/PHOENIX-6756) | switch to using log4j2.properties instead of xml | Major | core |
| [PHOENIX-6758](
https://issues.apache.org/jira/browse/PHOENIX-6758) | During HBase 2 upgrade Phoenix Self healing task fails to create server side connection before reading SYSTEM.TASK | Major | . |
| [PHOENIX-6755](
https://issues.apache.org/jira/browse/PHOENIX-6755) | SystemCatalogRegionObserver extends BaseRegionObserver which doesn't exist in hbase-2.4 branch. | Major | core |
| [PHOENIX-6746](
https://issues.apache.org/jira/browse/PHOENIX-6746) | Test suite executions do not provide usable logs | Blocker | core |
| [PHOENIX-6733](
https://issues.apache.org/jira/browse/PHOENIX-6733) | Ref count leaked test failures | Blocker | . |
| [PHOENIX-6530](
https://issues.apache.org/jira/browse/PHOENIX-6530) | Fix tenantId generation for Sequential and Uniform load generators | Major | . |
| [PHOENIX-6725](
https://issues.apache.org/jira/browse/PHOENIX-6725) | ConcurrentMutationException when adding column to table/view | Major | . |
| [PHOENIX-6734](
https://issues.apache.org/jira/browse/PHOENIX-6734) | Revert default HBase version to 2.4.10 | Major | core |
| [PHOENIX-5534](
https://issues.apache.org/jira/browse/PHOENIX-5534) | Cursors With Request Metrics Enabled Throws Exception | Major | . |
| [PHOENIX-6723](
https://issues.apache.org/jira/browse/PHOENIX-6723) | Phoenix client unable to connect on JDK14+ | Major | . |
| [PHOENIX-6636](
https://issues.apache.org/jira/browse/PHOENIX-6636) | Replace bundled log4j libraries with reload4j | Major | connectors, core |
| [PHOENIX-6498](
https://issues.apache.org/jira/browse/PHOENIX-6498) | Fix incorrect Correlated Exists Subquery rewrite when Subquery is aggregate | Major | . |
| [PHOENIX-6688](
https://issues.apache.org/jira/browse/PHOENIX-6688) | Upgrade to phoenix 4.16 metadata upgrade fails when SYSCAT has large number of tenant views | Major | core |
| [PHOENIX-6719](
https://issues.apache.org/jira/browse/PHOENIX-6719) | Duplicate Salt Columns in Schema Registry after ALTER | Major | . |
| [PHOENIX-6705](
https://issues.apache.org/jira/browse/PHOENIX-6705) | PagedRegionScanner#next throws NPE if pagedFilter is not initialized. | Major | core |
| [PHOENIX-6717](
https://issues.apache.org/jira/browse/PHOENIX-6717) | Remove Hbase 2.1 and 2.2 from post-commit Jenkins job | Major | core |
| [PHOENIX-6710](
https://issues.apache.org/jira/browse/PHOENIX-6710) | Revert PHOENIX-3842 Turn on back default bloomFilter for Phoenix Tables | Major | core |
| [PHOENIX-6699](
https://issues.apache.org/jira/browse/PHOENIX-6699) | Phoenix metrics overwriting DefaultMetricsSystem in RegionServers | Major | core |
| [PHOENIX-6708](
https://issues.apache.org/jira/browse/PHOENIX-6708) | Bump junit from 4.13 to 4.13.1 | Major | core |
| [PHOENIX-6682](
https://issues.apache.org/jira/browse/PHOENIX-6682) | Jenkins tests are failing for Java 11.0.14.1 | Major | . |
| [PHOENIX-6686](
https://issues.apache.org/jira/browse/PHOENIX-6686) | Update Jackson to 2.12.6.1 | Major | core |
| [PHOENIX-6679](
https://issues.apache.org/jira/browse/PHOENIX-6679) | PHOENIX-6665 changed column name for CURRENT seqence values | Minor | core |
| [PHOENIX-6616](
https://issues.apache.org/jira/browse/PHOENIX-6616) | Alter table command can be used to set normalization\_enabled=true on salted tables | Major | . |
| [PHOENIX-6675](
https://issues.apache.org/jira/browse/PHOENIX-6675) | create-release script broken by upgrade to Yetus 0.13 | Major | core |
| [PHOENIX-6665](
https://issues.apache.org/jira/browse/PHOENIX-6665) | PreparedStatement#getMetaData() fails on parametrized "select next ? values for SEQ" | Major | core |
| [PHOENIX-6658](
https://issues.apache.org/jira/browse/PHOENIX-6658) | Replace HRegion.get() calls | Major | . |
| [PHOENIX-6662](
https://issues.apache.org/jira/browse/PHOENIX-6662) | Failed to delete rows when PK has one or more DESC column with IN clause | Critical | . |
| [PHOENIX-6661](
https://issues.apache.org/jira/browse/PHOENIX-6661) | Sqlline does not work on PowerPC linux | Major | core, queryserver |
| [PHOENIX-6659](
https://issues.apache.org/jira/browse/PHOENIX-6659) | RVC with AND clauses return incorrect result | Critical | . |
| [PHOENIX-6656](
https://issues.apache.org/jira/browse/PHOENIX-6656) | Reindent NonAggregateRegionScannerFactory | Trivial | . |
| [PHOENIX-6646](
https://issues.apache.org/jira/browse/PHOENIX-6646) | System tables are not upgraded after namespace migration | Minor | core |
| [PHOENIX-6645](
https://issues.apache.org/jira/browse/PHOENIX-6645) | Remove unneccessary SCN related properties from SYSTEM tables on upgrade | Minor | core |
| [PHOENIX-5894](
https://issues.apache.org/jira/browse/PHOENIX-5894) | Table versus Table Full Outer join on Salted tables not working | Major | core |
| [PHOENIX-6576](
https://issues.apache.org/jira/browse/PHOENIX-6576) | Do not use guava's Files.createTempDir() | Major | . |
| [PHOENIX-6441](
https://issues.apache.org/jira/browse/PHOENIX-6441) | Remove TSOMockModule reference from OmidTransactionProvider | Major | core, omid |
| [PHOENIX-6638](
https://issues.apache.org/jira/browse/PHOENIX-6638) | Test suite fails with -Dwithout.tephra | Major | . |
| [PHOENIX-6591](
https://issues.apache.org/jira/browse/PHOENIX-6591) | Update OWASP plugin to latest | Major | connectors, core, queryserver |
| [PHOENIX-6579](
https://issues.apache.org/jira/browse/PHOENIX-6579) | ACL check doesn't honor the namespace mapping for mapped views. | Major | core |
| [PHOENIX-6596](
https://issues.apache.org/jira/browse/PHOENIX-6596) | Schema extraction double quotes expressions, resulting in un-executabe create statements | Major | core |
| [PHOENIX-5865](
https://issues.apache.org/jira/browse/PHOENIX-5865) | column that has default value can not be correctly indexed | Major | core |
| [PHOENIX-6615](
https://issues.apache.org/jira/browse/PHOENIX-6615) | The Tephra transaction processor cannot be loaded anymore. | Major | . |
| [PHOENIX-6611](
https://issues.apache.org/jira/browse/PHOENIX-6611) | Fix IndexTool -snap option and set VERIFIED in PhoenixIndexImportDirectReducer | Major | core |
| [PHOENIX-6618](
https://issues.apache.org/jira/browse/PHOENIX-6618) | Yetus docker image cannot be built as openjdk 11.0.11 is no longer available | Major | core |
| [PHOENIX-6604](
https://issues.apache.org/jira/browse/PHOENIX-6604) | Allow using indexes for wildcard topN queries on salted tables | Major | . |
| [PHOENIX-6528](
https://issues.apache.org/jira/browse/PHOENIX-6528) | When view index pk has a variable length column, read repair doesn't work correctly | Critical | . |
| [PHOENIX-6600](
https://issues.apache.org/jira/browse/PHOENIX-6600) | Replace deprecated getCall with updated getRpcCall | Major | . |
| [PHOENIX-6601](
https://issues.apache.org/jira/browse/PHOENIX-6601) | Fix IndexTools bugs with namespace mapping | Major | . |
| [PHOENIX-6594](
https://issues.apache.org/jira/browse/PHOENIX-6594) | Clean up vararg warnings flagged as errors by Eclipse | Minor | core |
| [PHOENIX-6592](
https://issues.apache.org/jira/browse/PHOENIX-6592) | PhoenixStatsCacheLoader uses non-deamon threads | Major | core |
| [PHOENIX-6586](
https://issues.apache.org/jira/browse/PHOENIX-6586) | Set NORMALIZATION\_ENABLED to false on salted tables | Critical | core |
| [PHOENIX-6583](
https://issues.apache.org/jira/browse/PHOENIX-6583) | Inserting explicit Null into a (fixed length) binary field is stored as an array of zeroes | Major | core |
| [PHOENIX-6555](
https://issues.apache.org/jira/browse/PHOENIX-6555) | Wait for permissions to sync in Permission tests | Major | core |
| [PHOENIX-6577](
https://issues.apache.org/jira/browse/PHOENIX-6577) | phoenix\_sandbox.py incompatible with python3 | Major | core |
| [PHOENIX-6578](
https://issues.apache.org/jira/browse/PHOENIX-6578) | sqlline.py cannot be started from source tree | Minor | core |
| [PHOENIX-6574](
https://issues.apache.org/jira/browse/PHOENIX-6574) | Executing "DROP TABLE" drops all sequences | Blocker | core |
| [PHOENIX-6568](
https://issues.apache.org/jira/browse/PHOENIX-6568) | NullPointerException in phoenix-queryserver-client not in phoenix-client-hbase | Major | core |
| [PHOENIX-6548](
https://issues.apache.org/jira/browse/PHOENIX-6548) | Race condition when triggering index rebuilds as regionserver closes | Minor | . |
| [PHOENIX-6563](
https://issues.apache.org/jira/browse/PHOENIX-6563) | Unable to use 'UPPER'/'LOWER' together with 'IN' | Major | core |
| [PHOENIX-6545](
https://issues.apache.org/jira/browse/PHOENIX-6545) | IndexToolForNonTxGlobalIndexIT.testIndexToolFailedMapperNotRecordToResultTable() fails with HBase 2.1 | Major | core |
| [PHOENIX-6546](
https://issues.apache.org/jira/browse/PHOENIX-6546) | BackwardCompatibilityIT#testSystemTaskCreationWithIndexAsyncRebuild is flakey | Major | core |
| [PHOENIX-6547](
https://issues.apache.org/jira/browse/PHOENIX-6547) | BasePermissionsIT is still a bit flakey | Major | core |
| [PHOENIX-6541](
https://issues.apache.org/jira/browse/PHOENIX-6541) | Use ROW\_TIMESTAMP column value as timestamps for conditional upsert mutations | Major | . |
| [PHOENIX-6543](
https://issues.apache.org/jira/browse/PHOENIX-6543) | de-flake AuditLoggingIT | Major | core |
| [PHOENIX-5072](
https://issues.apache.org/jira/browse/PHOENIX-5072) | Cursor Query Loops Eternally with Local Index, Returns Fine Without It | Major | . |
| [PHOENIX-6542](
https://issues.apache.org/jira/browse/PHOENIX-6542) | WALRecoveryRegionPostOpenIT is flakey | Major | core |
| [PHOENIX-6534](
https://issues.apache.org/jira/browse/PHOENIX-6534) | Upgrades from pre 4.10 versions are broken | Major | core |
| [PHOENIX-6486](
https://issues.apache.org/jira/browse/PHOENIX-6486) | Phoenix uses inconsistent chronologies internally, breaking pre-Gregorian date handling | Major | core |
| [PHOENIX-6472](
https://issues.apache.org/jira/browse/PHOENIX-6472) | In case of region inconsistency phoenix should stop gracefully | Major | . |
| [PHOENIX-6480](
https://issues.apache.org/jira/browse/PHOENIX-6480) | SchemaExtractionProcessor doesn't add IMMUTABLE\_STORAGE\_SCHEME and COLUMN\_ENCODED\_BYTES to the generated sql | Major | . |
| [PHOENIX-6506](
https://issues.apache.org/jira/browse/PHOENIX-6506) | Tenant Connection is not able to access/validate Global Sequences | Major | . |
| [PHOENIX-6476](
https://issues.apache.org/jira/browse/PHOENIX-6476) | Index tool when verifying from index to data doesn't correctly split page into tasks | Major | . |
| [PHOENIX-6515](
https://issues.apache.org/jira/browse/PHOENIX-6515) | Phoenix uses hbase-testing-util but does not list it as a dependency | Major | . |
| [PHOENIX-6507](
https://issues.apache.org/jira/browse/PHOENIX-6507) | DistinctAggregatingResultIterator should keep original tuple order of the AggregatingResultIterator | Major | . |
| [PHOENIX-6510](
https://issues.apache.org/jira/browse/PHOENIX-6510) | Double-Checked Locking field must be volatile | Major | . |
| [PHOENIX-6514](
https://issues.apache.org/jira/browse/PHOENIX-6514) | Exception should be thrown | Trivial | . |
| [PHOENIX-6509](
https://issues.apache.org/jira/browse/PHOENIX-6509) | Forward port PHOENIX-4424 Allow users to create "DEFAULT" and "HBASE" Schema (Uppercase Schema Names) | Major | core |
| [PHOENIX-6493](
https://issues.apache.org/jira/browse/PHOENIX-6493) | MetaData schemaPattern handling errors | Major | core |
| [PHOENIX-6453](
https://issues.apache.org/jira/browse/PHOENIX-6453) | Possible ArrayIndexOutOfBoundsException while preparing scan start key with multiple key range queries | Blocker | . |
| [PHOENIX-6479](
https://issues.apache.org/jira/browse/PHOENIX-6479) | Duplicate commons-io dependency in phoenix-pherf | Trivial | . |
| [PHOENIX-6475](
https://issues.apache.org/jira/browse/PHOENIX-6475) | Build failure on Linux ARM64 | Major | core |
| [PHOENIX-6420](
https://issues.apache.org/jira/browse/PHOENIX-6420) | Wrong result when conditional and regular upserts are passed in the same commit batch | Major | . |
| [PHOENIX-6471](
https://issues.apache.org/jira/browse/PHOENIX-6471) | Revert PHOENIX-5387 to remove unneeded CPL 1.0 license | Blocker | . |
| [PHOENIX-6442](
https://issues.apache.org/jira/browse/PHOENIX-6442) | Phoenix should depend on the appropriate tephra-hbase-compat-x.y module | Major | core, tephra |
| [PHOENIX-6437](
https://issues.apache.org/jira/browse/PHOENIX-6437) | Delete marker for parent-child rows does not get replicated via SystemCatalogWALEntryFilter | Major | core |
| [PHOENIX-6351](
https://issues.apache.org/jira/browse/PHOENIX-6351) | PhoenixMRJobUtil getActiveResourceManagerAddress logic fails on pseudodistributed cluster | Minor | core |
| [PHOENIX-6447](
https://issues.apache.org/jira/browse/PHOENIX-6447) | Add support for SYSTEM.CHILD\_LINK table in systemcatalogwalentryfilter | Major | core |
| [PHOENIX-6452](
https://issues.apache.org/jira/browse/PHOENIX-6452) | cache-apache-client-artifact.sh stopped working | Critical | core |
| [PHOENIX-6427](
https://issues.apache.org/jira/browse/PHOENIX-6427) | Create sequence fails in lowercase schema | Major | core |
| [PHOENIX-6424](
https://issues.apache.org/jira/browse/PHOENIX-6424) | SELECT cf1.\* FAILS with a WHERE clause including cf2. | Major | . |
| [PHOENIX-6421](
https://issues.apache.org/jira/browse/PHOENIX-6421) | Selecting an indexed array value from an uncovered column with local index returns NULL | Major | . |
| [PHOENIX-6423](
https://issues.apache.org/jira/browse/PHOENIX-6423) | Wildcard queries fail with mixed default and explicit column families. | Critical | . |
| [PHOENIX-6419](
https://issues.apache.org/jira/browse/PHOENIX-6419) | Unused getResolverForQuery() in QueryCompiler.verifySCN() | Trivial | core |
| [PHOENIX-6400](
https://issues.apache.org/jira/browse/PHOENIX-6400) | Do no use local index with uncovered columns in the WHERE clause. | Blocker | . |
| [PHOENIX-6386](
https://issues.apache.org/jira/browse/PHOENIX-6386) | Bulkload generates unverified index rows | Major | core |
| [PHOENIX-6343](
https://issues.apache.org/jira/browse/PHOENIX-6343) | Phoenix allows duplicate column names when one of them is a primary key | Major | core |
| [PHOENIX-6382](
https://issues.apache.org/jira/browse/PHOENIX-6382) | Shaded artifact names and descriptions have unresolved ${hbase.profile} strings | Major | core |
| [PHOENIX-6377](
https://issues.apache.org/jira/browse/PHOENIX-6377) | phoenix-client has erronous maven dependecies | Critical | core |
| [PHOENIX-6350](
https://issues.apache.org/jira/browse/PHOENIX-6350) | Build failure on phoenix master branch | Major | . |
### TESTS:
| JIRA | Summary | Priority | Component |
|:---- |:---- | :--- |:---- |
| [PHOENIX-6653](
https://issues.apache.org/jira/browse/PHOENIX-6653) | Add upgrade tests based on HBase snapshots | Major | core |
| [PHOENIX-6483](
https://issues.apache.org/jira/browse/PHOENIX-6483) | Flakes in BasePermissionsIT and AuditLoggingIT | Major | . |
| [PHOENIX-6482](
https://issues.apache.org/jira/browse/PHOENIX-6482) | PherfMainIT#testPherfMain is consistently failing | Major | . |
### SUB-TASKS:
| JIRA | Summary | Priority | Component |
|:---- |:---- | :--- |:---- |
| [PHOENIX-7028](
https://issues.apache.org/jira/browse/PHOENIX-7028) | Annotate client initiated Scan with metadata attributes | Major | . |
| [PHOENIX-7029](
https://issues.apache.org/jira/browse/PHOENIX-7029) | Add support for multiple query services in PhoenixTestDriver. | Major | . |
| [PHOENIX-6989](
https://issues.apache.org/jira/browse/PHOENIX-6989) | Expose server side metrics for DDL operations | Major | . |
| [PHOENIX-6985](
https://issues.apache.org/jira/browse/PHOENIX-6985) | Setting server-side masking flag default to false | Major | . |
| [PHOENIX-6963](
https://issues.apache.org/jira/browse/PHOENIX-6963) | Check if LAST\_DDL\_TIMESTAMP is set for tables and indexes created before PHOENIX-6186 | Major | core |
| [PHOENIX-5521](
https://issues.apache.org/jira/browse/PHOENIX-5521) | Phoenix-level HBase Replication sink (Endpoint coproc) | Major | . |
| [PHOENIX-6932](
https://issues.apache.org/jira/browse/PHOENIX-6932) | Update LAST\_DDL\_TIMESTAMP for index table when add/drop/alter indexes. | Major | . |
| [PHOENIX-6930](
https://issues.apache.org/jira/browse/PHOENIX-6930) | Update LAST\_DDL\_TIMESTAMP for table/view when we alter properties on table/view | Major | core |
| [PHOENIX-6649](
https://issues.apache.org/jira/browse/PHOENIX-6649) | TransformTool should transform the tenant view content as well | Major | . |
| [PHOENIX-6790](
https://issues.apache.org/jira/browse/PHOENIX-6790) | Phoenix 5.2 HBase 2.5 profile to include missing zookeeper dependency | Major | . |
| [PHOENIX-6627](
https://issues.apache.org/jira/browse/PHOENIX-6627) | Remove all references to Tephra from 4.x and master | Major | 4.x, tephra |
| [PHOENIX-5419](
https://issues.apache.org/jira/browse/PHOENIX-5419) | Cleanup anonymous class in TracingQueryPlan | Minor | . |
| [PHOENIX-6711](
https://issues.apache.org/jira/browse/PHOENIX-6711) | Add support of skipping the system tables existence check during connection initialisation | Major | . |
| [PHOENIX-6685](
https://issues.apache.org/jira/browse/PHOENIX-6685) | Change Data Capture - Populate Table / Topic Mappings | Major | . |
| [PHOENIX-6626](
https://issues.apache.org/jira/browse/PHOENIX-6626) | Make the without.tephra profile behaviour the default in 4.x and master, and remove the profile | Major | core, tephra |
| [PHOENIX-6639](
https://issues.apache.org/jira/browse/PHOENIX-6639) | Read repair of a table after cutover (transform is complete and table is switched) | Major | . |
| [PHOENIX-6622](
https://issues.apache.org/jira/browse/PHOENIX-6622) | TransformMonitor should orchestrate transform and do retries | Major | . |
| [PHOENIX-6620](
https://issues.apache.org/jira/browse/PHOENIX-6620) | TransformTool should fix the unverified rows and do validation | Major | . |
| [PHOENIX-6617](
https://issues.apache.org/jira/browse/PHOENIX-6617) | IndexRegionObserver should create mutations for the transforming table | Major | . |
| [PHOENIX-6612](
https://issues.apache.org/jira/browse/PHOENIX-6612) | Add TransformTool | Major | . |
| [PHOENIX-6603](
https://issues.apache.org/jira/browse/PHOENIX-6603) | Create SYSTEM.TRANSFORM table | Major | . |
| [PHOENIX-6589](
https://issues.apache.org/jira/browse/PHOENIX-6589) | Add metrics for schema registry export | Major | . |
| [PHOENIX-6227](
https://issues.apache.org/jira/browse/PHOENIX-6227) | Option for DDL changes to export to external schema repository | Major | . |
| [PHOENIX-6417](
https://issues.apache.org/jira/browse/PHOENIX-6417) | Fix PHERF ITs that are failing in the local builds | Minor | . |
| [PHOENIX-6118](
https://issues.apache.org/jira/browse/PHOENIX-6118) | Multi Tenant Workloads using PHERF | Major | . |
| [PHOENIX-6429](
https://issues.apache.org/jira/browse/PHOENIX-6429) | Add support for global connections and sequential data generators | Major | . |
| [PHOENIX-6430](
https://issues.apache.org/jira/browse/PHOENIX-6430) | Add support for full row update for tables when no columns specfied in scenario | Major | . |
| [PHOENIX-6431](
https://issues.apache.org/jira/browse/PHOENIX-6431) | Add support for auto assigning pmfs | Major | . |
| [PHOENIX-6432](
https://issues.apache.org/jira/browse/PHOENIX-6432) | Add support for additional load generators | Major | . |
| [PHOENIX-6397](
https://issues.apache.org/jira/browse/PHOENIX-6397) | Implement TableMetricsManager class and its associated functions for select. upsert and Delete Queries | Major | . |
| [PHOENIX-6408](
https://issues.apache.org/jira/browse/PHOENIX-6408) | LIMIT on local index query with uncovered columns in the WHERE returns wrong result. | Major | . |
| [PHOENIX-6379](
https://issues.apache.org/jira/browse/PHOENIX-6379) | Implement a new Metric Type which will be used for TableMetrics | Major | . |
### OTHER:
| JIRA | Summary | Priority | Component |
|:---- |:---- | :--- |:---- |
| [PHOENIX-6436](
https://issues.apache.org/jira/browse/PHOENIX-6436) | OrderedResultIterator overestimates memory requirements. | Major | . |
| [PHOENIX-7189](
https://issues.apache.org/jira/browse/PHOENIX-7189) | Update Omid to 1.1.1 | Blocker | core |
| [PHOENIX-7179](
https://issues.apache.org/jira/browse/PHOENIX-7179) | Remove HBase 2.3 leftover files | Major | . |
| [PHOENIX-7173](
https://issues.apache.org/jira/browse/PHOENIX-7173) | Update default HBase versions to 2.4.17 and 2.5.7 respectively | Major | core |
| [PHOENIX-7082](
https://issues.apache.org/jira/browse/PHOENIX-7082) | Upgrade Jetty to 9.4.53.v20231009 | Major | core, queryserver |
| [PHOENIX-7027](
https://issues.apache.org/jira/browse/PHOENIX-7027) | Add compatibility module for Hbase 2.5.4 and upgrade Hbase version to 2.5.5 | Major | . |
| [PHOENIX-6866](
https://issues.apache.org/jira/browse/PHOENIX-6866) | Upgrade hbase 2.4 and 2.5 versions to 2.4.16 and 2.5.3-hadoop3 respectively | Major | . |
| [PHOENIX-6816](
https://issues.apache.org/jira/browse/PHOENIX-6816) | Update Jetty to 9.4.49.v20220914 | Major | . |
| [PHOENIX-6815](
https://issues.apache.org/jira/browse/PHOENIX-6815) | Update Gson version to 2.9.1 | Major | . |
| [PHOENIX-6715](
https://issues.apache.org/jira/browse/PHOENIX-6715) | Update Omid to 1.1.0 | Major | core |
| [PHOENIX-6805](
https://issues.apache.org/jira/browse/PHOENIX-6805) | Update release scripts for Omid 1.1.0 | Major | . |
| [PHOENIX-6485](
https://issues.apache.org/jira/browse/PHOENIX-6485) | Clean up classpath in .py scripts | Major | . |
| [PHOENIX-6753](
https://issues.apache.org/jira/browse/PHOENIX-6753) | Update default HBase 2.4 version to 2.4.13 | Major | . |
| [PHOENIX-6695](
https://issues.apache.org/jira/browse/PHOENIX-6695) | Switch default logging backend to log4j2 | Major | core |
| [PHOENIX-6693](
https://issues.apache.org/jira/browse/PHOENIX-6693) | Remove Hbase 2.1 and Hbase 2.2 support from Phoenix | Major | core |
| [PHOENIX-6696](
https://issues.apache.org/jira/browse/PHOENIX-6696) | Drop legacy phoenix-client jar | Major | core |
| [PHOENIX-6697](
https://issues.apache.org/jira/browse/PHOENIX-6697) | log4j-reload4j is missing from phoenix-assembly | Major | . |
| [PHOENIX-6582](
https://issues.apache.org/jira/browse/PHOENIX-6582) | Bump default HBase version to 2.3.7 and 2.4.8 | Major | . |
| [PHOENIX-6558](
https://issues.apache.org/jira/browse/PHOENIX-6558) | Update SpotBugs | Major | core |
| [PHOENIX-6557](
https://issues.apache.org/jira/browse/PHOENIX-6557) | Fix code problems flagged by SpotBugs as High priority | Major | core |
| [PHOENIX-6537](
https://issues.apache.org/jira/browse/PHOENIX-6537) | Fix CI pipeline and upgrade Yetus | Major | . |
| [PHOENIX-6551](
https://issues.apache.org/jira/browse/PHOENIX-6551) | Bump HBase version to 2.4.6 and 2.2.7 | Major | core |
| [PHOENIX-6550](
https://issues.apache.org/jira/browse/PHOENIX-6550) | Upgrade jetty, jackson and commons-io | Major | core |
| [PHOENIX-6526](
https://issues.apache.org/jira/browse/PHOENIX-6526) | Bump default HBase version on 2.3 profile to 2.3.6 | Major | . |
| [PHOENIX-6519](
https://issues.apache.org/jira/browse/PHOENIX-6519) | Make SchemaTool work with lower case table and column names | Major | core |
| [PHOENIX-6518](
https://issues.apache.org/jira/browse/PHOENIX-6518) | Implement SHOW CREATE TABLE SQL command | Major | core |
| [PHOENIX-6502](
https://issues.apache.org/jira/browse/PHOENIX-6502) | Bump default HBase version on 2.4 profile to 2.4.4 | Major | . |
| [PHOENIX-6456](
https://issues.apache.org/jira/browse/PHOENIX-6456) | Support query logging for DDL and DML | Major | core |
| [PHOENIX-6451](
https://issues.apache.org/jira/browse/PHOENIX-6451) | Update joni and jcodings versions | Major | . |
| [PHOENIX-6446](
https://issues.apache.org/jira/browse/PHOENIX-6446) | Bump default HBase version on 2.3 profile to 2.3.5 | Major | . |
| [PHOENIX-6418](
https://issues.apache.org/jira/browse/PHOENIX-6418) | Bump default HBase version on 2.4 profile to 2.4.2 | Major | . |
| [PHOENIX-6376](
https://issues.apache.org/jira/browse/PHOENIX-6376) | Update MetaDataProtocol.java for Phoenix 5.2 | Blocker | core |
| [PHOENIX-6394](
https://issues.apache.org/jira/browse/PHOENIX-6394) | PostCommit Jenkins job detects incorrect HBase profile to rebuild with 2.3 and 2.4 | Major | . |
| [PHOENIX-6359](
https://issues.apache.org/jira/browse/PHOENIX-6359) | New module to support HBase 2.4.1+ releases | Major | . |
| [PHOENIX-6371](
https://issues.apache.org/jira/browse/PHOENIX-6371) | Script to verify release candidate | Major | . |
