BI On Hadoop Success: 7 Things To Know - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Data Management // Software Platforms
News
10/21/2016
07:06 AM
Jessica Davis
Jessica Davis
Slideshows
Connect Directly
Twitter
RSS
E-Mail
50%
50%

BI On Hadoop Success: 7 Things To Know

When enterprises implement Hadoop, their top use-case was found to be business intelligence (BI). Now a new benchmark study shows which Hadoop SQL engines are best for which workloads. Here is a look at 7 key findings from that study.
Previous
1 of 8
Next

(Image: Kenishirotie/iStockphoto)

(Image: Kenishirotie/iStockphoto)

Business intelligence is the top use-case for IT organizations implementing Hadoop, according to a large industry survey last year. Now a new benchmark study shows which Hadoop ecosystem tools are best for particular types of BI queries.

The recently released study's findings offer perspective for IT organizations on a handful of SQL-on-Hadoop engines, such as Hive, Impala, Presto, and Spark SQL. They provide insights on their performance for particular kinds of analytic jobs. The benchmark comes from AtScale, a company that is focused on helping organizations make business intelligence work on Hadoop.

"Different engines continue to perform well for different jobs," said Josh Klahr, VP of products at AtScale, in an interview with InformationWeek. "IT organizations should probably be wary about making a bet on just one engine -- like putting everything on Hive or on Impala."

This new benchmark released this week is the second edition. It provides insight into how the performance of each of these engines has improved since the last report, released 6 months ago.

[Looking for the key big data technologies you need for a successful infrastructure? Read 7 Keys to Building a Successful Big Data Infrastructure.]

IT organizations will want to take note of the results. Business intelligence is the top use-case that enterprises plan for their Hadoop implementations, according to a 2015 Hadoop Maturity Survey of close to 2,100 business, IT, and C-suite executives conducted by AtScale, Tableau, and the three big Hadoop distributors -- Cloudera, Hortonworks, and MapR.

That report found that ETL and data science workloads on Hadoop were decreasing, while business intelligence had gained momentum. That survey also showed that 69% of organizations cited business intelligence as the top use-case, followed by data science at 56%, and ETL at 51%. In 2014, the same survey showed ETL at 74%, data science at 62%, and business intelligence at 65%.

What's more, getting value out of your Hadoop projects may be directly linked to whether your IT organization has enabled business users to query the Hadoop data directly themselves, according to the 2015 Hadoop Maturity Survey. Providing this self-service access to business users unlocks value for organizations.

The survey showed that of the companies that provided self-service options to users, 61% say they are gaining value from Hadoop. Some 41% of the companies that did not provide self-service options say that they see tangible value, and 59% say that they don't see tangible value.

How do you make sure you are adding the right engines to your Hadoop infrastructure to best enable the fast response time your business users expect on their queries? Here is a look at some notable findings from AtScale's tools benchmark test.

Jessica Davis has spent a career covering the intersection of business and technology at titles including IDG's Infoworld, Ziff Davis Enterprise's eWeek and Channel Insider, and Penton Technology's MSPmentor. She's passionate about the practical use of business intelligence, ... View Full Bio

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Previous
1 of 8
Next
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
Maia2920
50%
50%
Maia2920,
User Rank: Apprentice
10/26/2016 | 9:07:53 AM
We should improve
Probably we should improve the business marketing through technology and its benefits.
Maia2920
50%
50%
Maia2920,
User Rank: Apprentice
10/26/2016 | 8:07:59 AM
Very interesting
I find this post very interesting as I am a business man interested into technology and the many ways this improves our lives.
Commentary
Study Proposes 5 Primary Traits of Innovation Leaders
Joao-Pierre S. Ruth, Senior Writer,  11/8/2019
Slideshows
Top-Paying U.S. Cities for Data Scientists and Data Analysts
Cynthia Harvey, Freelance Journalist, InformationWeek,  11/5/2019
Slideshows
10 Strategic Technology Trends for 2020
Jessica Davis, Senior Editor, Enterprise Apps,  11/1/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Getting Started With Emerging Technologies
Looking to help your enterprise IT team ease the stress of putting new/emerging technologies such as AI, machine learning and IoT to work for their organizations? There are a few ways to get off on the right foot. In this report we share some expert advice on how to approach some of these seemingly daunting tech challenges.
Slideshows
Flash Poll