Phoenix
This release provides Phoenix 4.7.0 and the following Apache patches:
PHOENIX-3710: Cannot use lowername data table name with indextool.
PHOENIX-3756: Handle users lacking ADMIN for the SYSTEM namespace.
PHOENIX-3759: Dropping all local index causes NPE during compaction.
PHOENIX-3800: NPE when doing UPSERT SELECT into salted tables.
PHOENIX-3833: Handle users lacking ADMIN from failing in system schema creation.
PHOENIX-3842: Turn off all BloomFilter for Phoenix tables (Lars Hofhansl).
PHOENIX-3843: Improve logging for UNION ALL errors.
HDP 2.6.0 provides Phoenix 4.7.0 and the following Apache patches:
PHOENIX-86: UDF testing in phoenix is failing with NoSuchMethodError.
PHOENIX-117: Phoenix is failing to establish connection on secure envs with NoClassDefFoundError.
PHOENIX-118: Remove very chatty logging and add notification around cache evictions.
PHOENIX-930: duplicated columns cause query exception and drop table exception (Junegunn Choi, Kalyan Hadoop).
PHOENIX-1523: Make it easy to provide a tab literal as separator for CSV imports.
PHOENIX-1754: Try to handle keytab paths on Windows filesystems.
PHOENIX-2276: Addednum2 to fix test failures.
PHOENIX-2276: addendum for fixing test failures.
PHOENIX-2276: Creating index on a global view on a multi-tenant table fails with NPE.
PHOENIX-2276: Fix test failure.
PHOENIX-2743: HivePhoenixHandler for big-big join with predicate push down.
PHOENIX-2748: Disable auto-commit during bulk load.
PHOENIX-2758: Ordered GROUP BY not occurring with leading PK equality expression.
PHOENIX-2784: phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames(Josh Mahonin).
PHOENIX-2803: Initializing ToCharFunction with the List <Expression> constructor fails.
PHOENIX-2817: Phoenix-Spark plugin doesn't work in secured env.
PHOENIX-2820: Investigate why SortMergeJoinIT has a sort in the explain plan.
PHOENIX-2828: Ordinality should be 1-based in UNNEST WITH ORDINALITY.
PHOENIX-2845: Timestamp ignores nanos in literal expressions.
PHOENIX-2856: HBaseManagedTimeTableReuseTest category isn't getting run.
PHOENIX-2871: Workaround sqlline issue.
PHOENIX-2878: CURRENT_TIME fails to provide correct time when projected table is using.
PHOENIX-2886: Union ALL with Char column not present in the table in Query 1 but in Query 2 throw exception (Alicia Ying Shu).
PHOENIX-2890: Extend IndexTool to allow incremental index rebuilds.
PHOENIX-2894: Sort-merge join works incorrectly with DESC columns.
PHOENIX-2898: HTable not closed in ConnectionQueryServicesImpl (Alex Araujo).
PHOENIX-2900: Unable to find hash cache once a salted table 's first region has split (chenglei).
PHOENIX-2905: hadoop-2.5.1 artifacts are in the dependency tree.
PHOENIX-2908: phoenix-core depends on both antlr 3.5 and antlr 2.7.7 (William Yang).
PHOENIX-2912: Broken IT tests after PHOENIX-2905.
PHOENIX-2919: PreparedStatement Returns Incorrect Number of Deleted Records.
PHOENIX-2920: Incorrect Queries on Multi-tenant tables with WHERE clause containing Row Value Constructor.
PHOENIX-2930: Cannot resolve columns aliased to its own name.
PHOENIX-2934: Checking a coerce expression at top level should not be necessary for Union All query (Alicia Ying Shu).
PHOENIX-2935: IndexMetaData cache can expire when a delete and or query running on server.
PHOENIX-2936: Missing antlr runtime on server side after PHOENIX-2908.
PHOENIX-2940: Query the stats table and cache stats in the client.
PHOENIX-2942: Order by incorrect for RVC.
PHOENIX-2952: Addendum to fix test case failure (Ram).
PHOENIX-2952: array_length return negative value (Joseph Sun).
PHOENIX-2961: select on a composite primary key fails when DESC is set in the table.
PHOENIX-2983: ClassCastException on auto coerce of BIGINT to DECIMAL.
PHOENIX-2994: Coalesce function may return null.
PHOENIX-3004: Allow configuration in hbase-site to define realms other than the server's.
PHOENIX-3006: Fix all ScalarFunctions to implement clone(List) or <init> (List). (James Taylor & Lars Hofhansl).
PHOENIX-3008: Prevent upgrade of existing multi-tenant table to map to namespace until we support it correctly.
PHOENIX-3011: Fix missing apache licenses.
PHOENIX-3013: TO_CHAR fails to handle indexed null value (Junegunn Choi).
PHOENIX-3014: SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results with salted tables..
PHOENIX-3015: Any metadata changes may cause unpredictable result when local indexes are using.
PHOENIX-3021: Using local index during compaction is producing NPE.
PHOENIX-3057: Set incremental=false for sqlline-thin.
PHOENIX-3078:. Hive storage handler does not work if phoenix.table.name contains the schema name.
PHOENIX-3126: Tie a driver instance to a specific user (Prabhjyot Singh).
PHOENIX-3134: Ingestion of VARBINARY data should fail when data is not base64-encoded varbinary fields bulk load difference between MR/psql and upserts.
PHOENIX-3136: Do not relocate org.apache.calcite in queryserver/thin-client.
PHOENIX-3149: Local index got corrupted if intermediate compaction happen during the split..
PHOENIX-3152: Incorrect comparator in QueryOptimizer may cause IllegalArgumentException.
PHOENIX-3161: Improve performance of automatic index rebuilding.
PHOENIX-3164: Cache UGI instances for remote users in PQS.
PHOENIX-3189: Perform Kerberos login before ConnectionInfo is constructed.
PHOENIX-3199: ServerCacheClient sends cache to all regions unnecessarily (chenglei).
PHOENIX-3223: Add `hadoop classpath` to PQS classpath when available.
PHOENIX-3236: Problem with shading apache commons on Azure..
PHOENIX-3241: Support both DATE and TIMESTAMP in CONVERT_TZ().
PHOENIX-32451: Support both DATE and TIMESTAMP in CONVERT_TZ().
PHOENIX-3246: Treat U+2002 as whitespace in parser.
PHOENIX-3271: Distribute UPSERT SELECT across cluster.
PHOENIX-3280: Automatic attempt to rebuild all disabled index(James Taylor).
PHOENIX-3346: Hive PhoenixStorageHandler doesn't work well with column.
PHOENIX-3386: PhoenixStorageHandler throws NPE if local tasks executed via child.
PHOENIX-3387: Hive PhoenixStorageHandler fails with join on numeric fields.
PHOENIX-3408: arithmetic/mathematical operations with Decimal columns failed in Hive with PheonixStorageHandler..
PHOENIX-3416: Memory leak in PhoenixStorageHandler.
PHOENIX-3422: PhoenixQueryBuilder doesn't make value string correctly for char(/varchar) column type..
PHOENIX-3423: PhoenixObjectInspector doesn't have information on length of the column..
PHOENIX-3486: RoundRobinResultIterator doesn't work correctly because of setting Scan's cache size inappropriately in PhoenixInputForamt.
PHOENIX-3490: PhoenixStorageHandler doesn't handler hbase configuration properly and don't work in secured env.
PHOENIX-3499: Enable null value for quote character for CSVBulkLoad tool.
PHOENIX-3503: PhoenixStorageHandler doesn't work properly when execution engine of Hive is Tez..
PHOENIX-3504: Spark integration doesn't work with decimal columns that are using default precision.
PHOENIX-3505: Avoid NPE on close() in OrderedResultIterator.
PHOENIX-3512: PhoenixStorageHandler makes erroneous query string when handling between clauses with date constants..
PHOENIX-3521: Scan over local index may return incorrect result after flush & compaction.
PHOENIX-3540: BUG-70567 Fix Time data type in Phoenix Spark integration.
PHOENIX-3544: Fix UNSIGNED_DATE and UNSIGNED_TIME type in phoenix-spark.
PHOENIX-3565: Set failIfNoTests=false on surefire and failsafe.
PHOENIX-3608: KeyRange interset should return EMPTY_RANGE when one of it is NULL_RANGE(Rajeshbabu).
PHOENIX-3609: Detect and fix corrupted local index region during compaction.
PHOENIX-3610: Fix tableName used to get the index maintainers while creating HalfStoreFileReader for local index store.
PHOENIX-3652: User requires all Create privilege on 'default' namespace (Ankit Singhal).
PHOENIX-3662: PhoenixStorageHandler throws ClassCastException (by Jeongdae Kim).
PHOENIX-3684: Handle _HOST in principal specified in JDBC url.
PHOENIX-3686: Allow client-authentication to be disabled for PQS.
PHOENIX-3694: Drop schema does not invalidate schema from the server cache.
PHOENIX-3698: No-args constructor for IndexedWALEditCodec.
PHOENIX-3708: Tests introduced in PHOENIX-3346 doesn't work well with failsafe plugin.