IBM Db2 Big SQL vs Spark SQL comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
146 views|103 comparisons
Apache Logo
1,332 views|586 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Db2 Big SQL and Spark SQL based on real PeerSpot user reviews.

Find out what your peers are saying about Apache, Cloudera, Amazon and others in Hadoop.
To learn more, read our detailed Hadoop Report (Updated: November 2022).
657,849 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pricing and Cost Advice
Information Not Available
  • "The solution is open-sourced and free."
  • "There is no license or subscription for this solution."
  • More Spark SQL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Hadoop solutions are best for your needs.
    657,849 professionals have used our research since 2012.
    Questions from the Community
    Ask a question

    Earn 20 points

    Top Answer:Being a new user, I am not able to find out how to partition it correctly. I probably need more information or knowledge. In other database solutions, you can easily optimize all partitions. I haven't… more »
    Top Answer:We use it to gather all the transaction data. We have Hadoop and Spark in our system, and we use some easy process flows for transport.
    Ranking
    12th
    out of 22 in Hadoop
    Views
    146
    Comparisons
    103
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    5th
    out of 22 in Hadoop
    Views
    1,332
    Comparisons
    586
    Reviews
    3
    Average Words per Review
    256
    Rating
    8.7
    Comparisons
    Learn More
    Overview

    IBM Db2® Big SQL is an enterprise-grade, hybrid ANSI-compliant SQL-on-Hadoop engine, delivering massively parallel processing (MPP) and advanced data query. Db2 Big SQL offers a single database connection or query for disparate sources such as Hadoop HDFS and WebHDFS, RDMS, NoSQL databases and object stores. Benefit from low latency, high performance, security, SQL compatibility and federation capabilities to do ad hoc and complex queries.

    Spark SQL is a Spark module for structured data processing. Unlike the basic Spark RDD API, the interfaces provided by Spark SQL provide Spark with more information about the structure of both the data and the computation being performed. There are several ways to interact with Spark SQL including SQL and the Dataset API. When computing a result the same execution engine is used, independent of which API/language you are using to express the computation. This unification means that developers can easily switch back and forth between different APIs based on which provides the most natural way to express a given transformation.
    Offer
    Learn more about IBM Db2 Big SQL
    Learn more about Spark SQL
    Sample Customers
    Information Not Available
    UC Berkeley AMPLab, Amazon, Alibaba Taobao, Kenshoo, Hitachi Solutions
    Top Industries
    No Data Available
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm13%
    Comms Service Provider12%
    University8%
    Company Size
    No Data Available
    REVIEWERS
    Small Business22%
    Midsize Enterprise56%
    Large Enterprise22%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise11%
    Large Enterprise72%
    Buyer's Guide
    Hadoop
    November 2022
    Find out what your peers are saying about Apache, Cloudera, Amazon and others in Hadoop. Updated: November 2022.
    657,849 professionals have used our research since 2012.

    IBM Db2 Big SQL is ranked 12th in Hadoop while Spark SQL is ranked 5th in Hadoop with 3 reviews. IBM Db2 Big SQL is rated 0.0, while Spark SQL is rated 8.6. On the other hand, the top reviewer of Spark SQL writes " Incorporates regular SQL syntax within tasks and very useful for querying and depicting data". IBM Db2 Big SQL is most compared with Apache Spark, whereas Spark SQL is most compared with Apache Spark, Amazon EMR, SAP HANA, Netezza Analytics and Hortonworks Data Platform.

    See our list of best Hadoop vendors.

    We monitor all Hadoop reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.