Get fresh updates from Hortonworks by email

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

cta

Get Started

cloud

Ready to Get Started?

Download sandbox

How can we help you?

closeClose button
cta

IBM Big SQL

OVERVIEW

Big SQL is a SQL engine for Hadoop that concurrently exploits Hive, HBase and Spark using a single database connection — even a single query. Big SQL is also the ultimate platform for data warehouse offload and consolidation, a key use case for many Hadoop users. This is because 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, Big SQL provides federated access to RDBMS sources outside of Hadoop with industry-leading IBM Fluid Query technology.

WHAT BIG SQL DOES

Big SQL is also the ultimate platform for data warehouse offload and consolidation, a key use case for many Hadoop users. This is because 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, 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 Big SQL includes:


  • Deep integration into the Hadoop Ecosystem and extends Hive’s core capabilities. 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 Big SQL’s next-generation, fit-for-purpose analytics and SQL optimizer for Hadoop to scale the concurrency of existing Hadoop SQL access.