Data Eng Weekly


Hadoop Weekly Issue #221

25 June 2017

Several more articles on proprietary tools than I usually cover, but there are really interesting things to note from Google, Qubole, and Amazon Web Services. The new Hortonworks Streaming Analytics Manager looks neat, and there are a couple of articles on Kafka. Finally, the slides and videos from two recent conferences—DataWorks and Berlin Buzzwords—have been posted.

Technical

The Google Cloud Big Data blog has a post on common use cases for Cloud Dataflow. While some of the content is Google Cloud-specific, the patterns and the psuedo-code presented is largely general purpose—and it's interesting to see how Cloud Dataflow solves various problems.

https://cloud.google.com/blog/big-data/2017/06/guide-to-common-cloud-dataflow-use-case-patterns-part-1

The Qubole blog describes how they keep the Hive Metastore's statistics up to date. They've implemented a custom MetastoreEventListener to detect new tables, partitions, etc and kick of Hive ANALYZE commands to compute statistics. There are a few improvements over the naive solution—particularly throttling and batching of commands that involve multiple partitions.

http://www.qubole.com/blog/automatic-statistics-collection-better-query-performance/

Hortonworks has an in-depth look at the new Streaming Analytics Manager. The post describes the main components—service pools and environments—and describes how to build an application using the String Builder canvas. There's integration with the Hortonworks Schema Registry to automatically detect the schema from a Kafka topic and builtin support for common streaming processors like joins, projections, and aggregations.

https://hortonworks.com/blog/part-4-sams-stream-builder-building-complex-stream-analytics-apps-without-code/

Qubole has a jump start on a lot of other vendors when it comes to big data as a service. This post writes about one of their cloud-specific differentiators—Container Packing. Based on the YARN fair scheduler, container packing is a mechanism to improve the scale-down capabilities of a auto-scaling cluster to ultimately keep costs down. The post describes the high-level algorithm for container packing, and how to enable it in Qubole.

https://www.qubole.com/blog/container-packing-a-new-algorithm-for-resource-scheduling-in-the-cloud/

The Cloudera blog has an overview of various strategies for managing offsets when running Apache Spark Streaming jobs based on data in Apache Kafka. The post includes code for saving and loading offsets to Apache HBase, Apache ZooKeeper, and Kafka.

http://blog.cloudera.com/blog/2017/06/offset-management-for-apache-kafka-with-apache-spark-streaming/

This post provides an overview of how to use Kafka for streaming ETL. The tutorial uses Kafka Connect for extracting data from a relational database (including a simple transformation), running a Kafka Streams application, and then loading database to another database (once again) using Kafka Connect. The post has lots of code (which tends to be mostly configuration) and an overview of what each of these pieces is doing.

https://www.confluent.io/blog/building-real-time-streaming-etl-pipeline-20-minutes/

In this post, SparkR is used to parallelize a Markov Chain Monte Carlo calculation to improve runtime from 48 hours on a single machine to 45 minutes on a 50 node Spark cluster. The post has some a few good tips and highlights some gotchas related to SparkR.

https://databricks.com/blog/2017/06/23/parallelizing-large-simulations-apache-sparkr-databricks.html

The AWS Big Data blog has a post on best practices for Amazon Redshift Spectrum ( using Redshift to query data in S3). Among the recommendations, are suggestions for when to use Spectrum vs. Athena and how to allocate data between Redshift local storage and S3.

https://aws.amazon.com/blogs/big-data/10-best-practices-for-amazon-redshift-spectrum/

A fix for a Linux CVE is causing some Hadoop daemons to crash on startup. This post describes how to workaround the issue.

https://effectivemachines.com/2017/06/24/workaround-secure-datanode-crashes/

News

Roaring Elephant is a bi-weekly podcast about the Hadoop ecosystem. The latest episode covers Apache Zeppelin.

https://roaringelephant.org/2017/06/20/episode-45-modern-day-airships/

SearchDataManagement has a good analysis of the IBM and Hortonworks deal, including an analysis of what both companies get out of the agreement.

http://searchdatamanagement.techtarget.com/news/450421115/IBM-bets-on-Hortonworks-Hadoop-platform-as-its-big-data-engine

Videos and slides from the DataWorks Summit and Berlin Buzzwords have been posted online.

https://dataworkssummit.com/san-jose-2017/agenda/
https://berlinbuzzwords.de/17/sessions

The Confluent's Log Compaction has coverage of the upcoming Kafka 0.11.0 release, which will have exactly one semantics via an idempotent producer (among other things). The post also has links to a number of great Kafka-related blogs and presentations.

https://www.confluent.io/blog/log-compaction-highlights-in-the-apache-kafka-and-stream-processing-community-june-2017/

Confluent and is offering a free (behind an email/phone num wall) preview edition of "Kafka: The Definitive Guide."

https://www.confluent.io/resources/kafka-definitive-guide-preview-edition/

Releases

Cloudera has announced that their Cloudera Altus platform-as-a-service offering is getting support for EC2 spot instances.

http://blog.cloudera.com/blog/2017/06/announcing-support-for-spot-instances-in-cloudera-altus/

Apache Flink 1.3.1 was released. It includes a number of bug fixes, improvements to documentation, and more.

http://flink.apache.org/news/2017/06/23/release-1.3.1.html

Apache HBase 1.1.11 resolves 20 bugs over the previous patch release. The announcement includes a list of notable fixes.

https://lists.apache.org/thread.html/501f2549ea8595ebbe1ba745dbcf8f3ff62ff13f0488980a029dda1e@%3Cannounce.apache.org%3E

Apache Pig, which had its last release just over a year ago, just announced version 0.17.0 with support for Pig on Spark. This version of Pig requires a 2.7.x release of Hadoop.

https://lists.apache.org/thread.html/6b88381e8ae6646f7426b2e5bd271a9e7fa3a8cf580d0e781d00aad0@%3Cannounce.apache.org%3E

Events

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

UNITED STATES

California

Distributed Deep Learning on Apache Spark w/ BigDL (Palo Alto) - Monday, June 26
https://www.meetup.com/SF-Bay-ACM/events/239921080/

Integrating Real-Time Video Data Streams with Spark and Kafka (Culver City) - Thursday, June 29
https://www.meetup.com/Los-Angeles-Apache-Spark-Users-Group/events/239111692/

Wisconsin

IoT: Applying Machine Learning to Real-Time Sensor Data on Spark and Kafka (Madison) - Tuesday, June 27
https://www.meetup.com/BigDataMadison/events/234268511/

North Carolina

CHS: Microsoft HDI as a Big Data and Interoperability Platform (Charlotte) - Thursday, June 29
https://www.meetup.com/CharlotteHUG/events/235107629/

Virginia

Big Data Journey: Getting Up and Running with Apache Spark (Reston) - Monday, June 26
https://www.meetup.com/NOVASQL/events/236658592/

Event-Driven, Fault-Tolerant Microservices Using Kafka (Richmond) - Wednesday, June 28
https://www.meetup.com/DevOps-RVA/events/237814281/

New York

[QCon Meetup] Survival of the Fittest: Streaming Architectures (New York) - Monday, June 26
https://www.meetup.com/New-York-City-Stream-Processing-User-Group/events/240932597/

[QCon Meetup] Papers We Love w/ John, Matt, Charity, and Gwen (New York) - Monday, June 26
https://www.meetup.com/papers-we-love/events/240218464/

CANADA

Toronto Apache Spark #21 (Toronto) - Wednesday, June 28
https://www.meetup.com/Toronto-Apache-Spark/events/240593197/

UNITED KINGDOM

Stateful Stream Processing (London) - Tuesday, June 27
https://www.meetup.com/Apache-Kafka-London/events/240036301/

FRANCE

Big Data & Data Science: June Edition (Montpellier) - Thursday, June 29
https://www.meetup.com/Big-Data-Montpellier/events/240573926/

BELGIUM

Scheduling Workloads with Apache Airflow + Running Spark on Google Cloud (Gent) - Thursday, June 29
https://www.meetup.com/GDG-Cloud-Belgium/events/239870426/

GERMANY

Rethinking Stream Processing with Apache Kafka (Munich) - Wednesday, June 28
https://www.meetup.com/Apache-Kafka-Germany-Munich/events/240430333/

AUSTRIA

Building Streaming Applications with Kafka (Vienna) - Tuesday, June 27
https://www.meetup.com/Vienna-Modern-Data-Science/events/240730623/

INDIA

Apache Nifi for Hortonworks Distribution (Pune) - Saturday, July 1
https://www.meetup.com/Pune-Big-Data-Conference-Group/events/240959416/

SRI LANKA

Data Community Meetup (Colombo 2) - Tuesday, June 27
https://www.meetup.com/sldatacommunity/events/240999969/

AUSTRALIA

Data-In-Motion: Recent Advances in Apache Projects for Streaming Data (Canberra) - Thursday, June 29
https://www.meetup.com/CanberraDataSci/events/239864926/

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