Data Eng Weekly


Hadoop Weekly Issue #214

30 April 2017

While cloud vendors have been adding impressive features to their SaaS SQL-on-big data engines, other vendors are trying to demonstrate the benefit of their non-hosted products. A couple of weeks ago, Hortonworks was blogging about Hive LLAP and this week Cloudera is touting Impala. Regardless of which camp you're backing, the competition is good for end users.

Technical

Amazon Redshift has added new mechanisms to optimize a cluster by by performing certain tasks when a rule (written in their new engine) is violated. For example, they show how to terminate a long running query that is generating too many rows or using too much CPU and not completing after a certain amount of time. The system also has the ability to log details or "hop" a query to a different queue.

https://aws.amazon.com/blogs/big-data/manage-query-workloads-with-query-monitoring-rules-in-amazon-redshift/

Apache Ambari, which is used for managing Hadoop clusters, has a new feature for interacting with Apache Hive in version 2.5. Dubbed "Hive View 2.0," Ambari can now perform most operations against the Hive metastore, including viewing and computing table/column statistics (which are used by the optimizer). Additionally, the new release includes a visualizer for the Hive optimizer (to visualize EXPLAIN output).

https://hortonworks.com/blog/3-great-reasons-to-try-hive-view-2-0/

With the caveat that it's important to take a critical eye to vendor benchmarks (and try with your own data), Cloudera has posted impressive benchmark numbers for Impala. They've compared to Greenplum and several Hadoop-ecosystem engines (including Spark SQL, Hive with LLAP, and Presto) using data from the TPC-DS kit in both multi user and single user scenarios.

http://blog.cloudera.com/blog/2017/04/apache-impala-leads-traditional-analytic-database/

The Hortonworks blog has an overview of Livy, which is a server that exposes HTTP APIs for interacting with a Spark cluster. The post looks at both the programmatic API, and the RESTful endpoints that can be used to run both a batch job and an interactive session. The post also describes Livy's security and high availability features.

https://hortonworks.com/blog/livy-a-rest-interface-for-apache-spark/

The Databricks blog has a tutorial that describes how to use Spark's structured streaming with Apache Kafka as the source (and sink) of data. The post includes a real-world example of processing JSON event data from a Nest device.

https://databricks.com/blog/2017/04/26/processing-data-in-apache-kafka-with-structured-streaming-in-apache-spark-2-2.html

Cloudera has two posts on their new Cloudera Data Science Workbench. In the first, they describe how to write a PySpark job that uses a python library (python packaging is different from the JVM's JAR files, which is often a pain point in these types of applications). In the second, they show how to use BigDL (a deep learning library for Apache Spark) with the workbench.

http://blog.cloudera.com/blog/2017/04/use-your-favorite-python-library-on-pyspark-cluster-with-cloudera-data-science-workbench/
http://blog.cloudera.com/blog/2017/04/bigdl-on-cdh-and-cloudera-data-science-workbench/

The LinkedIn blog has a post about how they've transformed testing for their Content Analytics system. By building out a number of mock functions and libraries, they're able to write unit tests for the Kafka/Samza jobs that execute in a few minutes. Previously, testing was UI driven and took days or weeks to complete.

https://engineering.linkedin.com/blog/2017/04/test-strategy-for-samza-kafka-services

The StreamSets Data Collector is using the same expression language (EL) as is supported in JSP, and it's easy to write a custom function as is described in this post.

https://streamsets.com/blog/custom-expression-language-function-streamsets-data-collector/

News

Apache Metron, which is a security-focused analytics system built on the Apache Hadoop ecosystem, has graduated from the Apache incubator.

https://blogs.apache.org/foundation/entry/apache-software-foundation-announces-apache

Videos of presentations for Flink Forward San Francisco, which took place earlier this month, have been posted.

https://www.youtube.com/channel/UCY8_lgiZLZErZPF47a2hXMA

It's been just over a year since Apache Apex became a top-level project. The post celebrates community growth (number of contributors, pull requests, and others), adoption (including a few examples), the major features released over the past year, and the roadmap for the project looking forward.

http://www.atrato.io/blog/2017/04/25/one-year-apex/

Cloudera's IPO was Friday. Shares went for $15 and jumped 20% the first day bringing Cloudera's market cap to $2.3 billion.

https://techcrunch.com/2017/04/28/cloudera-finishes-up-20-in-stock-market-debut/

Releases

Version 0.11.0-incubating of Apache PredictionIO was released. PredictionIO is a framework for building predictive services built on Apache Spark, Apache HBase, Spray, and Elasticsearch.

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

Version 0.3.0 of Scio, the Scala API for Apache Beam, was released. This is the first non-beta release that is built on the Apache Beam SDK rather than Google Cloud Dataflow SDK.

https://github.com/spotify/scio/releases/tag/v0.3.0

Apache Kafka 0.10.2.1 was released to fix a number of bugs in the 0.10.2.0 release.

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

Apache Gearpump (incubating) has released version 0.8.3-incubating. Gearpump is a streaming engine built on the Actor model.

http://mail-archives.apache.org/mod_mbox/incubator-gearpump-dev/201704.mbox/%3CCAH3zwfJr8qt9_zwR44158beOvrdpd-kYKK%2BpZReZCzJ2XEpc4Q%40mail.gmail.com%3E

Events

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

UNITED STATES

California

Interacting with Spark: Beyond the Basics (San Diego) - Wednesday, May 3
https://www.meetup.com/San-Diego-Spark-and-Big-Data-Meetup/events/232713066/

Hands-On Workshop in Real-Time Analytics, Stream Processing with Twitter Heron (Santa Clara) - Saturday, May 6
https://www.meetup.com/datariders/events/237836216/

Missouri

Near Real-Time Ingest with StreamSets Data Collector (St. Louis) - Wednesday, May 3
https://www.meetup.com/St-Louis-Hadoop-Users-Group/events/237432642/

LITHUANIA

Meetup #9 (Vilnius) - Wednesday, May 3
https://www.meetup.com/Vilnius-Hadoop-Meetup/events/239447710/

GREECE

Scaling Data Pipelines + Master BigQuery and Redshift (Athens) - Wednesday, May 3
https://www.meetup.com/Athens-Big-Data/events/239088154/

NEW ZEALAND

An Informal Session with Cloudera and Doug Cutting, the Father of Hadoop (Auckland) - Tuesday, May 2
https://www.meetup.com/NZ-Big-Data/events/239171245/

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