3.9. Phoenix 4.2.0

HDP 2.2.6 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