Offers unmatched simplicity, performance, and security for SQL on Hadoop. It provides a single point of access and view across all big data, exactly where it lives. Big SQL introduces a â€śbeyond MRâ€ť low-latency parallel execution infrastructure that is able to access Hadoop data natively for reading and writing.
- Scheduler reads predicates pushed down from compiler and optimizes queries based on where and how data is stored on a cluster
- Runs queries following the SQL:2011 languge standard across any number of tables
- Can perform all valid SQL standard join operations, group sets and union operations
Learn by doing! Get your hands on Big SQL with our tutorial.
Check out these documents and posts that will give you a general overview of Big SQL and what it’s capable of
- Big SQL in BigInsights 4.1 documentation hosted in IBM Knowledge Center. Get a quick breakdown of how Big SQL works and access to the provided documentation on Big SQL including the Big SQL 4.1 tutorial and in-depth reference
- The real SQL over Hadoop Story white paper
- White paper on Big SQL.Â An in-depth look at Big SQL architecture.
- Handling Custom File Formats with IBM BigInsights
- High Availability in Big SQL version 126.96.36.199
- Maximize Hadoop Data Security with IBM InfoSphere BigInsights
- Recovering from a Big SQL precheck failure
- Recovering from a Big SQL service check failure
- Run Oracle Applications on IBM Big SQL
- Running the Big SQL statements using Oozie
- Set up and use federation in InfoSphere BigInsights Big SQL V3.0
- SQL-on-Hadoop Without Compromise
- The Real SQL over Hadoop Story: Experiences from the Hadoop-DS benchmark
- User-Defined Functions (UDFs) in Big SQL v3.0
- Using Big SQL to access text data files in BigInsights 3.0
- What's the Big Deal About Big SQL?
- Working With Big SQL Extended and Complex Data Types