Hadoop SQL Query Engine Launched
Hadoop SQL Query Engine Launched
Written by Kay Ewbank   
Monday, 06 May 2013

Cloudera has announced the general availability of Impala, its open source, interactive SQL query engine for analyzing data stored in Hadoop clusters in real time.

Impala has been available in public beta since October 2012, and a number of companies are already using it. Impala lets you query data stored in HDFS and HBase directly. The framework supports all standard file and data formats available, so you can choose the format that best your needs. The support extends to recent releases such as analytics-focused columnar formats like Parquet.

Impala lets you work from a single dataset, eliminating the need to migrate datasets into specialized systems or proprietary formats just because you want to work on it. The Impala framework is optimized for use with CDH, Cloudera’s open source distribution of Hadoop and related applications.

 

 

The final version has some new features compared to the beta, including ALTER TABLE and REFRESH for individual tables. It also supports dynamic resource management. Query hints have also been added to the SQL, so you can check for potential alternatives when a query is running slowly or tying up resources due to missing statistics.

While the main version is free for use, there’s an optional subscription module called Cloudera Enterprise Real-Time Query (RTQ) that adds technical support and management automation to Impala for Cloudera Enterprise customers.

Cloudera Enterprise with RTQ is based on Impala and offers a single, massively scalable system that can be used to provide petascale processing in real time. A number of companies have certified their analysis products for integration with the platform, including Alteryx, Capgemini, IBM Cognos, Karmasphere, MicroStrategy, Pentaho, QlikView, Splunk and Tableau.

A slide presentation An Introduction to Impala is available to view in return for contact details.

impalalogo

More Information

Cloudera

Download

Related Articles

Cloudera Impala - Real-Time Query on Hadoop

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

 
 



Comments




or email your comment to: comments@i-programmer.info

 

Banner


Amazon Transcribe & Translate Ready For Work
06/04/2018

Amazon has two new services with APIs ready to be built into your apps. Transcribe will convert speech to text and Translate translates text into another language.



Chatbots for eCommerce
13/04/2018

Chatbots are increasingly being used in the realm of customer service. Banks have led the way with voice automation and many businesses are following this trend. If you need to be convinced of the the [ ... ]


More News

 

 

Last Updated ( Monday, 06 May 2013 )
 
 

   
Banner
Banner
RSS feed of news items only
I Programmer News
Copyright © 2018 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.