IBM Support

IBM's Big Data Newsletter – August 1st, 2018 - Hadoop Dev

Technical Blog Post


IBM's Big Data Newsletter – August 1st, 2018 - Hadoop Dev


IBM Db2 Big SQL leads SQL Engines on Hadoop

Bloor Research released a Market Report paper on SQL Engines on Hadoop. It compares a myriad of SQL engines on Hadoop and based on use cases, has placed Db2 Big SQL as a leader in Hadoop use cases, performance and SQL support.

Bloor Research image
Figure: SQL Engines on Hadoop, Market Report Paper by Bloor Research, December 2017

Hadoop is part of every enterprises’ data management platform for various needs. One major need is the ability to execute SQL on Hadoop data. As most applications for business intelligence and analytics are in SQL, and SQL skills are ubiquitous in any analytics department, it is imperative to have solutions that support high level of SQL compliance and performance.

Bloor Research evaluates many SQL engines on Hadoop and boils down the key differentiating capabilities of these engines in 3 categories, they are: use cases it supports, level of SQL support and performance. The SQL engine that leads in those categories is IBM Db2 Big SQL.


The key differentiators between products are the use cases they support, their performance, and the level of SQL they offer.

The level of support for ANSI standard SQL varies widely. IBM – not just in Big SQL and Db2, but across its product range – is much the most advanced vendor in this respect.

Db2 Big SQL as the name suggests, is an advanced SQL engine that brings the power of Db2 to Hadoop. It has the most advanced ANSI standard SQL implementation. And includes SQL compatibility with Oracle PL/SQL (over 95%). The true strength of Db2 Big SQL is its inherit capability of executing complex analytics serving many concurrent users.

Adding to the core capabilities of Db2, Db2 Big SQL also brings the ability to query both Hive and HBase tables in a single query, and the ability to extend the warehouse environment to machine learning with its bi-directional integration with Spark. One key differentiator is its ability to query disparate data sources in a single query using its enterprise federation capabilities.

Get the free report here:


Pund-IT blogs on IHAH as a path AI and Hadoop

We are excited to see our new offering IBM Hosted Analytics with Hortonworks (IHAH) being featured in the Pund-IT blog. We launched this offering with a very simple mission, simplify data analytics and data science and encourage customers to take advantage of the cloud.

Moreover, it has the building blocks for an organization to move towards becoming an AI organization. This offering comes as an extension to the successful partnership between IBM and Hortonworks which focusses on enabling clients into becoming data driven organizations. Read more here:


Blog: Performance for Db2 Big SQL Federation

Db2 Big SQL enables combining data from disparate sources with its federation capability. This is a very advanced capability and the user needs to understand how best to make use of this feature. This blog explains how the performance works while the query federates to a remote data source. Read and learn more on how it works:



More Resources: 

More information on IBM Db2 Big SQL + Try the New IBM Big SQL Sandbox: IBM Db2 Big SQL webpage

More information on Hadoop: IBM Hadoop webpage 

Explore technical topics and join the community: Hadoop and Big SQL Community

Find answers quickly: IBM Db2 Big SQL Knowledge Center  and IBM Big Replicate Knowledge Center

Provide feedback and product improvement ideas: Ideas Portal (Choose Component: Db2 Big SQL, BigReplicate)

Communicate with the IBM Db2 Big SQL Offering Team: 

Keep up to date with IBM Db2 Big SQL news and announcements: Twitter: @Db2BigSQL

Subscribe    Unsubscribe


[{"Business Unit":{"code":"BU054","label":"Cloud & Data Platform"},"Product":{"code":"SSCRJT","label":"IBM Big SQL"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]