Data Eng Weekly


Hadoop Weekly Issue #74

15 June 2014

With Hadoop Summit in recent memory, there are several posts from or summarizing the summit in this week’s newsletter. Technical articles cover a wide range of topics from Hive and Pig tips to logging infrastructure at Loggly. SQL-on-Hadoop was also a big topic this week—discussions about the need for it to drive Hadoop adoption.

Technical

The Mortar blog has a post with some tips for using Apache Pig. It features some lesser-known features of Pig such as writing UDFs in JavaScript, data sampling, and casting a relation to a scalar. If you use Pig and are looking to level-up your game, this is a great place to start.

http://blog.mortardata.com/post/88485590701/13-things-you-didnt-know-you-could-do-with-pig

HDFS RAID is a mechanism to use erasure codes instead of replicas in HDFS. Glossing over the technical details (which are covered in this article), you can do 2.2x or 1.4x replication instead of 3x, which makes for huge savings on large clusters. Facebook has posted about their experience deploying HDFS RAID to save petabytes of storage. There are a lot of tips and details on problems they faced in the road to reclaiming lots of storage space.

https://code.facebook.com/posts/536638663113101/saving-capacity-with-hdfs-raid/

Loggly, who makes a log management service, has written about their usage of Apache Kafka. Kafka let them simplify their deployment, which lets them process hundres of thousands of events per second. They also talk about some of the technical details and operational concerns of their deployment (such as what machines they use on AWS and how they control resource utilization).

http://www.developer-tech.com/news/2014/jun/10/why-loggly-loves-apache-kafka-how-unbreakable-infinitely-scalable-messaging-makes-log-management-better/

Apache Flink (incubating), formerly known as stratosphere, is a next generation processing framework with similar goals to other frameworks like Apache Tez and Apache Spark. This post explains the philosophy and design behind Flink, which is heavily influenced by relational database optimizers. Essentially, Flink will try to rearrange or rewrite the pipeline you've described in order to improve performance based on statistics and other knowledge of the underlying data.

http://blog.mikiobraun.de/2014/06/future-big-data-flink-stratosphere.html

There are quite a few options for running SQL queries against data stored in Hadoop (HDFS, HBase, or API-compatible File Systems). This post covers a number of them—Apache Hive, Impala, Presto, Shark, Apache Drill, Pivotal HAWQ, IBM BigSQL, Apache Pheonix, and Apache Tajo. For each one, there’s an overview of the tool and recommendation for when to use it.

http://blog.matthewrathbone.com/2014/06/08/sql-engines-for-hadoop.html

The MapR blog has a tutorial on deploying Apache Accumulo 1.5 on MapR 3.1. The tutorial walks through the various MapR FileSystem and Accumulo configuration settings.

http://www.mapr.com/blog/get-best-both-worlds-how-install-accumulo-your-mapr-cluster

The Hortonworks blog has a post on using Cascading to build a flow for parsing log files, grouping by IP, and generating counts per IP. The post has the code and a full walkthrough of how the code works.

http://hortonworks.com/blog/logparsing-with-cascading/

The Apache Accumulo summit was this week, and there were a number of great presentations. This one on scaling Accumulo clusters has lots of details on its under-pinnings, which help it support large datasets at high throughputs.

http://www.slideshare.net/acordova00/large-scale-accumulo-clusters

The SF Data Mining meet up recently featured a presentation entitled "Mining Big Data for Apache Spark." Hakka Labs has a video of the presentation, which features the MLLib library from Spark and a live demo of the tools.

http://www.hakkalabs.co/articles/introduction-mining-big-data-apache-spark

This post shows how to use Apache Spark to classify the Reuters 1987 dataset. The code for the tutorial is written in Scala and features XML parsing (using SAX), stemming/tokenization using Lucene, computing TF-IDF, and building a naive bayes model. The code for the example is on github, and there are instructions for building the example in the post.

http://chimpler.wordpress.com/2014/06/11/classifiying-documents-using-naive-bayes-on-apache-spark-mllib/

The Cloudera blog has a post on a rolling upgrades, which is a feature of Cloudera Manager since version 4.6. While most native packages like RPMs and debs don’t allow the simultaneous install of multiple versions of a package, Cloudera Manager can distribute binaries as ‘parcels.’ This, along with the highly available NameNode, facilitate rolling restarts. The Cloudera blog has more details on the process.

http://blog.cloudera.com/blog/2014/06/how-to-easily-do-rolling-upgrades-with-cloudera-manager/

Hadoop Internals has a number of details on various parts of Hadoop. It covers Hadoop architecture, the anatomy of a MapReduce job, the various daemons in a Hadoop cluster, a list of key configuration parameters (what they affect), and more.

http://ercoppa.github.io/HadoopInternals/

This post has five tips for working with Hive. They cover two important configuration parameters, a tip on writing queries, and two builtin UDFS—percentile_approx() and histogram_numeric(). There are several example queries illustrating the tips.

http://randyzwitch.com/hive-five-hard-won-lessons/

News

The Hortonworks blog has a post with some key takeaways of Hadoop Summit. They include, momentum (highlighting the number of attendees at the summit), the rise of YARN and all the tooling around it, and enterprise Hadoop.

http://hortonworks.com/blog/hadoop-summit-reflections/

Datanami has a post on Hadoop-as-a-service and hosted Hadoop, which seem to be gaining steam. The post includes interviews with Qubole and Altiscale. There also some numbers from these and other companies showing that managed Hadoop is gaining a lot of steam.

http://www.datanami.com/2014/06/10/hosted-hadoop-gets-traction/

Big Data and Brews has a conversation with Ovum’s Tony Baer about SQL and Hadoop. The conversation, for which there is a both a video and a transcript, contains a lot of interesting points about scaling Hadoop within an organization and across many enterprises. This is where SQL comes in, because many BI tools and applications (which are driving forces for scaling Hadoop) expect to pull back data via SQL.

http://www.datameer.com/ceoblog/special-big-data-brews-hadoop-summit-ovum-tony-baer-sql-on-hadoop/

ScalingData is a new company founded by several Cloudera veterans to build tools using Hadoop to help companies with IT operations. This week, they announced $4.4M in funding to build their platform.

http://blogs.wsj.com/venturecapital/2014/06/12/scalingdata-emerges-with-4-4m-to-build-hadoop-killer-app/

Forbes has a contributor article from SilconAngle founder John Furrier on SQL, Open Source, and Security on Hadoop. The piece highlights some of the recent advancements and new tools in the SQL-on-Hadoop market, the oft-discussed spectrum of open-source strategies for Hadoop vendors, and the role of security in enterprise adoption (which recently picked up steam with acquisitions by Hortonworks and Cloudera).

http://www.forbes.com/sites/siliconangle/2014/06/08/sql-open-source-security-stand-out-in-hadoop-ecosystem/

Releases

Spring for Apache Hadoop 2.0 reached GA this week. The new release includes support for a number of distributions, including Apache Hadoop 1.x/2.2/2.4, Pivotal HD 2.0, Cloudera CDH 5, and Hortonworks 2.1. Spring for Hadoop has tools for developing YARN applications, abstractions for reading from/writing to HDFS, and POJO support for Hadoop datasets using the Kite SDK.

http://spring.io/blog/2014/06/11/spring-for-apache-hadoop-2-0-is-now-ga

Cloudera announced Cloudera Enterprise 5.0.2 (which includes CDH 5.0.2 and Cloudera Manager 5.0.2). The new release of CM includes a fix for Impala query monitoring and CDH includes fixes for Hadoop, HBase, HDFS, Hive, Pig, and YARN.

http://community.cloudera.com/t5/Release-Announcements/Announcing-Cloudera-Enterprise-5-0-2-CDH-5-0-2-Cloudera-Manager/m-p/13512#U13512

Hortonworks announced HDP Security, which includes some new features as a result of their XA Secure acquisition. The new features include a centralized security tool, fine grained access control for HBase, Hive, and HDFS, and audit logging.

http://hortonworks.com/blog/security-data-operating-system/

Continuuity Loom 0.9.7 was released this week. Loom is a cluster provisioning and management suite for private and public clouds. The new release includes a number of changes, including cluster reconfiguration and service addition. There are more details of the release on the Continuuity blog.

http://blog.continuuity.com/post/88283918260/continuuity-loom-0-9-7-extensible-cluster-management

Events

Curated by Mortar Data ( http://www.mortardata.com )

UNITED STATES

California

Productionizing Spark Streaming, Tableau Spatial Queries, Spark Search Indexing (Mountain View) - Tuesday, June 17
http://www.meetup.com/HandsOnProgrammingEvents/events/184658722/

45th Bay Area Hadoop User Group (HUG) Monthly Meetup (Sunnyvale) - Wednesday, June 18
http://www.meetup.com/hadoop/events/129218562/

Washington State

Scalable Analytics with R and Hadoop (Seattle) - Monday, June 18
http://www.meetup.com/big-data-seattle/events/188264162/

Oregon

Big Data Technologies - Apache Spark with MapR (Portland) - Wednesday, June 18
http://www.meetup.com/Hadoop-Portland/events/182640202/

Utah

UHUG - Can a Pig Wear Lipstick? (Salt Lake City) - Wednesday, June 18
http://www.meetup.com/BigDataUtah/events/187488142/

Arizona

Leverage what you already know with BigSQL 3.0 on Hadoop (Scottsdale) - Wednesday, June 18
http://www.meetup.com/Big-Data-Developers-in-Phoenix/events/187561372/

Texas

Hortonworks Educational Workshop (Fort Worth) - Thursday, June 19
http://www.meetup.com/Fort-Worth-Analytics-Big-Data-and-Beyond/events/187106832/

Missouri

St. Louis Hadoop Users Group Meetup (Saint Louis) - Tuesday, June 17
http://www.meetup.com/St-Louis-Hadoop-Users-Group/events/184250842/

Illinois

Hello Hadoop, meet Apache Spark (Chicago) - Wednesday, June 18
http://www.meetup.com/Chicago-area-Hadoop-User-Group-CHUG/

North Carolina

SQL for Hadoop (Durham) - Monday, June 16
http://www.meetup.com/Big-Data-Developers-in-Raleigh/events/185688162/

This Ain't Your Father's Search Engine (Durham) - Thursday, June 19
http://www.meetup.com/TriHUG/events/185859302/

First meeting of the Triad Hadoop Users Group (Winston Salem) - Thursday, June 19
http://www.meetup.com/Triad-Hadoop-Users-Group/events/186091662/

New Jersey

Princeton Tech Meetup w/ Gilt Groupe (Princeton) - Wednesday, June 18
http://www.meetup.com/Princeton-Tech/events/168470402/

New York

YARN Tech Talk: The Data Operating System for Hadoop 2.0 (New York) - Tuesday, June 17
http://www.meetup.com/Big-Data-Warehousing/events/187622272/

UNITED KINGDOM

June Hadoop Meetup (London) - Tuesday, June 17
http://www.meetup.com/hadoop-users-group-uk/events/185022822/

SINGAPORE

R & Hadoop (Singapore) - Wednesday, June 18
http://www.meetup.com/R-User-Group-SG/events/166085312/

INDIA

Let’s Discuss Hortonworks Bigdata, Its Significance, Future & Training (Bangalore) - Saturday, June 21
http://www.meetup.com/Bangalore-HORTONWORKS-Hadoop-Meetup/events/187995012/

Hadoop Ecosystem (Hyderabad) - Saturday, June 21
http://www.meetup.com/hyderabad-scalability/events/182572882/

ISRAEL

Bigdataeverywhere Conference - MAPR & VERTICA (Herzeliyya) - Sunday, June 22
http://www.meetup.com/Vertica-Big-Data-Analytics-Meetup/events/185812782/