Book Image

Learning Apache Apex

By : Thomas Weise, Ananth Gundabattula, Munagala V. Ramanath, David Yan, Kenneth Knowles
Book Image

Learning Apache Apex

By: Thomas Weise, Ananth Gundabattula, Munagala V. Ramanath, David Yan, Kenneth Knowles

Overview of this book

Apache Apex is a next-generation stream processing framework designed to operate on data at large scale, with minimum latency, maximum reliability, and strict correctness guarantees. Half of the book consists of Apex applications, showing you key aspects of data processing pipelines such as connectors for sources and sinks, and common data transformations. The other half of the book is evenly split into explaining the Apex framework, and tuning, testing, and scaling Apex applications. Much of our economic world depends on growing streams of data, such as social media feeds, financial records, data from mobile devices, sensors and machines (the Internet of Things - IoT). The projects in the book show how to process such streams to gain valuable, timely, and actionable insights. Traditional use cases, such as ETL, that currently consume a significant chunk of data engineering resources are also covered. The final chapter shows you future possibilities emerging in the streaming space, and how Apache Apex can contribute to it.
Table of Contents (17 chapters)
Title Page
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Chapter 8. Example Project – ETL Using SQL

Classic ETL (short for, Extract, Transform, Load) applications are common in the big data world. They typically extract data from one or more external sources, such as message queues, databases, and file systems;  process them to perform some common operations, such as filtering, transforming, and enriching; and finally load the results to some data sinks, such as relational databases, files, or NoSQL datastores, where analytics queries can be run against them.

In this chapter, we will examine a sample ETL application in detail and illustrate how easy it is to construct such a pipeline using Apex and its library of operators, along with the built-in support for the SQL query planning and optimizing engine, Apache Calcite. Specifically, we will cover these topics:

  • The operators that constitute the application pipeline
  • Building the application and running the integration test
  • Configuring the application
  • Testing the application
  • Understanding the logs
  • Classes...