Cloudera Docs

Hive changelog for Cloudera Data Warehouse on cloud

Review the changes introduced in Hive for Cloudera Data Warehouse on cloud.

2025.0.20.1 (December 11, 2025)

No new features or fixes.

2025.0.20.1 (November 21, 2025)

  • DWX-22225: HIVE-29318: PostgreSQL requires every NULL parameter to have an explicit SQL type

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