Data Eng Weekly


Hadoop Weekly Issue #177

04 July 2016

There were several announcements this week out of Hadoop Summit—HDP 2.5 preview, open-source software from Qubole and LinkedIn, and Mapr's Spyglass Initiative. In terms of technical articles, there are two themes: tutorials (walkthroughs for StreamSets, Mesos, and Sqoop) and data management (a post from Twitter and details about Gobblin and Samza at LinkedIn).

Technical

Activision Game Science has published microbenchmarks of several Apache Kafka clients for python. Confluent's client, which is based on librdkafka (a C/C++ library), has the best performance.

http://activisiongamescience.github.io/2016/06/15/Kafka-Client-Benchmarking/

Hortonworks has a post about some of the features planned for upcoming releases of Apache Zeppelin. These include pluggable visualization, collaboration via Git, multi-user support, and more.

http://hortonworks.com/blog/apache-zeppelin-road-ahead/

This tutorial demonstrates how to load time series data from a Raspberry Pi to Apache Cassandra using the StreamSets Data Collector.

https://streamsets.com/blog/ingesting-sensor-data-raspberry-pi-streamsets-data-collector/

LinkedIn has the first post in a series on hard problems in stream processing, and how they're working to solved them at LinkedIn. The post mentions how they handle late data with Apache Samza as well as how they can use Samza (rather than a batch system) for reprocessing. Finally, the talk also mentions how folks are integrating Siddhi into Samza for complex event processing.

https://engineering.linkedin.com/blog/2016/06/stream-processing-hard-problems-part-1-killing-lambda

MapR has a tutorial for deploying and configuring a Mesos cluster with the Marathon scheduler, Docker support, and the ability to run Spark jobs on Mesos. Once configured, it's possible to drop into an interactive Spark shell or use spark-submit to run a job.

https://www.mapr.com/blog/using-mapr-mesos-marathon-docker-and-apache-spark-deploy-and-run-your-first-jobs-and-containers

Apache Sqoop is a tool for moving data between relational databases and Hadoop clusters. The AWS blog has a walkthrough describing how to use Sqoop with Amazon EMR (Hadoop-as-a-service) and Amazon RDS (RDBMS-as-a-service). The tutorial uses MySQL and loads data from S3 into a database table.

http://blogs.aws.amazon.com/bigdata/post/Tx3UGJSBC3GVFOK/Use-Sqoop-to-Transfer-Data-from-Amazon-EMR-to-Amazon-RDS

MapR has a tutorial for Apache Spark in which S&P 500 and oil stocks are compared using data frames and Spark SQL. The post is a good overview of the DataFrame and SQL APIs (e.g. showing the physical plan via explain).

https://www.mapr.com/blog/using-apache-spark-sql-explore-sp-500-and-oil-stock-prices

Last week's issue had a post that looked at Google's data search platform. This week, Twitter wrote about their discovery and consumption tools. This includes items like data lifecycle management, a data explorer (which has example code snippets and a wiki-like metadata management interface), and lineage information. The post also has a section about lessons learned and observations.

https://blog.twitter.com/2016/discovery-and-consumption-of-analytics-data-at-twitter

In the first of (what I assume will be) many slides from Hadoop Summit, this presentation benchmarks various file formats. There are some expected results (such as Parquet and ORC being efficient in size for multiple data sets) as well as some unexpected ones (a dataset in which Avro and JSON compress better than ORC and parquet due to redundancy within rows).

http://www.slideshare.net/oom65/file-format-benchmarks-avro-json-orc-parquet

News

ODPi has announced that Altiscale, ArenaData, Hortonworks, IBM, and Infosys distributions are all ODPi Runtime compliant. Pivotal has a post about how Pivotal HDB (built on the incubator project Apache HAWQ) benefits from runtime compatibility via ease of integration.

https://www.odpi.org/news/announcement/2016/06/apache%E2%84%A2-hadoop%C2%AE-distributions-now-odpi-runtime-compliant
https://blog.pivotal.io/big-data-pivotal/case-studies/case-study-pivotal-hdb-shows-simplicity-of-odpi-interoperability

Hadoop Summit was this week. ZDNet has a good overview of major news (ODPi, Hortonworks announcements, and more). The Hortonworks blog has a post based on CEO Rob Bearden's keynote on how big data is transforming the enterprise across all industries.

http://www.zdnet.com/article/hadoop-summit-news-ecosystem-order-and-fragmentation/
http://hortonworks.com/blog/data-will-transform-everything/

At the Summit, Hortonworks and Microsoft announced that Azure HDInsight is Hortonworks' premier cloud solution.

http://hortonworks.com/blog/microsoft-highlighted-hortonworks-premier-cloud-solution/

Pepperdata has announced a free diagnostic report for Hadoop clusters. The software analyzes the cluster for 72 hours to produce recommendations.

http://siliconangle.com/blog/2016/06/27/pepperdata-offers-a-free-health-check-for-hadoop-users/

Apache Bahir is a new top-level project that's been created by extracting several plugins and connectors from Apache Spark. In its initial form, Bahir supports four streaming extensions for Apache Spark but expansion to other platforms (e.g. Flink, Beam) is planned.

https://blogs.apache.org/foundation/entry/the_apache_software_foundation_announces96

Releases

Hortonworks announced a preview of HDP 2.5 at Hadoop Summit this week. The release includes integrating governance and security via Apache Atlas and Apache Ranger, improvements to Apache Zeppelin and Spark's support for ORC files, improved Apache Ambari support for Apache HBase, Hive's new "Live Long and Prosper" (LLAP) support for sub-second queries, and Hortonworks Connected Data Cloud (HCDC) for launching Hive/Spark clusters. LLAP and HCDC are the focus of separate blog posts from Hortonworks.

http://hortonworks.com/blog/latest-innovation-within-hortonworks-data-platform-hdp-2-5-unveiled/
http://hortonworks.com/blog/llap-enables-sub-second-sql-hadoop/
http://hortonworks.com/blog/quickly-launch-hortonworks-data-platform-amazon-web-services/

Quark is a new open-source project from Qubole. Built with Apache Calcite for SQL and JDBC support, Quark is a system for centrally managing data and optimizing queries across multiple data backends.

http://www.qubole.com/blog/quark-control-and-optimize-sql-across-hadoop-and-rdbms/

In another open-source announcement this week, Qubole has open-sourced RubiX. RubiX is a caching engine for Presto and Apache Hive that stores data on local disk when source data is stored in Amazon S3. It exposes a new FileSystem interface and can do column-based caching for columnar storage formats.

https://www.qubole.com/blog/product/rubix-fast-cache-access-for-big-data-analytics-on-cloud-storage/

LinkedIn has released version 0.7.0 of Gobblin. Previous focussed on HDFS data ingestion from Kafka, Gobblin now supports more data lifecycle features like distributed copies between clusters and data retention (via a dataset configuration file). The post has more information about Gobblin at LinkedIn and also includes some example configuration files.

https://engineering.linkedin.com/blog/2016/06/announcing-gobblin-0-7-0--going-beyond-ingestion

Apache Drill 1.7.0 was released with support for JMX monitoring, data stored in HBase 1.x, and more. The new version also resolves a number of bugs.

https://drill.apache.org/docs/apache-drill-1-7-0-release-notes/

Apache Slider 0.91.0-incubating was released this week. This release includes phase 2 of Slider's support for integrating Docker-based applications with YARN. It also includes a number of bug fixes and improvements.

http://mail-archives.apache.org/mod_mbox/incubator-slider-dev/201606.mbox/%3C57740548.1060807%40apache.org%3E

MapR has announced the Spyglass Initiative for administering MapR clusters. MapR Monitoring, the first phase of the initiative, is built on ElasticSearch, OpenTSDB, Kibana, Grafana, and more.

https://www.mapr.com/blog/introducing-spyglass-initiative

StreamSets has released version 1.5.0 of their Data Collector with new support for automatically creating Hive schemas, reading/writing data from/to Redis, a new HTTP client processor, and more.

https://streamsets.com/blog/announcing-data-collector-ver-1-5-0-0/

schema-registry-ui, as the name suggests, is a UI for the confluent schema registry. It include access to schemas, version information, example curl commands, and more.

https://github.com/landoop/schema-registry-ui

Events

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

UNITED STATES

California

Building (And Running) Netflix's Data Pipeline Using Apache Kafka (San Francisco) - Tuesday, July 5
http://www.meetup.com/SF-Big-Analytics/events/230998107/

Big Data Day LA 2016 (Los Angeles) - Saturday, July 9
http://www.meetup.com/Future-Chief-Data-Scientists-in-Orange-County-CA/events/230467427/

Arizona

Building Custom Big Data Integrations (Tempe) - Wednesday, July 6
http://www.meetup.com/Phoenix-Hadoop-User-Group/events/230407089/

Georgia

StreamSets, for the Coding Minimalist in All of Us (Atlanta) - Wednesday, July 6
http://www.meetup.com/Atlanta-Hadoop-Users-Group/events/230661523/

Virginia

Intro to Apache Apex & Comparison with Spark Streaming (Sterling) - Wednesday, July 6
http://www.meetup.com/Big-Data-native-Hadoop-Ingest-and-Transform-DC-Area/events/232031817/

Beyond ETL: Real-Time, Streaming Architectures (Arlington) - Thursday, July 7
http://www.meetup.com/DC-Cloudera-User-Group/events/231893740/

New York

Stream Processing Using Spring Cloud Data Flow (New York) - Tuesday, July 5
http://www.meetup.com/NYC-SUG/events/232197164/

UNITED KINGDOM

Can Machines See the Invisible? Plus, Building a Data Infrastructure at Scale (London) - Tuesday, July 5
http://www.meetup.com/Data-Science-Festival-London/events/231621570/

Big Data Presents... Spark in the Real World (London) - Tuesday, July 5
http://www.meetup.com/BigDataPartnership/events/231273511/

Productionising Data Science (London) - Thursday, July 7
http://www.meetup.com/data-science-lab/events/231965219/

Apache Flink London: July Meetup (London) - Thursday, July 7
http://www.meetup.com/Apache-Flink-London-Meetup/events/231739483/

FRANCE

Apache Spark & Bluemix (Paris) - Wednesday, July 6
http://www.meetup.com/Big-Data-Developers-in-Paris/events/232192958/

ITALY

Knime Italy Meetup Goes Big Data on Apache Spark (Milano) - Tuesday, July 5
http://www.meetup.com/Italy-KNIME-Users/events/231713847/

ISRAEL

Event Data Pipelines (Tel Aviv-Yafo) - Sunday, July 10
http://www.meetup.com/Big-Data-Israel/events/230511588/

JAPAN

Talk about Big Data Tools: Spark, Hadoop, Scala (Tokyo) - Friday, July 8
http://www.meetup.com/ABEJA-Innovation-Meetup/events/232049557/

NEW ZEALAND

Spark Meetup (Auckland) - Tuesday, July 5
http://www.meetup.com/Auckland-Apache-Spark-User-Group/events/231701644/