A hybrid SQL-on-Hadoop engine delivering advanced, security-rich data query across enterprise big data sources, including Hadoop, object storage and data warehouses.
Try the free edition
Person studying information on laptop
What is IBM® Db2® Big SQL?

IBM Db2 Big SQL is an enterprise-grade, hybrid ANSI-compliant SQL-on-Hadoop engine, delivering massively parallel processing (MPP) and advanced data query. Db2 Big SQL offers a single database connection or query for disparate sources such as Hadoop HDFS and WebHDFS, RDMS, NoSQL databases, and object stores. Benefit from low latency, high performance, data security, SQL compatibility, and federation capabilities to do ad hoc and complex queries.

Db2 Big SQL is now available in 2 variations. It can be integrated with Cloudera Data Platform, or accessed as a cloud-native service on the IBM Cloud Pak® for Data platform.

Learn about 1.5x improved load time and other enhancements in Db2 11.5.8 cloud-first

Read the solution brief (91 KB)
Now available:

Scale AI workloads, for all your data, anywhere

IBM Db2 Big SQL now available on IBM Cloud Pak® for Data

Benefits Quickly query across platforms

Access and analyze data and perform queries on batch and real-time data across sources, like Hadoop, object stores and data warehouses.

Flexibly scale

Based on your requirements, shift workloads within public and private cloud and on-premises environments to achieve the hybrid cloud flexibility you need.

Drive real-time analytics

Concurrently exploit Hadoop SQL queries across Hive, Hbase and Spark, using a single database connection — even a single query — to achieve analytics in real time.

Connect your data

Make data available to data scientists and analysts with connections to IBM Watson® Studio and existing Jupyter Notebooks to federate to RDBMS and to Oracle, Db2 and IBM Netezza®.

Improve performance

Numerous users can query at the same time, with the ability to run all 99 TPC-DS queries up to 100 TB, supporting multiple workers per node for efficient utilization.

Use cases Better data-driven decisions

Integrate new forms of semi and unstructured data (social media, sentiment, streaming audio/video, log and more) with your traditional structured data using advanced querying capabilities.

Data warehouse modernization

Free up bandwidth and storage. Cloudera Enterprise Data Hub and Db2 Big SQL provide a superior platform for offloading historical or cold data in Oracle data marts and warehouses to Hadoop.

Real-time data queries

Equip your data users with the right tools including Db2 Big SQL integrated with Apache Spark so they can do ad hoc and real-time queries to meet the needs of the business.

Operational improvements

Use virtualization and federation to unify data access across the logical enterprise data warehouse, cloud and Hadoop for more accurate data-driven decisions.

Product images

Complex querying Db2 Big SQL's robust engine executes complex queries for relational data and Hadoop data, making querying enterprise data from across the organization an easy and secure experience.

Monitoring capabilities Monitor service metrics with intuitive dashboards help to identify the root causes of slowdowns, helping to maximize resources and performance.

Simplified deployment   Db2 Big SQL has a simplified deployment experience, helping to easily create service instances and allocate resources.

Dynamic scaling   Based on workload needs, scale the instance up or down by allocating additional or fewer resources.


See how to integrate Cognos with Db2 Big SQL (7-minute demo).

IBM Db2 Big SQL product tour

In this product introduction, see how to use various functions in Big SQL.

Learn how to use IBM Data Server Manager with Big SQL.

Take the next step

Get started with IBM Db2 Big SQL.

Try the free edition
More ways to explore Documentation Support FAQ (42.5 KB) Community