HDP 2.2.4 includes Apache Phoenix 4.2.0 and the following additional Apache patches:
PHOENIX-18 Several tests are failing with SequenceNotFoundException error
PHOENIX-32 Some phoenix tests are failing with different assertion errors
PHOENIX-1248 CsvBulkLoadTool is failing with IAE when local index specified for --index-table parameter
PHOENIX-1336 Exception when select from local index:Cache of region boundaries are out of date
PHOENIX-1346 the choice of index by phoneix is not correct where do querying
PHOENIX-1362 Min/max aggregate query on CHAR and BINARY types always return null
PHOENIX-1427 Reduce work in StatsCollector
PHOENIX-1428 Queries with limit against tenant views is broken
PHOENIX-1429 Cancel queued threads when limit reached
PHOENIX-1431 DELETE using Subqueries
PHOENIX-1436 the choice of index by phoneix is not correct where do querying
PHOENIX-1446 Add/fix logging for LIMIT optimization
PHOENIX-1447 Increase guidepost width default to take into account FAST_DIFF compression
PHOENIX-1448 Fix resource leak when work rejected by thread executor
PHOENIX-1449 Fix PropertiesUtil.deepCopy()
PHOENIX-1455 Replace org.xerial.snappy with org.iq80.snappy pure Java snappy implementation
PHOENIX-1456 Incorrect query results caused by reusing buffers in SpoolingResultIterator
PHOENIX-1462 Create unit test for COUNT DISTINCT using compression (Ram)
PHOENIX-1463 phoenix.query.timeoutMs doesn't work as expected
PHOENIX-1466 Prevent multiple scans when query run serially
PHOENIX-1467 Upgrade to 4.12 Junit and update tests by removing @Category annotation
PHOENIX-1468 Add org.iq80.snappy to client and server assemblies
PHOENIX-1469 Binary columns do not work correctly for indexing
PHOENIX-1472 Fix salt bucket for Integer.MIN_VALUE
PHOENIX-1473 Connecting with Phoenix client when Phoenix is not deployed on region server(s) takes down region server(s)
PHOENIX-1474 NPE when RVC between combined with key part comparison
PHOENIX-1476 Immediately open scanner for parallel queries
PHOENIX-1477: Phoenix 4.0 -> 4.2 upgrade doesn't work
PHOENIX-1480 Incorrect query results may occur when VIEW uses indexes from physical table
PHOENIX-1484 Index creation failed due to specifying DEFAULT_COLUMN_FAMILY option
PHOENIX-1485 Correct arg count in FunctionParseNode
PHOENIX-1485 Add timezone awareness
PHOENIX-1486 Fix SpooledTmpFileDeleteIT by having it use a different directory for spooling files
PHOENIX-1498 Turn KEEP_DELETED_CELLS off by default
PHOENIX-1500 Disallow mutations and queries using using PhoenixPreparedStatement.executeQuery() and executeUpdate() respectively
PHOENIX-1503 - Compilation on Mac OS fails on maven-assembly-plugin
PHOENIX-1532 Phoenix tarball assembly does not include server jar
PHOENIX-1533 Last key part not taken into child/parent optimization
PHOENIX-1537 Set reuseForks to false for integration tests
PHOENIX-1551 Upgrading from Phoenix 4.0.x to 4.2.2 and throw can't find SYSTEM.STATS
PHOENIX-1571 Replace hard-coded date
PHOENIX-1575 Identical sql type values for UNSIGNED_TIMESTAMP and UNSIGNED_DATE
PHOENIX-1592 ORDER BY not closing ResultIterator properly
PHOENIX-1596 Turning tracing on causes region servers to crash
PHOENIX-1601 - Performance.py script not working in binary distribution