Get fresh updates from Hortonworks by email

Once a month, receive latest insights, trends, analytics information and knowledge of Big Data.

cta

Get Started

cloud

Ready to Get Started?

Download sandbox

How can we help you?

closeClose button
cta

IBM Db2 Big SQL

cloud Hortonworks is a leader. Read the Forrester Wave.

DOWNLOAD Report

OVERVIEW

Db2 Big SQL is a SQL engine for Hadoop that concurrently exploits Hive, HBase and Spark using a single database connection — even a single query. Db2 Big SQL is also the ultimate platform for data warehouse offload and consolidation, a key use case for many Hadoop users. This is because Db2 Big SQL is the first and only SQL-on-Hadoop solution to understand commonly used ANSI SQL syntax from other vendors and products such as Oracle, IBM DB2 and IBM PureData Systems for Analytics. And where data can’t be moved to Hadoop, Db2 Big SQL provides federated access to RDBMS sources outside of Hadoop with industry-leading IBM Fluid Query technology.

WHAT Db2 BIG SQL DOES

Db2 Big SQL is also the ultimate platform for data warehouse offload and consolidation, a key use case for many Hadoop users. This is because Db2 Big SQL is the first and only SQL-onHadoop solution to understand commonly used SQL syntax from other vendors and products such as Oracle, IBM DB2® and IBM Netezza®. And where data can’t be moved to Hadoop, Db2 Big SQL provides federated access to RDBMS sources outside of Hadoop with industry-leading Fluid Query technology. Hadoop has many next-generation analytics engines to solve big data problems.

Some of the unique capabilities of Db2 Big SQL includes:


  • Deep integration into the Hadoop Ecosystem and extends Hive’s core capabilities. Db2 Big SQL can concurrently exploit Hive, HBase and Spark using a single database connection—even a single query.

  • Where all data cannot be moved into your Hadoop system, BigSQL has unique capabilities to federate the data assets across the enterprise with the Hadoop Ecosystem.

  • Save costs by offloading data to Hadoop and exploit Db2 Big SQL’s next-generation, fit-for-purpose analytics and SQL optimizer for Hadoop to scale the concurrency of existing Hadoop SQL access.

For more information on the Hortonworks and IBM partnership, go here.