Apache HBase on Amazon EMR

Apache HBase is designed to maintain performance while scaling out to hundreds of nodes, supporting billions of rows and millions of columns. It utilizes Amazon S3 (with EMRFS) or the Hadoop Distributed Filesystem (HDFS) as a fault-tolerant datastore. Amazon EMR supports a wide variety of instance types and Amazon EBS volumes, so you can customize the hardware of your cluster to optimize for cost and performance. Additionally, you can use Apache Phoenix for low-latency SQL over massive HBase tables or creating secondary indexes for increased performance.

Through tight integration with projects in the Apache Hadoop ecosystem, you can easily run massively parallel analytics workloads on data stored in HBase tables. You can easily install Apache Phoenix, Apache Hadoop, Apache Hive, Apache Pig, and other open-source big data applications on your Amazon EMR cluster alongside Apache HBase, and utilize these tools to run reporting, SQL queries, or other analytics workloads on your data in Apache HBase. Also, you can use these tools to bulk import/export data into Apache HBase tables, or use Apache Hive to join data from Apache HBase with external tables on Amazon S3.

Apache HBase is wide-column store, allowing you to define arbitrary columns for each row for filtering purposes. Additionally, HBase adds a timestamp to each cell and can keep previous versions, allowing you to easily store and access the lineage of a dataset. Each cell is a byte array and can store a payload in the MB range, giving you flexibility in data types stored in your table. Apache Phoenix and Apache Hive enable SQL access over Apache HBase tables.

You can easily launch a fully-configured Amazon EMR cluster running Apache HBase and other Apache Hadoop and Apache Spark ecosystem applications in minutes. Amazon EMR enables you to use Amazon S3 as a data store for Apache HBase, automatically replaces poorly performing nodes, and you can easily resize your cluster to meet your requirements. You can manage tables and browse data in Apache HBase using the Hue UI, and easily backup and restore tables to Amazon S3 using EMRFS and Hadoop MapReduce. Additionally, Apache HBase on Amazon EMR can utilize Amazon EMR’s authorization and encryption feature sets. Click here for more details about Amazon EMR features.

FINRA – the Financial Industry Regulatory Authority – is the largest independent securities regulator in the United States, and monitors and regulates financial trading practices. FINRA uses Amazon EMR to run Apache HBase on Amazon S3 for random access on 3 trillion records (growing by billions per day) for an interactive application to search and display related market events. By decoupling their storage and compute, FINRA can store a single copy of their data in Amazon S3 and size their cluster for the compute capacity needed, rather than size their cluster for storing data in HDFS with 3x replication. This amounts to cost savings of over 60% per year, easy scalability of compute, and reducing the restoration time of a cluster in a new EC2 availability zone from days to less than 30 minutes.

Monster, a global leader in connecting people and jobs, utilizes Apache HBase on Amazon EMR to store clickstream and advertising campaign data for downstream analytics. This enables them to monitor how different customer segments are performing in a given campaign at the granularity of a single impression. Monster’s analytics team can easily scan through rows to aggregate the number of views and clicks per user to identify campaign activity. Additionally, they utilize Apache HBase’s tight integration with the Apache Hadoop ecosystem. Monster runs Apache Hive on a separate Amazon EMR cluster to query their HBase table with SQL, which is useful for additional analytics and exporting data from Apache HBase to Amazon Redshift.