Feature spotlights

Standards-compliant ODBC and JDBC

For developers, the usage pattern allows you to access the database with specific products or tooling that only allow ODBC or JDBC.

Point queries

Enables short rapid queries that search by key or key ranges. Uses HBase for point queries and rapid insert, and to update and delete workloads.

Apache Spark integration

Integrates with Spark for easier insight delivery and faster processing. It provides an ANSI-compliant SQL parser that can run 99 TPC-DS queries and structured streaming with new APIs.

Federation capabilities

Uses a single database connection, enabling you to access data across Hadoop and relational databases, whether they are on the cloud, on premises, or both. Includes Fluid Query capabilities to enhance virtualization with various data warehouses. You can also federate with Object store (S3) and WebHDFS (technical preview only).

Compatibility with multiple SQL dialects

Understands SQL dialects from offerings such as IBM Db2 database and IBM Netezza data warehouse appliances and Oracle database. This makes the platform well suited for RDBMS offload, and fast and easy consolidation. Data can be offloaded from existing enterprise data warehouses or data marts to free up capacity while preserving most of the familiar SQL.

Available on IBM Power

Supports IBM Open Power servers, enabling clients to run SQL and Spark on a family of advanced Linux servers.

Elastically Scalable

Big SQL is the only SQL engine to successfully run all 99 TPCDS queries up to 100TB with numerous concurrent users. It also has the ability to run multiple workers per node for efficient CPU and memory utilization.

Most Secure SQL

Robust Role-based Access Control (RBAC), row-based dynamic filtering, column-based dynamic masking, and Ranger integration to provide centralized security administration and auditing for data lakes.

See how it works

Buy now and get started

Considering a purchase?

Call IBM

1-877-426-3774 Priority code: Analytics

Email an expert

An expert will respond to your email.