Data Eng Weekly


Hadoop Weekly Issue #206

26 February 2017

Lots of releases this week, including the Apache Kafka 0.10.2.0 release and maintenance releases of Apache NiFi and Apache Cassandra. Kafka is also the subject of two technical posts—one on Kafka Connect streaming of data in FTP and the other on change data capture.

Technical

The Landoop blog has a post and sample code that shows how to load data from files on an FTP server to Kafka using Kafka Connect. They have example implementations for XML (using the Iradiance Solar Data set), CSV files, and binary compressed files. The demo also showcases open-source Kafka tools built by Landoop, including web uis for the Confluent schema registry and Kafka Connect.

http://www.landoop.com/blog/2017/02/ftp-to-kafka/

WePay has an article about their change data capture solution for MySQL, which uses Debezium to stream data to Kafka. WePay is on the Google Cloud Platform, so the MySQL instances are running in Google CLoudSQL, and from Kafka data is loaded into BigQuery. The post goes into the finer operational details, including how to add a new database to Debezium/Kafka, how they make use of the new global transaction IDs added in MySQL 5.6, and how streaming data that comes out of Debezium looks.

https://wecode.wepay.com/posts/streaming-databases-in-realtime-with-mysql-debezium-kafka

This presentation has a great overview of best practices and anti-patterns when it comes to Hadoop. There's a good graphical representation of small/medium/big data (and when Hadoop/Spark become appropriate), several alternatives to Hadoop for small/medium data, and a few slides on the cost/benefit of big data systems (i.e.. you won't have data integrity in a Hadoop cluster, you will likely need a data infra team of 4-5 people to run a cluster, but you'll see advantages of data centralization, fault tolerance, and programatic data access).

https://veekaybee.github.io/data-lake-talk/#/

As the central source of truth for metadata about your data, it's quite important for the Hive Metastore to be up to date. Previously, this could be a challenge in a cloud environment in which there are multiple transient clusters that come and go unpredictably. Recently, Hadoop and CDH added support for a persistent Hive Metastore that lives independent of any one cluster. This post has some basics of configuring the metastore and the list of gotchas/assumptions to keep in mind.

http://blog.cloudera.com/blog/2017/02/how-to-set-up-a-shared-amazon-rds-as-your-hive-metastore/

This post describes APIs and tools for working with nested data in Spark and Spark SQL. It covers things like how to extract fields out of a nested struct and how to convert a json string to a struct on which normal operations can be performed.

https://databricks.com/blog/2017/02/23/working-complex-data-formats-structured-streaming-apache-spark-2-1.html

The AWS Big Data blog has an overview of building a complex application (using 10 different AWS services from Amazon EMR to AWS CodePipeline) for data analysis, search and discovery, and more. The tutorial uses data from the Police Data Initiative.

https://aws.amazon.com/blogs/big-data/harmonize-search-and-analyze-loosely-coupled-datasets-on-aws/

Releases

trivup is a tool for programmatically building / tearing down a Kafka cluster. It supports Kafka's SSL authentication and encryption for client applications.

https://github.com/edenhill/trivup

Version 0.2.0 of Apache Arrow, the in-memory columnar data format, has been released. This version has been validated to ensure compatibility across the Java and C++/Python implementations. The release also contains a new streaming binary format and better interoperability with Python pandas.

https://lists.apache.org/thread.html/%3CCAJPUwMCXvZEji1Ajyt9T6xNdvne2sXb15d4oZ-vKC6q+TWL23w@mail.gmail.com%3E

Apache Kafka 0.10.2.0 was released. This is a significant release containing over 500 pull requests from over 100 authors. Major features of the release include a new Kafka Streams API for session windows, improved compatibility for Java clients, improved semantics for Kafka Streams joins, and single message transforms in Kafka Connect.

https://lists.apache.org/thread.html/%3C1487752382.3724173.888950176.7131421B@webmail.messagingengine.com%3E

Apache Bahir 2.10 was released. Bahir is an add-on library for Apache Spark that brings support for Akka streaming, MQTT streaming, Twitter streaming, and ZeroMQ streaming.

https://lists.apache.org/thread.html/%3CCAMm+_4QQaa8id7qTKCRG7bzTmQpuQZv9s1jb2RXd365uYemqFA@mail.gmail.com%3E

Apache NiFi 0.7.2 and 1.1.2 were both released this week. Both releases include a fix for a NullPointerException.

https://cwiki.apache.org/confluence/display/NIFI/Release+Notes#ReleaseNotes-Version0.7.2
https://cwiki.apache.org/confluence/display/NIFI/Release+Notes#ReleaseNotes-Version1.1.2

Apache Cassandra announced patch releases for several major versions: 3.0.11, 2.2.9, and 2.1.17. There are quite a few improvements/fixes in each one (e.g. the 3.0.11 release resolves over 60 tickets).

http://cassandra.apache.org/download/

Events

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

UNITED STATES

California

Graph Talk w/ Uber Graph Team and Netflix (Palo Alto) - Thursday, March 2
https://www.meetup.com/UberEvents/events/237855330/

Streaming with MapR and StreamSets Data Collector (San Jose) - Thursday, March 2
https://www.meetup.com/SF-Bay-Area-Data-Ingest-Meetup/events/237537968/

Arizona

Bio-Manufacturing Optimization Using Apache NiFi, Kafka, and Spark (Tempe) - Wednesday, March 1
https://www.meetup.com/Phoenix-Hadoop-User-Group/events/237235414/

Missouri

Real-Time Ingestion & Event Processing with Apache NiFi (Saint Louis) - Wednesday, March 1
https://www.meetup.com/St-Louis-Hadoop-Users-Group/events/236343756/

Illinois

Building Streaming Data Applications Using Kafka (Chicago) - Thursday, March 2
https://www.meetup.com/ChicagoRealTimeStreamingAnalytics/events/237343071/

Florida

MongoDB and Reactive Streams with Kafka (Miami) - Tuesday, February 28
https://www.meetup.com/Miami-Hadoop-User-Group/events/237760222/

Virginia

Big Data Journey: An Introduction to SQL on Hadoop (Reston) - Monday, February 27
https://www.meetup.com/NOVASQL/events/234976334/

CANADA

Introduction to MapR (Toronto) - Thursday, March 2
https://www.meetup.com/Toronto-MapR-User-Group/events/231648976/

UNITED KINGDOM

Big Data and Machine Learning (London) - Tuesday, February 28
https://www.meetup.com/Big-Data-and-Machine-Learning-London/events/235957841/

FRANCE

Stream Analytics, BI, and DevOps with Hadoop (Issy-les-Moulineaux) - Tuesday, February 28
https://www.meetup.com/futureofdata-paris/events/237469193/

NETHERLANDS

Apache Flink's Stateful Operators and Table SQL API (Amsterdam) - Thursday, March 2
https://www.meetup.com/Apache-Flink-Meetup-Amsterdam/events/237213989/

GERMANY

Data Wrangling & Spark^2 (Berlin) - Tuesday, February 28
https://www.meetup.com/Big-Data-Beers/events/236872716/

Apache Kafka & Event Sourcing (Bonn) - Thursday, March 2
https://www.meetup.com/Bonner-Microservices-Meetup/events/237638087/

CROATIA

Lambda Architecture with Spark at Farmeron (Zagreb) - Wednesday, March 1
https://www.meetup.com/Apache-Spark-Zagreb-Meetup/events/236896137/

GREECE

Stream All the Things with Lightbend (Athens) - Tuesday, February 28
https://www.meetup.com/Athens-Big-Data/events/237458303/

INDONESIA

March Clustering: Hadoop and Big Data (Jakarta) - Saturday, March 4
https://www.meetup.com/Jakarta-Hadoop-Big-Data/events/236836619/

AUSTRALIA

Spark 101 (Brisbane) - Tuesday, February 28
https://www.meetup.com/Brisbane-Data-Analytics-Meetup/events/237056054/

NEW ZEALAND

Learning to Scale and Learning from Scale (Christchurch) - Tuesday, February 28
https://www.meetup.com/Christchurch-Big-Data-Meetup/events/237349366/