Data Eng Weekly


Hadoop Weekly Issue #111

08 March 2015

This week there were three announcements of new open-source tools/projects for the Hadoop ecosystem: Airpal (for Presto DB) from Airbnb, json utils for Apache Pig from Mortar, and a new kafka-mesos framework. There are several good technical articles across encryption, YARN, Hive, Spark, Presto, Samza, and more. The Tachyon project also gets two mentions this week, including an analysis suggesting it's picking up steam.

Technical

Encryption, which plays an important role in compliance, was recently added to many components in the Hadoop ecosystem. Intel (who is an investor in Cloudera) played a major role in the implementation as well as in adding speedups for Intel processors (using Intel AES-NI). In this post, Intel describes the basics of Hadoop encryption using hardware acceleration and provide some performance results from a single node running CDH 5.2.

https://software.intel.com/en-us/articles/cloudera-hadoop-single-node-encryption-performance-case-study-on-intel-xeon-e5-2600-v3

The MapR blog has a guide describing how to run MapReduce jobs in non-JVM languages with Hadoop Streaming (not to be confused with stream processing).  The guide describes how Hadoop Streaming exchanges data with the external process, and it has examples for perl and python.

https://www.mapr.com/blog/how-using-non-java-programs-or-streaming-mapreduce-jobs

Hortonworks has a technical overview of the Hive 0.14 cost-based optimizer (CBO). The post describes the steps of query optimization, several types of optimizations (e.g. for left-deep joins and bushy-joins), illustrated examples of how the CBO improves join order, join simplification, and some performance numbers.

http://hortonworks.com/blog/hive-0-14-cost-based-optimizer-cbo-technical-overview/

Hortonworks has a second post in a series describing fault-tolerance for long-running services in YARN. This post describes new features in the ApplicationMaster (AM)—previously a restart of the AM would restart all container it launched. The post describes the strategy that YARN uses to preserve running containers as well as the new AM retry windows which removes the upper-limit on the number of AM restarts.

http://hortonworks.com/blog/apache-hadoop-yarn-hdp-2-2-fault-tolerance-features-long-running-services/

The Apache Spark community has been working on DataFrames, a new type of distributed collection. There was recently a presentation on DataFrames at the Spark User Meetup—the slides and video are now available online.

http://www.slideshare.net/databricks/introducing-dataframes-in-spark-for-large-scale-data-science
https://www.youtube.com/watch?v=vxeLcoELaP4

This post has a lot of interesting ideas about replacing a database (described as mutable global state) with a distributed immutable event log. There's a video of a presentation from Strange Loop, and the presentation has also been transcribed (with slides inline). The talk describes how to implement a number of these ideas with Apache Kafka and Apache Sazma, and it includes many important ideas for anyone working with distributed systems.

http://blog.confluent.io/2015/03/04/turning-the-database-inside-out-with-apache-samza/

This post describes some of the types of applications and challenges that arise with the internet of things, which produces lots of timeseries data. NoSQL databases like HBase and MapR DB are optimized for common-queries on these types of data, and the post describes further techniques for optimizing the storage footprint (via the schema that OpenTSDB uses).

https://www.mapr.com/blog/time-series-databases-upside-down-internet-whiteboard-walkthrough

This post, the first in a series, looks at building a similarity graph for health-care providers and computing personalized PageRank to identify anomalies. The analysis uses the Medicare Part-B public domain dataset, and the software (Pig and Python) is available on github.

http://hortonworks.com/blog/using-pagerank-detect-anomalies-fraud-healthcare/

The Cloduera blog has a guest post describing how to use Apache Spark for financial analytics calculations. Specifically, the authors look at how to calculate credit valuation adjustments, which use Monte-Carlo simulations. There is some sample code, using PySpark and a python machine learning library (MLIB).

http://blog.cloudera.com/blog/2015/03/calculating-cva-with-apache-spark/

Hortonworks has a post on Apache Slider, a tool for deploying long-running applications on YARN. Slider, which is part of HDP 2.2, includes support for running Apache HBase, Apache Accumulo, and Apache Storm. The post describes how slider works and some of the benefits of deploying a YARN application user Slider.

http://hortonworks.com/blog/deploying-long-running-services-on-apache-hadoop-yarn-cluster/

The Morning Paper is doing a series on consensus in distributed systems. Last week covered a number of classic papers (e.g. "Viewstamped Replication" and "Paxos Made Simple"), and next week will cover a paper on Apache Zookeeper's protocol, a recent paper on the Raft consensus protocol, and more.

http://blog.acolyer.org/2015/03/01/cant-we-all-just-agree/

This post describes how to build a user-defined function (UDF) for Presto DB, the SQL engine open-source by Facebook. Qubole has provided an example project and describes Presto's UDF API.

http://www.qubole.com/blog/product/plugging-in-presto-udfs/

News

The Apache Flink project, which is a large-scale data processing engine with a similar API to Apache Spark, is rapidly gaining new features and integrations. This post highlights recent additions to the Flink ecosystem such as integration with Apache SAMOA (incubating), the Flink graph API, support for HCatalog, and support for Kerberos-enabled Hadoop clusters.

http://flink.apache.org/news/2015/03/02/february-2015-in-flink.html

The Qubole blog has a digest of 10 articles from the big data industry—covering everything ODP to the maturity of Hadoop to a new framework for running C/C++ code on Hadoop.

http://www.qubole.com/blog/big-data/market-rumblings/

The Call for Proposals for Strata + Hadoop World in New York is now open. Proposals are due by end of day (EDT) on April 7 for the conference which takes place Sept 29-Oct 1.

http://strataconf.com/big-data-conference-ny-2015/public/cfp/373

Cisco announced this week that they will resell software from Cloudera, Hortonworks, and MapR. Their provisioning tool supports all three distributions and is now generally available.

http://newsroom.cisco.com/press-release-content?type=webcontent&articleId=1601452

On the heels of Hortonworks' recent quarterly earnings report, there have been a number of articles analyzing the performance of the company and the Hadoop industry as a whole. Infoworld looks at both—including comparisons between Cloudera and Hortonworks and between Hadoop vendors and the other big open-source company, Red Hat.

http://www.infoworld.com/article/2893290/open-source-software/hadoop-is-booming-its-vendors-not-so-much.html

Nextgov has a story on the CIA's plans to deploy a Hadoop cluster (running Cloudera Enterprise) in Amazon Web Services' cloud for the intelligence community. In-Q-Tel, the not-for-profit venture capital firm for the intelligence community, is an investor in Cloudera.

http://www.nextgov.com/emerging-tech/emerging-tech-blog/2015/02/cias-new-big-data-hub-will-be-hosted-cloud/

The DBMS2 blog has a post on the Tachyon project (version 0.6 was released this week—more details below), which provides an in-memory distributed file system. The post gives a brief overview of Tachyon, Tachyon deployments, and some thoughts on when it's best to use Tachyon.

http://www.dbms2.com/2015/03/04/quick-update-on-tachyon/

Releases

Tachyon released version 0.6.0 this week. The new version includes support for tiered storage (e.g. memory, SSD, HDD), docker and vagrant support, and uses netty for data transfer.

https://github.com/amplab/tachyon/releases/tag/v0.6.0

Mortar (now part of Datadog, who curates the event section of this newsletter) has open-sourced some tools for working with JSON from Apache Pig. There is a JsonLoader for loading arbitrary files, and UDFs to apply (or infer) a schema for a given json dataset.

https://github.com/mortardata/pig-json

Airbnb has open-sourced Airpal, their web dashboard for running SQL queries using Facebook's PrestoDB. The tool includes table and query searching, access controls, the ability to track query process, support for creating Hive tables from results, and more. Airpal is written using Dropwizard and react.js, and the code is available on github.

http://nerds.airbnb.com/airpal/

The Kafka Mesos Framework provides the capability to run Kafka with Mesos. It includes command-line tools for adding brokers, inspecting status, and more. It's an early release (alpha quality), but a lot of functionality is built and documented in the repo readme.

https://github.com/mesos/kafka

Version 1.1.0 of Luigi, the workflow framework for big data tools, was released this week.  The most notable improvement in this release is support for Python 3. Other improvements include better support for outputting data to S3 and documentation improvements.

https://github.com/spotify/luigi/releases/tag/1.1.0

Events

Curated by Datadog ( http://www.datadoghq.com )

UNITED STATES

California

March SF Hadoop Users Meetup (San Francisco) - Wednesday, March 11
http://www.meetup.com/hadoopsf/events/219155223/

Spark or Hadoop: Is It an Either/Or Proposition? (Santa Monica) - Thursday, March 12
http://www.meetup.com/Los-Angeles-Apache-Spark-Users-Group/events/220758233/

Myriad: Integrating Hadoop into the Datacenter (San Francisco) - Thursday, March 12
http://www.meetup.com/Bay-Area-Mesos-User-Group/events/220650860/

Spark DataFrames and ML Pipelines for Large-Scale Data Science (San Francisco) - Thursday, March 12
http://www.meetup.com/Data-Mining/events/220748448/

Washington

Spark Ecosystem & Spark Streaming Fundamentals (Bellevue) - Wednesday, March 11
http://www.meetup.com/Seattle-Spark-Meetup/events/208711912/

Flume and Spark for Real-Time Ingest and Streaming (Seattle) - Thursday, March 12
http://www.meetup.com/big-data-seattle/events/220436568/

Texas

Stinger.next: Enterprise SQL at Hadoop Scale (Houston) - Wednesday, March 11
http://www.meetup.com/Houston-Hadoop-Meetup-Group/events/220619402/

Minnesota

Apache Drill Overview & Demo (Minnetonka) - Wednesday, March 11
http://www.meetup.com/Minnetonka-Big-Data-Analytics-Meetup/events/220479075/

Michigan

Vowpal Wabbit, Text Mining and Analysis with R and Using R with Hadoop (Grand Rapids) - Wednesday, March 11
http://www.meetup.com/Big-Data-and-Hadoop-Users-Group-of-West-Michigan/events/220120110/

Virginia

Big Data Security Analytics with Apache Spark and GraphX (Vienna) - Tuesday, March 10
http://www.meetup.com/bigdatadc/events/219875609/

District of Columbia

Intro on Drill: Self-Service Data Exploration & Nested Data Analytics on Hadoop (Washington) - Tuesday, March 10
http://www.meetup.com/Data-Education-DC/events/220722830/

Hadoop with Python (Washington) - Tuesday, March 10
http://www.meetup.com/DCPython/events/219999742/

Pennsylvania

Cloudera Sessions: Kickstart Your Data Journey (Pittsburgh) - Thursday, March 12
http://www.meetup.com/HUG-Pittsburgh/events/220911116/

New York

Hadoop in 2015: Implications for Data Professionals (New York) - Tuesday, March 10
http://www.meetup.com/TDWINYC/events/220547448/

Simplifying the Lambda Architecture (New York) - Thursday, March 12
http://www.meetup.com/Hadoop-NYC/events/220603667/

CANADA

Big Data and Hadoop: Just the Basics (Vancouver) - Thursday, March 12
http://www.meetup.com/Big-Data-Developers-in-Vancouver/events/220925647/

Apache Mesos, Apache Hadoop, Apache Spark + Custom Enterprise Applications (Toronto) - Thursday, March 12
http://www.meetup.com/TorontoHUG/events/220459833/

SPAIN

All You Can Eat with Hadoop (Bilbao) - Tuesday, March 10
http://www.meetup.com/elcomite/events/220708544/

FRANCE

Hands-On Spark (Paris) - Tuesday, March 10
http://www.meetup.com/Duchess-France-Meetup/events/220774444/

GERMANY

Apache Spark: First Meetup! (Berlin) - Thursday, March 12
http://www.meetup.com/Berlin-Apache-Spark-Meetup/events/199560562/

CROATIA

Introduction to Machine Learning with Spark (Zagreb) - Thursday, March 12
http://www.meetup.com/Apache-Spark-Zagreb-Meetup/events/220502390/

INDIA

Building Real-Time Applications Using Spark (Bangalore) - Saturday, March 14
http://www.meetup.com/Real-Time-Data-Processing-and-Cloud-Computing/events/220621124/

MapReduce along with Amazon EMR (Hyderabad) - Saturday, March 14
http://www.meetup.com/abctalks/events/220183567/

CHINA

Spark Meetup (Shanghai) - Saturday, March 14
http://www.meetup.com/Shanghai-Apache-Spark-Meetup/events/220914879/

If you didn't receive this email directly, and you'd like to subscribe to weekly emails please visit http://hadoopweekly.com