Apache Hive and IBM Db2® Big SQL can co-exist and complement each other in a cluster.
Hive enables SQL developers to write Hive query language statements similar to standard SQL ones. It is primarily used for geospatial analytics and is known for ACID capabilities and fast ingestion.
Db2 Big SQL uses Hive database catalog (HCatalog) for table definitions, location, storage format and encoding of input files. It builds on the solution by adding federation for complex queries, application portability, high concurrency and enterprise-grade security.