Skip to main content

Cloudera Impala Review Sheet

There has been a lot of constant interest in Cloudera Impala, which enables real-time, interactive analytical queries of the data stored in HBase or HDFS.
Below is a review sheet for Cloudera Impala based on multiple sources. Feel free to document anything which you may know differently.

What’s there:

-          USP:
o       Low latency querying for HDFS
-          Business Use case:
o       Can be used for near real time operations
-          Key Components:
o       Daemon : impalad – low latency daemon running on each datanode (mutually exclusive of MapReduce)
o       StateStore: Impala StateStore – high throughput scheduler which stores state of daemon running on nodes, also provides subscription service, thrift mode, failure detection (also for HA)
o       Shell: Impala Shell - standard querying interface
-          Production Ready Version



What’s not there (in current release):

-          Resource Manager
-          User Defined Function support for Hive
-          Delay Scheduling
-          Manual query aborts
-          DDL Statements
-          Procedures, Scheduled jobs


What to expect (in current release):

-          SQL-92 features of Hive Query language
-          Low latency start and fetch
-          ODBC support, Command Line Interface for querying
-          Kerberos authentication
-          Possible lesser cost of ownership than licensed counterparts like Hadapt

What not to expect (in current release):

-          RDBMS speed in all operations
-          Trevni support which will bring in support for columnar binary storage and   more compression options
-          Lot of consistent documentation

When to expect new features:

-          Q1’2013 for a more stable version
-          More feature loaded version in CDH5

Which are the closest product match:

-          Google F1
-          RAD labs Sparrow BatchSampling

How to update yourself

-          Impala mailing list
-          Cloudera blog


Where to download:

-          Beta Release

-          Documentation
-          Code
selective snapshot below: 



update: 6 Dec 2012: Title of post changed based on review comments received to sound more technically correct. 

Comments

Popular articles

5 online tools in data visualization playground

While building up an analytics dashboard, one of the major decision points is regarding the type of charts and graphs that would provide better insight into the data. To avoid a lot of re-work later, it makes sense to try the various chart options during the requirement and design phase. It is probably a well known myth that existing tool options in any product can serve all the user requirements with just minor configuration changes. We all know and realize that code needs to be written to serve each customer’s individual needs.
To that effect, here are 5 tools that could empower your technical and business teams to decide on visualization options during the requirement phase. Listed below are online tools for you to add data and use as playground.
1)      Many Eyes: Many Eyes is a data visualization experiment by IBM Researchandthe IBM Cognos software group. This tool provides option to upload data sets and create visualizations including Scatter Plot, Tree Map, Tag/Word cloud and ge…

Data deduplication tactics with HDFS and MapReduce

As the amount of data continues to grow exponentially, there has been increased focus on stored data reduction methods. Data compression, single instance store and data deduplication are among the common techniques employed for stored data reduction.
Deduplication often refers to elimination of redundant subfiles (also known as chunks, blocks, or extents). Unlike compression, data is not changed and eliminates storage capacity for identical data. Data deduplication offers significant advantage in terms of reduction in storage, network bandwidth and promises increased scalability.
From a simplistic use case perspective, we can see application in removing duplicates in Call Detail Record (CDR) for a Telecom carrier. Similarly, we may apply the technique to optimize on network traffic carrying the same data packets.
Some of the common methods for data deduplication in storage architecture include hashing, binary comparison and delta differencing. In this post, we focus on how MapReduce and…

In-memory data model with Apache Gora

Open source in-memory data model and persistence for big data framework Apache Gora™ version 0.3, was released in May 2013. The 0.3 release offers significant improvements and changes to a number of modules including a number of bug fixes. However, what may be of significant interest to the DynamoDB community will be the addition of a gora-dynamodb datastore for mapping and persisting objects to Amazon's DynamoDB. Additionally the release includes various improvements to the gora-core and gora-cassandra modules as well as a new Web Services API implementation which enables users to extend Gora to any cloud storage platform of their choice. This 2-part post provides commentary on all of the above and a whole lot more, expanding to cover where Gora fits in within the NoSQL and Big Data space, the development challenges and features which have been baked into Gora 0.3 and finally what we have on the road map for the 0.4 development drive.
Introducing Apache Gora Although there are var…