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.