Phoenix 4.2.0
HDP 2.2.9 provides Apache Phoenix 4.2.0 and the following additional Apache patches:
PHOENIX-1560: Join between global index and data table if INDEX hint used.
PHOENIX-1980: CsvBulkLoad cannot load hbase-site.xml from classpath.
PHOENIX-2005: Connection utilities omit zk client port, parent znode.
PHOENIX-2007: java.sql.SQLException: Encountered exception in sub plan [0] execution.
PHOENIX-2030: CsvBulkLoadTool should use logical name of the table for output directory suffix.
PHOENIX-2031: Unable to process timestamp/Date data loaded via Phoenix org.apache.phoenix.pig.PhoenixHBaseLoader:w.
PHOENIX-2313: TypeMismatchException thrown while querying a table that has an index with a Boolean.
PHOENIX-2372: Check for null before passing value to Calendar.
HDP 2.2.8 provided Apache Phoenix 4.2.0 and the following additional Apache patches:
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 phoenix 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 phoenix 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: Date columns should be displayed without timezone offset.
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 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
PHOENIX-18: Several tests are failing with SequenceNotFoundException error
PHOENIX-32: Some phoenix tests are failing with different assertion errors