Try our new research platform with insights from 80,000+ expert users
Spark SQL Logo

Spark SQL pros and cons

Vendor: Apache
3.9 out of 5
 

Spark SQL Pros review quotes

it_user986637 - PeerSpot reviewer
Project Manager - Senior Software Engineer at a tech services company with 11-50 employees
Jul 16, 2019
The stability was fine. It behaved as expected.
DM
Data Analytics Practice head at bse
Feb 9, 2020
Overall the solution is excellent.
SS
Analytics and Reporting Manager at a financial services firm with 1,001-5,000 employees
Mar 18, 2020
The speed of getting data.
Learn what your peers think about Spark SQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,477 professionals have used our research since 2012.
PK
Cloud Team Leader at TCL
Apr 26, 2020
The performance is one of the most important features. It has an API to process the data in a functional manner.
reviewer1427205 - PeerSpot reviewer
Corporate Sales at a financial services firm with 10,001+ employees
Sep 27, 2020
It is a stable solution.
reviewer1488372 - PeerSpot reviewer
Associate Manager at a consultancy with 501-1,000 employees
May 29, 2021
Data validation and ease of use are the most valuable features.
reviewer1724670 - PeerSpot reviewer
Engineering Manager/Solution architect at a computer software company with 201-500 employees
Dec 2, 2021
This solution is useful to leverage within a distributed ecosystem.
Mahdi Sharifmousavi - PeerSpot reviewer
Lecturer at Amirkabir University of Technology
Aug 10, 2022
Offers a variety of methods to design queries and incorporates the regular SQL syntax within tasks.
KM
Senior Analyst/ Customer Business and Insights Specialist at a tech services company with 501-1,000 employees
Nov 22, 2022
The solution is easy to understand if you have basic knowledge of SQL commands.
Lucas Dreyer - PeerSpot reviewer
Data Engineer at BBD
Jan 4, 2023
Certain data sets that are very large are very difficult to process with Pandas and Python libraries. Spark SQL has helped us a lot with that.
 

Spark SQL Cons review quotes

it_user986637 - PeerSpot reviewer
Project Manager - Senior Software Engineer at a tech services company with 11-50 employees
Jul 16, 2019
In the next release, maybe the visualization of some command-line features could be added.
DM
Data Analytics Practice head at bse
Feb 9, 2020
The solution needs to include graphing capabilities. Including financial charts would help improve everything overall.
SS
Analytics and Reporting Manager at a financial services firm with 1,001-5,000 employees
Mar 18, 2020
Anything to improve the GUI would be helpful.
Learn what your peers think about Spark SQL. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,477 professionals have used our research since 2012.
PK
Cloud Team Leader at TCL
Apr 26, 2020
In the next update, we'd like to see better performance for small points of data. It is possible but there are better tools that are faster and cheaper.
reviewer1427205 - PeerSpot reviewer
Corporate Sales at a financial services firm with 10,001+ employees
Sep 27, 2020
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 found a quicker way to do that in Spark SQL. It would be good if you don't need a partition here, and the system automatically partitions in the best way. They can also provide more educational resources for new users.
reviewer1488372 - PeerSpot reviewer
Associate Manager at a consultancy with 501-1,000 employees
May 29, 2021
There should be better integration with other solutions.
reviewer1724670 - PeerSpot reviewer
Engineering Manager/Solution architect at a computer software company with 201-500 employees
Dec 2, 2021
This solution could be improved by adding monitoring and integration for the EMR.
Mahdi Sharifmousavi - PeerSpot reviewer
Lecturer at Amirkabir University of Technology
Aug 10, 2022
There are many inconsistencies in syntax for the different querying tasks.
KM
Senior Analyst/ Customer Business and Insights Specialist at a tech services company with 501-1,000 employees
Nov 22, 2022
It would be beneficial for aggregate functions to include a code block or toolbox that explains its calculations or supported conditional statements.
Lucas Dreyer - PeerSpot reviewer
Data Engineer at BBD
Jan 4, 2023
It takes a bit of time to get used to using this solution versus Pandas as it has a steep learning curve.