{"id":3401,"date":"2012-11-26T07:00:41","date_gmt":"2012-11-26T15:00:41","guid":{"rendered":"http:\/\/www.formtek.com\/blog\/?p=3401"},"modified":"2012-11-26T07:00:41","modified_gmt":"2012-11-26T15:00:41","slug":"cloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop","status":"publish","type":"post","link":"https:\/\/formtek.com\/blog\/cloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop\/","title":{"rendered":"Cloud Computing: Cloudera&#039;s Impala Seeks to Replace Hive for Hadoop"},"content":{"rendered":"<p><a title=\"Cloudera Impala\" href=\"http:\/\/blog.cloudera.com\/blog\/2012\/10\/cloudera-impala-real-time-queries-in-apache-hadoop-for-real\/\" target=\"_blank\">Impala<\/a>, a new open-source <a title=\"Apache-licensed Cloudera Impala\" href=\"https:\/\/github.com\/cloudera\/impala\" target=\"_blank\">Apache-licensed tool <\/a>has recently been added by Cloudera to the Hadoop toolset ecosystem. \u00a0Inspired by Google&#8217;s <a title=\"Google's Dremel\" href=\"http:\/\/research.google.com\/pubs\/pub36632.html\" target=\"_blank\">Dremel<\/a>, Impala is a real-time query engine for Hadoop.<\/p>\n<p>Hadoop already has a tool called <em><a title=\"Apache Hive\" href=\"http:\/\/hive.apache.org\/\" target=\"_blank\">Hive <\/a><\/em>which provides some amount of structured-data access to Hadoop data sets. \u00a0While Impala is similar to Hive and is API-compatible with it, the implementation details are quite a bit different. \u00a0Hive processes and compiles SQL queries into Java and then runs those queries as batch-mode MapReduce jobs. \u00a0Hive effectively adds an extra step of SQL statement compiling in addtion to standard MapReduce Hadoop processing. \u00a0Instead, Impala more closely resembles a relational database and directly processes Hadoop data, eliminating the MapReduce step. \u00a0Another issue with Hive is that while the query language \u00a0is SQL-like, it really only supports about 30 percent of the capabilities of SQL available in standard relational data bases.<\/p>\n<p>The performance of Impala compared to Hive is expected to be significantly better. \u00a0Cloudera is claiming \u00a0performance gains ranging from 3x to 30x when using Impala compared to similar jobs run with Hive.<\/p>\n<p><a title=\"Mike Olson bio\" href=\"www.linkedin.com\/pub\/mike-olson\/9\/a0a\/433\" target=\"_blank\">Mike Olson<\/a>, CEO of\u00a0Cloudera,\u00a0<a title=\"InformationWeek on Apache Impala\" href=\"http:\/\/www.informationweek.com\/software\/information-management\/cloudera-debuts-real-time-hadoop-query\/240009673\" target=\"_blank\">told InformationWeek<\/a> that\u00a0&#8220;Our view is that, long-term, this will supplant Hive, but right now Hive has a huge installed base and lots of applications running against it, so I don&#8217;t imaging that [Impala] will replace Hive quickly. \u00a0Because it&#8217;s real time, Impala is going to be much more attractive.&#8221;<\/p>\n<p><a title=\"Curt Monash bio\" href=\"www.linkedin.com\/in\/curtmonash\" target=\"_blank\">Curt Monash<\/a>, a database and analytics expert and principal at Monash Research, <a title=\"Curt Monash on Hadoop weaknesses\" href=\"http:\/\/www.cio.in\/news\/moving-beyond-hadoop-big-data-needs-318762012\" target=\"_blank\">pointed out<\/a> that a major weakness of Hadoop is that it is poor at interactive and ad hoc queries across a large data set. \u00a0\u00a0&#8220;Hadoop has trouble with interactive responses. \u00a0If you can stand latencies of a few seconds, Hadoop is fine. But Hadoop MapReduce is never going to be useful for sub-second latencies.&#8221;<\/p>\n<div id=\"_mcePaste\"><a title=\"Charles Zedlewski bio\" href=\"www.linkedin.com\/pub\/charles-zedlewski\/0\/8a\/b93\" target=\"_blank\">Charles Zedlewski<\/a>, vice president of products at Cloudera,\u00a0<a title=\"Zedlewski on Cloudera Impala by The Register\" href=\"http:\/\/www.theregister.co.uk\/2012\/10\/24\/cloudera_hadoop_impala_real_time_query\/\" target=\"_blank\">said that<\/a> &#8220;The reason why people are attracted to it [Hadoop] is because it\u2019s scalable, extremely flexible, easy to get started with, and inexpensive compared to what else is out there&#8230; \u00a0MapReduce is by definition a batch system. \u00a0There&#8217;s no getting around that. And, despite that, Hadoop made a lot of hard things easy. But it also made a lot of easy things hard. We want to make the easy things easy again [with Impala].&#8221;<\/div>\n<p><a title=\"Tony Baer bio\" href=\"www.linkedin.com\/in\/onstrategies\" target=\"_blank\">Tony Baer<\/a>, principal analyst for Ovum, <a title=\"Tony Baer on Impala\" href=\"http:\/\/www.drdobbs.com\/open-source\/cloudera-impala-processing-petabytes-at\/240012477\" target=\"_blank\">said that <\/a>&#8220;Mainstream enterprise adoption of Hadoop will inevitably raise expectations. \u00a0Enterprises have grown accustomed to interactive querying and on-the-spot analytics with their existing data warehousing and BI infrastructures and will expect no less of Hadoop. With a real-time query capability powered by its new Impala engine, Cloudera is striving to level the playing field in performance and accessibility with massively parallel SQL platforms.&#8221;<\/p>\n<div class=\"lightsocial_container\"><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/digg.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/digg.png\" alt=\"Digg This\" title=\"Digg This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.reddit.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/reddit.png\" alt=\"Reddit This\" title=\"Reddit This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.stumbleupon.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/stumbleupon.png\" alt=\"Stumble Now!\" title=\"Stumble Now!\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/buzz.yahoo.com\/buzz?targetUrl=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F&amp;headline=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/yahoo_buzz.png\" alt=\"Buzz This\" title=\"Buzz This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dzone.com\/links\/add.html?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dzone.png\" alt=\"Vote on DZone\" title=\"Vote on DZone\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.facebook.com\/sharer.php?t=&amp;u=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/facebook.png\" alt=\"Share on Facebook\" title=\"Share on Facebook\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/delicious.com\/save?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/delicious.png\" alt=\"Bookmark this on Delicious\" title=\"Bookmark this on Delicious\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dotnetkicks.com\/kick\/?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetkicks.png\" alt=\"Kick It on DotNetKicks.com\" title=\"Kick It on DotNetKicks.com\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/dotnetshoutout.com\/Submit?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetshoutout.png\" alt=\"Shout it\" title=\"Shout it\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.linkedin.com\/shareArticle?mini=true&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F&amp;title=&amp;summary=&amp;source=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/linkedin.png\" alt=\"Share on LinkedIn\" title=\"Share on LinkedIn\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.technorati.com\/faves?add=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/technorati.png\" alt=\"Bookmark this on Technorati\" title=\"Bookmark this on Technorati\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/twitter.com\/home?status=Reading+https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/twitter.png\" alt=\"Post on Twitter\" title=\"Post on Twitter\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.google.com\/buzz\/post?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/google_buzz.png\" alt=\"Google Buzz (aka. Google Reader)\" title=\"Google Buzz (aka. Google Reader)\" \/><\/a><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Impala, a new open-source Apache-licensed tool has recently been added by Cloudera to the Hadoop toolset ecosystem. \u00a0Inspired by Google&#8217;s Dremel, Impala is a real-time query engine for Hadoop. Hadoop already has a tool called Hive which provides some amount<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/formtek.com\/blog\/cloud-computing-clouderas-impala-seeks-to-replace-hive-for-hadoop\/\">Read more &#8250;<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-3401","post","type-post","status-publish","format-standard","hentry","category-cloud-computing"],"_links":{"self":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/3401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/comments?post=3401"}],"version-history":[{"count":0,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/3401\/revisions"}],"wp:attachment":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/media?parent=3401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/categories?post=3401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/tags?post=3401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}