Data Eng Weekly


Hadoop Weekly Issue #196

11 December 2016

Lots of great content this week, including two articles showing off the newly released Amazon Athena. Slack has also written about their AWS-based data infrastructure and some of the challenges they ran into when supporting multiple analysis systems. Finally, there are a handful of releases, including a new version of Apache Hive.

Technical

A common practice is to run batch processes (Spark, MapReduce) to produce a dataset (often key/value) for serving in production. Netflix has open-sourced their tool, Hollow, for serving up these read-only datasets. It has some neat optimizations to memory footprint as well as a history tool for inspecting how data is changing by specific record.

http://techblog.netflix.com/2016/12/netflixoss-announcing-hollow.html

Amazon has published a 5 part series on optimizing performance of Redshift through improved table design. Topics covered include distribution keys, sort keys, compression encoding, and data durability.

https://aws.amazon.com/blogs/big-data/amazon-redshift-engineerings-advanced-table-design-playbook-preamble-prerequisites-and-prioritization/

This post shows a real-world example of using Amazon's recently announced Athena (which is based on Presto) to analyze logs produced by an Application Load Balancer and stored in S3.

https://medium.com/@robwitoff/athena-alb-log-analysis-b874d0958909

The SNOW theorem formalizes a set of design trade-offs that most people building high performance systems have considered for years. The notion is that of Strict serializability, Non-blocking, One response per read, and Write transactions, you can choose three but not all four when designing a system. As usual, the morning paper has a great overview of the key concepts from the paper.

https://blog.acolyer.org/2016/12/06/the-snow-theorem-and-latency-optimal-read-only-transactions/

InfoQ has posted the slides and video from Confluent co-founder and CTO Neha Narkhede's QCon presentation entitled "ETL is Dead, Long-live streams." If you're interested in stream processing and haven't seen Neha speak, I highly recommend watching to understand the concepts and architecture that are driving much of the industry.

https://www.infoq.com/presentations/etl-streams

This post provides a quick walkthrough of getting starting with Apache Kafka using the Clojure language.

https://dataissexy.wordpress.com/2016/12/06/quick-recipe-for-kafka-streams-in-clojure/

For a more involved example of Amazon Athena, this post describes first preparing genomics data (by among other things, converting to Apache Parquet) using Apache Spark. Next, there are example queries to do various simple aggregate analysis using Athena.

https://aws.amazon.com/blogs/big-data/interactive-analysis-of-genomic-datasets-using-amazon-athena/

The data engineering team at Slack has written about their AWS-based data platform. They store data as Parquet in S3 and query it using Apache Hive, Apache Spark, and Presto. Each tool has its own subtle bugs or inconsistencies in how it interacts with Parquet data (there are several examples in the post), so the Slack team eventually built their own input/output formats to ensure consistency.

https://slack.engineering/data-wrangling-at-slack-f2e0ff633b69

This post describes the various YARN-related memory settings as well as some of the main culprits for exhausting memory in a MapReduce job.

http://grepalex.com/2016/12/07/mapreduce-yarn-memory/

NOPaxos, which relies on Network Ordering, is an alternative to Paxos that offers better performance within the data center. It relies on a multicast network primitive in which all receivers process messages in the same order but in which some messages can be lost. The morning paper has details on the algorithm and how it performs in an experimental setting.

https://blog.acolyer.org/2016/12/08/just-say-no-to-paxos-overhead-replacing-consensus-with-network-ordering/

The Databricks blog has an example of using Apache Airflow (incubating) to manage a Databricks cluster using their REST API. Even if you're not using Databricks, the post has a useful introduction to Airflow.

https://databricks.com/blog/2016/12/08/integrating-apache-airflow-databricks-building-etl-pipelines-apache-spark.html

The Cloudera blog has a post sharing some snippets for working with CSV files from Spark. Versus a non-distributed version, Spark provides excellent speedups and also offers the ability to transform to optimized formats like Parquet.

http://blog.cloudera.com/blog/2016/12/achieving-a-300-speedup-in-etl-with-spark/

The DataTorrent blog has a post about the process of integrating the Apache SAMOA streaming machine learning library with Apache Apex.

https://www.datatorrent.com/blog/machine-learning-apache-apex-apache-samoa/

News

insideBIGDATA has an interview with Confluent's Gwen Shapira about the fast data movement (which is often powered by Kafka) and some of the key challenges that an organization will face when building real-time streaming systems.

http://insidebigdata.com/2016/12/07/interview-gwen-shapira-system-architect-at-confluent/

Releases

Apache NiFi announced version 0.1.0 of MiNiFi for Java and C++. The C++ version isn't yet consider production-ready, and the Java version includes important new features like the ability to do pull-based configuration changes.

https://cwiki.apache.org/confluence/display/MINIFI/Release+Notes#ReleaseNotes-Version0.1.0
https://cwiki.apache.org/confluence/display/MINIFI/Release+Notes#ReleaseNotes-Versioncpp-0.1.0

BlueData announced that BlueData EPIC is now GA on Amazon Web Services. EPIC is a tool for managing big data systems, and it supports multiple different distributions of Hadoop, hybrid clouds, resource quotes on AWS, and more.

http://www.bluedata.com/blog/2016/12/now-available-bluedata-epic-on-aws/

Apache Apex Malhar, the operator and codec library for Apex, has announced version 3.6.0. It is the first version to include SQL support (built via Apache Calcite) and includes several other improvements.

https://lists.apache.org/thread.html/ac15d9a3dffb3ccc249bdf1a52c87494236d19f1868b46e8a30ea283@%3Cusers.apex.apache.org%3E

Apache Hive 2.1.1 has been released. There are over 200 resolved issues for the release. Many of those are bug fixes, including to Hive's Live Long and Prosper support.

https://lists.apache.org/thread.html/e07062d78e6c71ab32d04f152875213a4ecf3f921e4bfc0d15992dce@%3Cuser.hive.apache.org%3E

MapR has announced version 2.0 of their MapR Ecosystem Packs. The release includes new versions of Spark, Drill, Kafka (including Connect and the REST Proxy), Hue, and more.

https://www.mapr.com/blog/announcing-mapr-ecosystem-pack-mep-20

kafka-connect-jmx is a new kafka connect module that pulls data from JMX for a Java process and writes it Kafka as JSON.

https://github.com/srijiths/kafka-connectors/tree/master/kafka-connect-jmx

Events

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

UNITED STATES

California

Streaming for Personalization Datasets at Netflix (Sunnyvale) - Tuesday, December 13
https://www.meetup.com/SF-Big-Analytics/events/235587939/

Using Apache Spark for Machine Learning (Santa Clara) - Tuesday, December 13
https://www.meetup.com/Cognitive-Computing-Enthusiasts/events/235765599/

Washington

Kafka: Introduction and Internals (Bellevue) - Wednesday, December 14
https://www.meetup.com/Seattle-Data-Science-and-Data-Engineering/events/235440870/

Texas

December Austin Data Meetup (Austin) - Monday, December 12
https://www.meetup.com/austindata/events/234943853/

Trevor Grant Tells Us about What's Next for Apache Mahout (Plano) - Tuesday, December 13
https://www.meetup.com/DFW-BigData/events/235724693/

Missouri

Big Data Pipelines/Flows, Use Case–Driven Comparison: Apache NiFi & StreamSets (Kansas City) - Friday, December 16
https://www.meetup.com/Kansas-City-Big-Data-Projects-Group/events/235755597/

Georgia

Hands-On Intro to Apache Spark for Data Engineers, Data Scientist and Developers (Atlanta) - Tuesday, December 13
https://www.meetup.com/Big-Data-Developers-in-Atlanta/events/235964718/

District of Columbia

Data Processing with Zeppelin/Solr/Spark/Nifi (Washington) - Wednesday, December 14
https://www.meetup.com/Data-Wranglers-DC/events/235937152/

Pennsylvania

Hands-On: Data Science at Scale with HAWQ and MADlib and Hadoop (Philadelphia) - Wednesday, December 14
https://www.meetup.com/futureofdata-philadelphia/events/235463696/

New Jersey

I'm Being Followed by Drones: TensorFlow, HDF 2.0, Phoenix, Python, Zeppelin (Princeton) - Wednesday, December 14
https://www.meetup.com/futureofdata-princeton/events/235677253/

New York

How Apache Spark Will Disrupt the Media Industry (New York) - Wednesday, December 14
https://www.meetup.com/Data-Science-Analytics-for-Communications-Industry/events/236024973/

How Nielsen Leverages Data & Machine Learning for Real-Time Analytics (New York) - Thursday, December 15
https://www.meetup.com/mysqlnyc/events/235443113/

NORWAY

Big Data, No Fluff: Let’s Get Started with Hadoop #11 Julbord (Oslo) - Thursday, December 15
https://www.meetup.com/Oslo-Hadoop-Big-Data-Meetup/events/231886514/

SPAIN

Apache Flink in Action (Madrid) - Thursday, December 15
https://www.meetup.com/Meetup-de-Apache-Flink-en-Madrid/events/235573467/

FRANCE

100% Performance: Hadoop & Vertica... with Criteo and Ogury! (Paris) - Thursday, December 15
https://www.meetup.com/Big-Data-et-Machine-Learning/events/235017910/

NETHERLANDS

Real-Time Transactional SQL on Hadoop (Amsterdam) - Thursday, December 15
https://www.meetup.com/futureofdata-amsterdam/events/235413487/

Streaming Machine Learning on Flink (Amsterdam) - Friday, December 16
https://www.meetup.com/Apache-Flink-Meetup-Amsterdam/events/234964131/

GERMANY

Big Data, Berlin v10.0 (Berlin) - Thursday, December 15
https://www.meetup.com/Big-Data-Berlin/events/235326650/

AUSTRIA

Hadoop User Group Meetup @ IBM Client Center (Vienna) - Tuesday, December 13
https://www.meetup.com/Hadoop-User-Group-Vienna/events/235411846/

HUNGARY

Powering the Future of Data in the Cloud (Budapest) - Wednesday, December 14
https://www.meetup.com/futureofdata-budapest/events/235817845/

ROMANIA

2nd Apache Kafka Workshop (Cluj-Napoca) - Wednesday, December 14
https://www.meetup.com/Big-Data-Data-Science-Meetup-Cluj-Napoca/events/236068479/

ISRAEL

Continuously Deploying Big Data Pipelines with Amaterasu (Tel Aviv-Yafo) - Thursday, December 15
https://www.meetup.com/Big-things-are-happening-here/events/236051216/

RUSSIA 2016 Hadoop Meetup (Moscow) - Friday, December 16
https://www.meetup.com/Hadoop-Moscow/events/235776276/