Db2 Big SQL on Cloud Pak for Data
Version: 7.7.3 Included IBM
Description
Db2 Big SQL is a cloud-native, elastic, scalable SQL engine optimized for workloads on data stored in object stores or HDFS.
Db2 Big SQL can query data stored on legacy Hadoop clusters, using the configurations of open source components, such as:
- HDFS
- Hive metastore
- Ranger
Using Db2 Big SQL with IBM Cloud Pak for Data can be useful in the following situations:
- You need to query large amounts of data residing on legacy Hadoop secured (Kerberized) or unsecured clusters and on private or public cloud object storage.
- You need highly optimized queries for multiple open source data formats, including Parquet, ORC, Avro, and CSV.
Quick links
- Architecture: View the components and software
- Install: Install the service
- Upgrade: Upgrade the service
- Administer: Manage and maintain the service
- Use: Work with the service
- What's new: See a list of new features
- Known issues: View limitations
- Troubleshoot: Find solutions to problems
Integrated services
Service | Capability |
---|---|
IBM Db2 Data Management Console | Administer, monitor, manage, and optimize the performance of your IBM Db2 databases. |
Runtime 24.1 on Python 3.11 for GPU | Access compute environments for Jupyter Notebooks that use GPU-accelerated Python 3.11 libraries. |
Watson Studio | Prepare, analyze, and model data in a collaborative environment with tools for data scientists, developers, and domain experts. |