Hive changelog for Cloudera Data Warehouse on cloud

2025.0.20.0 (October 22, 2025)

• CDPD-90303: HIVE-24902: Incorrect result after fold CASE into COALESCE
• CDPD-90301: HIVE-29208: Infinite loop while compiling query with filter predicate containing disjuncts on the same expression
• CDPD-89414: HIVE-29122: Vectorization - Support IGNORE NULLS for FIRST_VALUE and LAST_VALUE [ADDENDUM]
• CDPD-89008: HIVE-28667: Error initializing field trimmer instance when starting HS2
• CDPD-84329:HIVE-25621: Added HivePrivilegeObjects for the commands Alter table merge/concatenate
• CDPD-81564: HIVE-28880: Wrong result when output column in a vectorized expression is used as a scratch column by a child
• CDPD-88776: HIVE-27943: NPE in VectorMapJoinCommonOperator.setUpHashTable when running query with join on date
• CDPD-88849: HIVE-28222: Ambiguous table alias exception for queries with self joins
• CDPD-88266: CVE-2023-2976: Update guava version to 32.1.2-jre
• CDPD-88166: HIVE-25356: JDBCSplitFilterAboveJoinRule's onMatch method throws exception
• CDPD-88550: HIVE-29118: Remove extra metadata calls if coloring is not needed
• CDPD-87962: HIVE-28944: Mask File, data sizes in tests
• CDPD-87962: HIVE-27791: Eliminate totalSize check from test
• CDPD-87962: HIVE-25629: Drop support of multiple qfiles in QTestUtil, output and result processors
• CDPD-76544: (Addendum) Upgrading library mysql-connector-j to version 8.2.0 for fixing CVE-2023-22102
• DWX-20179: Set default UTC timezone in chainguard based hive-arm image
• DWX-18878: Chainguard base image update hive-arm
• DWX-20179: Set default UTC timezone in chainguard based hive image
• DWX-18878: Chainguard base image update: hive
• CDPD-87908: HIVE-21786: Update repo URLs in poms
• CDPD-85193:HIVE-15984: Add support for ALTER TABLE DROP COLUMN
• CDPD-87425: Backport HIVE-29047 Adjust httpclient5 httpcore dependencies in TestHttpServices
• CDPD-79722: HIVE-28417: Addendum: Bump Log4j2 to 2.24.3
• CDPD-79722: HIVE-28656: Improve HPL/SQL tests
• CDPD-79722: HIVE-28417: Bump Log4j2 to 2.24.3
• CDPD-83461: HIVE-29029: ClassCastException when compiling query with STACK UDTF in multiple UNION ALL branches
• CDPD-87800: HIVE-28838: Remove sensitive jdbc properties from explain plan
• CDPD-87648: HIVE-28625: (Addendum) Missing Qfile changes to support parquet rebase
• CDPD-67002: HIVE-28790: ACID deletes are failing with ArrayIndexOutOfBoundsException when direct insert is enabled
• CDPD-87275 : HIVE-28848 : Remove DFS_URI auth from ALTER_PARTITION if there is no change in partition location
• CDPD-87648: Changes required for Parquet rebase to 1.15.1
• CDPD-76830: HIVE-28778: Support Secure Zookeeper Access in Hive SecretManager
• CDPD-87178: Hive-28736 Remove DFS_URI authorization in HMS for CREATE_TABLE event with no explicit LOCATION
• CDPD-61693: HIVE-25351: stddev(), stddev_pop() return NaN when CBO is enabled
• CDPD-87545: HIVE-29055: TestHplSqlViaBeeLine#testHplSqlExitConditionHandler is broken and passes silently
• CDPD-85455:HIVE-28957: Enhance TestHiveMetaStoreAuthorizer
• CDPD-68219: Upgrade CDWH stack to Calcite 1.33.0 BUILD_CUSTOM_CALCITE:zabetak:cdw-master-133 SKIP_POM_PATCH
• CDPD-84078:HIVE-25879: MetaStoreDirectSql test query should not query the whole DBS table
• CDPD-76810: Enable the dynamic election for HMS leader
• CDPD-85152: ALTER TABLE PARTITION CHANGE COLUMN fails with Oracle backed Hive Metastore
• DWX-21150: download_dep_tars.sh: fetch CDH_PREFIX automatically according to hadoop.version in pom.xml
• CDPD-85405: HIVE-22923: Extract cumulative cost metadata from HiveRelMdDistinctRowCount metadata provider
• CDPD-84629: HIVE-28917: NPE in merge statement when checking nullability of joining column in matched clause
• CDPD-84344: HIVE-28990: Collecting the non-native summary can be slow to raise the timeout
• CDPD-84531: HIVE-28839: Connection starvation in HMS if datanucleus value generation fails
• DWX-21177:HIVE-28147:Upgrade commons-compress to 1.26.0
• CDPD-84216: HIVE-28075: Vectorized DayOFWeek returns inconsistent results for non-UTC timezones
• CDPD-79913: HIVE-28668: Hive should emit fewer events for truncate table operation
• CDPD-82632: HIVE-28134: Backport the fix for CVE-2024-29869 Improve SecureCmdDoAs.
• CDPD-78409: hive-Backport fix for CVE-2024-23945 Refactor Some Code.
• CDPD-84043: HIVE-28972: HMS performace degradation post HIVE-28909 for alter query
• CDPD-83828: HIVE-28781: Hive shouldn't disable IPv6 stack.
• CDPD-84192: HIVE-25046: Log CBO plans right after major transformations
• CDPD-84191: HIVE-26627: Remove HiveRelBuilder.aggregateCall override and refactor callers to use existing public methods
• CDPD-84189: HIVE-28492: Upgrade Janino version to 3.1.12
• CDPD-84188: HIVE-28360: Upgrade jersey to 1.19.4
• CDPD-82308: HIVE-28913: A delegation token must be issued for the proxy user while reconnecting to Metastore.
• CDPD-81431: HIVE-28460: (Addendum) Determine the database type once the PersistenceManagerFactory created
• DWX-21140: Remove bigtop-hive script from hive image
• CDPD-81145:HIVE-28846: change ifExist default value to be true
• DWX-15276: Hive Dockerfile: force using https mirrors
• CDPD-82994: HIVE-28912: Add catalog name for CommitCompaction and
• CDPD-83530: HIVE-28962: Prevent committing outputs if an exception was thrown in the Tez processor
• CDPD-82597: HIVE-28960: Compaction Stats updater does not collect column stats when hive.stats.autogather is true
• CDPD-81683: Metadata Summary differs between oracle and other dbs
• CDPD-77993: match parquet-hadoop version with downstream
• CDPD-82630: HIVE-28947: Add ability to specify Compaction options in stats updater of compactor
• CDPD-83065: HIVE-28953: Remove HiveMetaStoreClientPreCatalog
• DWX-19062 HIVE-28789: Session-level metrics from Tez sessions
• CDPD-82264: HIVE-28900: Make the objectstore-secondary connection pool size configurable
• CDPD-81420:HIVE-28898: add ownership information when invoking getTableMetas
• CDPD-82950 HIVE-28904: Remove Arrow from Hive SKIP_POM_PATCH
• CDPD-81032:HIVE-28921: Add API and implementation for retrieving database object
• CDPD-81431: HIVE-28460: Determine the database type once the PersistenceManagerFactory created
• CDPD-81079: HIVE-28824: Metastore should also respect the max thrift message size
• CDPD-76414: Make rawstore batch size default to 500 and direct sql batch size to 1000
• CDPD-75121:HIVE-28946:Upgrade commons-io to 2.16.1
• DWX-20754: HIVE-28938: Error in LATERAL VIEW with non native tables due to incorrect virtual columns
• CDPD-82907: HIVE-28146: Add positive event type filter to the HMS notification
• CDPD-82862: Remove getDefaultKuduMasterHosts() after IMPALA-14040
• CDPD-82696: HIVE-28653: Jetty version disclosure in Hive
• CDPD-82616:HIVE-28730: Upgrade aws-java-sdk to 1.12.720
• CDPD-82550: HIVE-28923: Clean up dummy RawStore-s
• DWX-20538: Change hive UID to 1000001 and remove hivehigh user
• CDPD-81861: HIVE-28881: Ambiguous column reference is not detected in GROUP BY query.
• CDPD-81860: HIVE-27291: Constant reduction in CBO does not work for UNIX_TIMESTAMP
• HIVE-28782: Ensure Hive constructs URI's with IPv6 literals safely
• CDPD-81384: HIVE-28788: ObjectStore failed to commit the transaction could lead to connection starvation
• DWX-20657: HIVE-28886: CalcitePlanner throws NullPointerException when column name case in ColumnStatisticsObj differs from the table schema
• CDPD-80424: Upgrade json-smart and resolve CVE-2015-5237 for Hive
• CDPD-81829 HIVE-28802: NPE in MiniHS2 with miniHS2.clusterType=LOCALFS_ONLYns
• CDPD-81735: HIVE-28782: Avoid unsafe splits on URIs that might contain IPv6 literals)
• DWX-20242:HIVE-28856: Remove Jetty-Runner
• CDPD-58428: HIVE-27078: Bucket Map Join can hang if the source vertex parallelism is changed by reducer autoparallelism.
• CDPD-80655: HIVE-28878: Query with window function and redundant GROUP BY key fails during compilation
• DWX-20702:HIVE-28030: LLAP util code refactor to fix CVE-2024-23953.
• CDPD-60770:HIVE-28805: reparse password from JDBC url
• CDPD-80448: Upgrade com.fasterxml.jackson.core:jackson-core and resolve CVE-2020-36518 for Hive
• CDPD-80428: HIVE-28040: Upgrade netty to 4.1.116.Final due to CVEs
• CDPD-80450: HIVE-28859: Upgrade commons-logging to 1.3.5 to fix CVEs
• CDPD-80433: Upgrade avro and resolve CVE-2024-47561 for Hive
• CDPD-76724: support static code analysis
• DWX-20652 HIVE-28868: Print AM hostname on console
• CDPD-78222: HIVE-28775: HiveServer2: Implement HA Health Check endpoint on a separate port from WebUI
• CDPD-78222: HIVE-23548 : TestActivePassiveHA is unstable
• CDPD-81220: Do not install openssl10 in FENG docker image
• CDPD-80853: HIVE-28825: Support conversion of complex types to String
• CDPD-80750: HIVE-28815: Primitive common category for String and Boolean returns null causing NPE
• CDPD-81215: HIVE-28783: Refactor hardcoded IPv4 addresses to support dual-stack (IPv4/IPv6) networking
• CDPD-81008: HIVE-28768: Remove hardcoded post exec hooks
• DWX-20242:Exclude mina-core to fix CVE-2024-52046
• CDPD-80574: HIVE-28792: Wrong results when query has function call with char parameter type in case expression
• CDPD-64944: Switch to the methods with new signatures in UA
• CDPD-80045: HIVE-28803: Persist writeId as -1 instead of 0 during alter operation
• DWX-19422: Add user with UID 1000001 to hive image
• CDPD-80251 : Fix LD_LIBRARY_PATH for aarch64 type
• DWX-20248:Fix CVE-2024-23945 in CookieSigner
• CDPD-74618: HIVE-28779: Add ozone filesystem to the exim uri schema whitelist.
• DWX-17664 HIVE-28095: Hive Query History
• CDPD-77626: HIVE-27530: (Addendum) Implement direct SQL for alter partitions to improve performance
• CDPD-79829: HIVE-28766: EXECUTE IMMEDIATE with load data into table query displays ERROR on the console.
• CDPD-79237: Hive Metastore Database Schema failed
• DWX-19713 HIVE-28626: Display MoveTask/StatsTask duration on the query summary
• CDPD-77626: HIVE-27530: Implement direct SQL for alter partitions to improve performance
• CDPD-79468: Excluded javax.el to remove CVE-2021-28170
• CDPD-79518: HIVE-20385 : Date: date + int fails to add days
• CDPD-79313: Use FileDescriptor after IMPALA-13739
• CDPD-75410: HIVE-23164 HIVE-25633 Server is not properly terminated because of non-daemon threads
• CDPD-78626: Upgrade velocity-engine-core in order to fix commons-io cve
• CDPD-77710: Set up 'fileMetadataStats' when instantiating HdfsPartition
• HIVE-27829 : New command "Show Processlist" to display current operations and related details in Hiveserver2
• DWX-20087:Upgrade Spring in Hive
• CDPD-78446: HIVE-28610: Upgrade commons-io in hive to fix cve
• DWX-20064: HIVE-28635: Fix logging format issues in ContainerRunnerImpl file
• DWX-19709: HIVE-28579: Add query id to HiveSQLException
• CDPD-78207 (Part 2): Update the golden files and re-enable the q tests
• CDPD-78238: HIVE-28572: Support Distribute by and Cluster by clauses in CBO

2025.0.19.6 (August 05, 2025)

• No new features or fixes.

2025.0.19.2 (June 04, 2025)

• CDPD-77993: match parquet-hadoop version with downstream

2025.0.19.0 (April 23, 2025) GA

• DWX-19627 HIVE-28620: Query result is cached in case of IOWD if the subquery is not trivial
• DWX-19668 HIVE-28616: OrcReader is not closed in OrcEncodedDataReader
• CDPD-75048 HIVE-13153: SessionID is appended to thread name twice - backport again to fix thread name noise
• CDPD-75556: Call createDmlFragment() when inserting into a partitioned table
• DWX-19504: HIVE-22948: QueryCache: Treat query cache locations as temporary storage
• CDPD-74640: HIVE-25907: IOW Directory queries fails to write data to final path when query result cache is enabled
• CDPD-74640: HIVE-21386: Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache
• CDPD-74640: HIVE-28530: Set files in thread safe manner in HiveSequenceFileInputFormat
• CDPD-72985: HIVE-27984: Support backward compatibility of hms thrift struct about column stats
• CDPD-71484 HIVE-27884: LLAP: Reuse FileSystem objects from cache across different tasks in the same LLAP daemon
• DWX-18331: HIVE-28121: Use direct SQL for transactional altering table parameter
• CDPD-64754: HIVE-28202: Incorrect projected column size after ORC upgrade to v1.6.7
• DWX-17033: Fixed NPE for UA non BinaryPredicate join condition.
• CDPD-69885: HIVE-28253: Unable to set the value for hplsql.onerror in hplsql mode.
• CDPD-69724: HIVE-28247: Execute immediate `select count(*) from tbl` throwing ClassCastException in hplsql mode.
• CDPD-69648: HIVE-28215: Signalling CONDITION HANDLER is not working in HPLSQL.
• CDPD-69647: HIVE-28214: HPLSQL not using the hive variables passed through beeline using --hivevar option

2024.0.18.4 (December 5, 2024) GA

• DWX-19668 HIVE-28616: OrcReader is not closed in OrcEncodedDataReader
• CDPD-75048 HIVE-13153: SessionID is appended to thread name twice
• CDPD-75556: Call createDmlFragment() when inserting into a partitioned table
• DWX-19504: HIVE-22948: QueryCache: Treat query cache locations as temporary storage
• CDPD-74640: HIVE-25907: IOW Directory queries fails to write data to final path when query result cache is enabled
• CDPD-74640: HIVE-21386: Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache
• CDPD-74640: HIVE-28530: Set files in thread safe manner in HiveSequenceFileInputFormat
• CDPD-72985: HIVE-27984: Support backward compatibility of hms thrift struct about column stats
• CDPD-71484 HIVE-27884: LLAP: Reuse FileSystem objects from cache across different tasks in the same LLAP daemon

2024.0.18.2-4 (October 4, 2024)

No new features or fixes.

2024.0.18.1-1 (August 15, 2024)

No new features or fixes.

2024.0.18.0-206 (July 26, 2024)

• DWX-18331: HIVE-28121: Use direct SQL for transactional altering table parameter
• CDPD-64754: HIVE-28202: Incorrect projected column size after ORC upgrade to v1.6.7
• DWX-17033: Fixed NPE for UA non BinaryPredicate join condition.
• CDPD-69885: HIVE-28253: Unable to set the value for hplsql.onerror in hplsql mode.
• CDPD-69724: HIVE-28247: Execute immediate `select count(*) from tbl` throwing ClassCastException in hplsql mode.
• CDPD-69648: HIVE-28215: Signalling CONDITION HANDLER is not working in HPLSQL.
• CDPD-69647: HIVE-28214: HPLSQL not using the hive variables passed through beeline using --hivevar option
• CDPD-69170:HIVE-28188:Upgrade Postgres to 42.7.3 to target CVE-2024-1597
• CDPD-7721: HIVE-22489: Reduce Sink operator should order nulls by parameter
• CDPD-68719: upgrade stack version to 7.2.18.0
• DWX-17905: HIVE-28165: HiveSplitGenerator: send splits through filesystem instead of RPC in case of big payload
• DWX-17905: HIVE-24415: HiveSplitGenerator blocks Tez dispatcher
• DWX-17957: HIVE-28167: Full table deletion fails when converting to truncate for Iceberg and ACID tables
• HIVE-27751 Log Query Compilation summary in an accumulated way
• DWX-17928: HIVE-27585: Upgrade kryo serialization lib to latest version (#4570).
• CDPD-67940: HIVE-28111: FSCountersSummary is only printed when LLAP IO is enabled
• CDPD-67793: HIVE-26955: Select query fails when decimal column data type is changed to string/char/varchar in Parquet
• CDPD-65291 :Drop database query failing with Invalid ACL Exception
• CDPD-67350: HIVE-27775: DirectSQL and JDO results are different when fetching partitions by timestamp in DST shift
• CDPD-66862: Upgrade mysql-connector-java in Hive packaging Docker File
• CDPD-65448: HIVE-28006: Materialized view with aggregate function incorrectly shows it allows incremental rebuild
• DWX-17487: HIVE-28051: LLAP: cleanup local folders on startup and periodically
• CDPD-67328: HIVE-28076: Selecting data from a bucketed table with decimal column type throwing NPE.
• CDPD-66902: HIVE-27406: Addendum: Query runtime optimization
• CDPD-61128: HIVE-27490: HPL/SQL says it support default value for parameters but not considering them when no value is passed
• CDPD-62437: HIVE-27692: Explore removing the maintenance task from the embedded Metastore
• CDPD-66930: Recompute scan ranges and stats in ImpalaHdfsScanNode
• CDPD-67205: HIVE-28083: Enable HMS client/query cache for EXPLAIN queries
• CDPD-64442: HIVE-27924: Incremental rebuild goes wrong when inserts and deletes overlap between the source tables
• CDPD-66644: HIVE-28050: Disable Incremental non aggregated materialized view rebuild in presence of delete operations
• CDPD-57121: HIVE-24411: Make ThreadPoolExecutorWithOomHook more awareness of OutOfMemoryError
• CDPD-67063: HIVE-28078: TestTxnDbUtil should generate csv files when we query the metastore database
• DWX-17615: HIVE-28093: Re-execute DAG in case of NoCurrentDAGException
• CDPD-61611: HIVE-27778: Alter table command gives error after computer stats is run with Impala
• CDPD-66267: HIVE-26882: Allow transactional check of Table parameter before altering the Table
• DWX-17274: TestInputFormatReaderDeletes fix
• CDPD-66632: CDPD-50060: HIVE-27114: Include all properties by default
• DWX-16861: CVE fixes for Apache hive JDBC driver
• DWX-17435: Facing dependency issues while using hive JDBC jar with JDBC client other than beeline
• CDPD-66644: HIVE-28050: Disable Incremental non aggregated materialized view rebuild in presence of delete operations
• CDPD-61250: Remove jwtprovider-knox
• CDPD-8806: HIVE-22961: Drop function in Hive should not send request for drop database to Ranger plugin
• CDPD-66527: HIVE-28054: SemanticException for join condition in subquery
• CDPD-63420: HIVE-25183: Inner Join condition parsing error in subquery
• CDPD-66089: HIVE-28000: Hive QL : "not in" clause gives incorrect results when type coercion cannot take place.
• CDPD-66090: HIVE-27161: MetaException when executing CTAS query in Druid storage handler
• DWX-17186 : HIVE-27938: Iceberg: Fix java.lang.ClassCastException during vectorized reads on partition columns
• CDPD-66084: HIVE-27948: Wrong results when using materialized views with non-deterministic/dynamic functions
• CDPD-63299:HIVE-27889: Bump org.apache.santuario:xmlsec from 2.3.0 to 2.3.4
• CDPD-65291 : HIVE-27911 : Drop database query failing with Invalid ACL Exception
• CDPD-65019: HIVE-28009: Shared work optimizer ignores schema merge setting in case of virtual column difference )
• CDPD-61127: HIVE-27489: HPL/SQL does not support table aliases on column names in loops
• CDPD-65805 HIVE-27993 : Netty4 ShuffleHandler: should use one boss thread