Welcome!

Open Source Cloud Authors: Jeev Trika, Elizabeth White, Yeshim Deniz, Pat Romanski, Derek Weeks

News Feed Item

Cloudera Impala Delivers Superior Performance on Open Hadoop Data Over Proprietary Analytic DBMSs

Emerges as Fastest, Most Functional and Proven Way to Run SQL on Hadoop Data

PALO ALTO, CA -- (Marketwired) -- 01/13/14 -- Cloudera, the leader in Apache Hadoop™ based data management platforms, today released the results of performance benchmark testing for its open source interactive SQL query engine, Cloudera Impala. Impala queries across data in an open Hadoop columnar storage format (Parquet) ran on average 2x faster than identical queries on a commercial analytic database management system (DBMS) over its proprietary storage format.

Cloudera delivers an enterprise data hub -- a next-generation platform for secure, powerful, real-time processing and analysis of data at scale. An enterprise data hub must provide data governance and lineage services, support enterprise-grade backup and disaster recovery and offer a wide range of ways to work with the data that it manages. It must support the tools and interfaces on which existing applications and tools rely. Critical among those is real-time SQL access for analytics.

Impala Delivers

Launched in October 2012 and released for general availability in May 2013, Impala enables high speed, interactive SQL analysis of Hadoop data at petabyte scale. Today Impala has emerged as the fastest, most functional and proven way to run SQL on Hadoop data for open source users and enterprise customers alike. The platform has continued to evolve rapidly with deepening support for the ANSI-SQL standard, certified integrations to leading business intelligence tools, sophisticated workload management and consistently superior performance.

Impala deployments continue to proliferate in the enterprise: to date, the platform has been downloaded by more than 5,000 unique organizations globally, demonstrating its appeal and significance. Cloudera continues to work closely with its enterprise customers and the open source community to refine and advance Impala's enterprise features, like Apache Sentry (incubating), the fine-grained, role-based authorization module released this year. Further establishing Impala's leadership in the industry, Hadoop-based solutions from other vendors integrate the Cloudera-created SQL query engine into their own offerings in response to customer demand.

Analytic DBMS Performance on Open Data in the Enterprise Data Hub

Running a diverse set of analytic queries on identical hardware, Impala has successfully eclipsed the performance of a popular proprietary parallel DBMS. The same benchmarks also showed Impala has maintained or widened its performance advantage against the latest release of Apache Hive (0.12).

Furthermore, it has done so on data in an open Hadoop data format. With these results, customers are able to exceed their SQL performance experiences from proprietary databases but preserve the flexibility they enjoy with the Hadoop stack.

The Proof Is In the Data: Impala Shows BI-Class Speed for Mainstream Workloads

To evaluate Impala's query performance against a popular analytic database (referred to as "DBMS-Y"), Cloudera ran a series of 20 queries based on the industry-standard benchmark TPC-DS. The results showed that:

  • Impala ran consistently faster than DBMS-Y: across 20 queries, Impala ran on average 2X to DBMS-Y, outperforming DBMS-Y in 17 of the 20 queries. For some queries, Impala was over 4x faster.

Queries over open data beat those over proprietary data: Even though Impala queries were done on openHadoop data in the Parquet format, and DBMS-Y queries were done on data in its own proprietary format. Impala was still faster.

  • Impala scales linearly and predictably: In tests, Impala maintained identical response times with increased user concurrency and on larger data sets by simply adding new machines at the same rate as the concurrency and data growth.
  • Furthermore, Impala is still more than an order of magnitude faster than Hive: on identical hardware Impala queries ran an average of 24x faster than those run on Apache Hive 0.12 using ORCfile.

No Sleight of hand, no gimmicks

Cloudera is committed to leading the industry as a high integrity business that provides unbiased information to customers and users. Dozens of users have download Cloudera's 100% open source platform, run their own performance evaluations, and shared them publicly. Cloudera places no confidentiality clauses or other proprietary restrictions on the use of its distribution. In addition, Cloudera has made the queries, configuration, hardware specifications, and data available for use for the open source community to review and evaluate. Information can be found at http://www.cloudera.com/impalaishellafast/

"Interactive exploratory business intelligence is a mainstay workload of the Enterprise Data Hub," said Mike Olson, founder, chief strategy officer and chairman of the Board at Cloudera. "We are proud of how quickly Impala has evolved and the rate at which it is being adopted. With thousands of users now running Impala in production, its significance is indisputable. One year ago, when we released Impala to open source, we knew that it had the potential to eventually play on the same field as some very mature analytic DBMSs, but the results of these performance benchmark tests exceed our very high expectations. In the coming months, we will unveil new enhancements to the platform that will further advance its performance, ease of use and security, extending Impala's benefits for open source users and our enterprise customers."

Learn More About Cloudera Impala
For a more detailed account of the methodology and results from Cloudera's Impala performance benchmark testing against Hive and a proprietary DBMS, visit the Cloudera blog: http://blog.cloudera.com/blog/2014/01/impala-performance-dbms-class-speed

For more information about Cloudera Impala and how to download for free, visit: http://cloudera.com/content/cloudera/en/products/cdh/impala.html

About Cloudera
Cloudera is revolutionizing enterprise data management by offering the first unified Platform for Big Data: The Enterprise Data Hub. Cloudera offers enterprises one place to store, process and analyze all their data, empowering them to extend the value of existing investments while enabling fundamental new ways to derive value from their data. Founded in 2008, Cloudera was the first and is still today the leading provider and supporter of Hadoop for the enterprise. Cloudera also offers software for business critical data challenges including storage, access, management, analysis, security and search. With over 15,000 individuals trained, Cloudera is a leading educator of data professionals, offering the industry's broadest array of Hadoop training and certification programs. Cloudera works with over 800 hardware, software and services partners to meet customers' big data goals. Leading organizations in every industry run Cloudera in production, including finance, telecommunications, retail, internet, utilities, oil and gas, healthcare, biopharmaceuticals, networking and media, plus top public sector organizations globally. www.cloudera.com

Connect with Cloudera
Read our blog: http://www.cloudera.com/blog/
Follow us on Twitter: http://twitter.com/cloudera
Visit us on Facebook: http://www.facebook.com/cloudera

Cloudera, Cloudera Platform for Big Data and CDH are trademarks or registered trademarks of Cloudera in the United States and in jurisdictions throughout the world. All other company and product names may be trade names or trademarks of their respective owners.

Add to Digg Bookmark with del.icio.us Add to Newsvine

More Stories By Marketwired .

Copyright © 2009 Marketwired. All rights reserved. All the news releases provided by Marketwired are copyrighted. Any forms of copying other than an individual user's personal reference without express written permission is prohibited. Further distribution of these materials is strictly forbidden, including but not limited to, posting, emailing, faxing, archiving in a public database, redistributing via a computer network or in a printed form.

@ThingsExpo Stories
The IoT is changing the way enterprises conduct business. In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discuss how businesses can gain an edge over competitors by empowering consumers to take control through IoT. We'll cite examples such as a Washington, D.C.-based sports club that leveraged IoT and the cloud to develop a comprehensive booking system. He'll also highlight how IoT can revitalize and restore outdated business models, making them profitable...
SYS-CON Events announced today that MangoApps will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. MangoApps provides modern company intranets and team collaboration software, allowing workers to stay connected and productive from anywhere in the world and from any device. For more information, please visit https://www.mangoapps.com/.
SYS-CON Events announced today the How to Create Angular 2 Clients for the Cloud Workshop, being held June 7, 2016, in conjunction with 18th Cloud Expo | @ThingsExpo, at the Javits Center in New York, NY. Angular 2 is a complete re-write of the popular framework AngularJS. Programming in Angular 2 is greatly simplified. Now it’s a component-based well-performing framework. The immersive one-day workshop led by Yakov Fain, a Java Champion and a co-founder of the IT consultancy Farata Systems and...
What a difference a year makes. Organizations aren’t just talking about IoT possibilities, it is now baked into their core business strategy. With IoT, billions of devices generating data from different companies on different networks around the globe need to interact. From efficiency to better customer insights to completely new business models, IoT will turn traditional business models upside down. In the new customer-centric age, the key to success is delivering critical services and apps wit...
Join us at Cloud Expo | @ThingsExpo 2016 – June 7-9 at the Javits Center in New York City and November 1-3 at the Santa Clara Convention Center in Santa Clara, CA – and deliver your unique message in a way that is striking and unforgettable by taking advantage of SYS-CON's unmatched high-impact, result-driven event / media packages.
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, will provide an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life ...
SYS-CON Events announced today that BMC Software has been named "Siver Sponsor" of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. BMC is a global leader in innovative software solutions that help businesses transform into digital enterprises for the ultimate competitive advantage. BMC Digital Enterprise Management is a set of innovative IT solutions designed to make digital business fast, seamless, and optimized from mainframe to mo...
SYS-CON Events announced today that MobiDev will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. MobiDev is a software company that develops and delivers turn-key mobile apps, websites, web services, and complex software systems for startups and enterprises. Since 2009 it has grown from a small group of passionate engineers and business managers to a full-scale mobile software company with over 200 develope...
As cloud and storage projections continue to rise, the number of organizations moving to the cloud is escalating and it is clear cloud storage is here to stay. However, is it secure? Data is the lifeblood for government entities, countries, cloud service providers and enterprises alike and losing or exposing that data can have disastrous results. There are new concepts for data storage on the horizon that will deliver secure solutions for storing and moving sensitive data around the world. ...
SoftLayer operates a global cloud infrastructure platform built for Internet scale. With a global footprint of data centers and network points of presence, SoftLayer provides infrastructure as a service to leading-edge customers ranging from Web startups to global enterprises. SoftLayer's modular architecture, full-featured API, and sophisticated automation provide unparalleled performance and control. Its flexible unified platform seamlessly spans physical and virtual devices linked via a world...
SYS-CON Events announced today that ContentMX, the marketing technology and services company with a singular mission to increase engagement and drive more conversations for enterprise, channel and SMB technology marketers, has been named “Sponsor & Exhibitor Lounge Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York. “CloudExpo is a great opportunity to start a conversation with new prospects, but what happens after the...
Companies can harness IoT and predictive analytics to sustain business continuity; predict and manage site performance during emergencies; minimize expensive reactive maintenance; and forecast equipment and maintenance budgets and expenditures. Providing cost-effective, uninterrupted service is challenging, particularly for organizations with geographically dispersed operations.
The IoTs will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, will demonstrate how to move beyond today's coding paradigm and share the must-have mindsets for removing complexity from the development proc...
SYS-CON Events announced today TechTarget has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. TechTarget is the Web’s leading destination for serious technology buyers researching and making enterprise technology decisions. Its extensive global networ...
SYS-CON Events announced today that Commvault, a global leader in enterprise data protection and information management, has been named “Bronze Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Commvault is a leading provider of data protection and information management...
The essence of data analysis involves setting up data pipelines that consist of several operations that are chained together – starting from data collection, data quality checks, data integration, data analysis and data visualization (including the setting up of interaction paths in that visualization). In our opinion, the challenges stem from the technology diversity at each stage of the data pipeline as well as the lack of process around the analysis.
Designing IoT applications is complex, but deploying them in a scalable fashion is even more complex. A scalable, API first IaaS cloud is a good start, but in order to understand the various components specific to deploying IoT applications, one needs to understand the architecture of these applications and figure out how to scale these components independently. In his session at @ThingsExpo, Nara Rajagopalan is CEO of Accelerite, will discuss the fundamental architecture of IoT applications, ...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
SYS-CON Events announced today that Tintri Inc., a leading producer of VM-aware storage (VAS) for virtualization and cloud environments, will exhibit at the 18th International CloudExpo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
SYS-CON Events announced today that Alert Logic, Inc., the leading provider of Security-as-a-Service solutions for the cloud, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Alert Logic, Inc., provides Security-as-a-Service for on-premises, cloud, and hybrid infrastructures, delivering deep security insight and continuous protection for customers at a lower cost than traditional security solutions. Ful...