Skip to Content
Building Real-Time Analytics Systems
book

Building Real-Time Analytics Systems

by Mark Needham
September 2023
Beginner to intermediate
220 pages
4h 36m
English
O'Reilly Media, Inc.
Content preview from Building Real-Time Analytics Systems

Chapter 10. Geospatial Querying

AATD’s users were very pleased with the publishing of an order’s status in the pizza shop app. It’s allowed them to see that their order is making progress and has also given them some indication of when it’s likely to be delivered. But now that they’ve had a taste of real-time data, they want more!

The customer success team has received multiple requests for the pizza shop app to include a delivery tracker that shows where an order is once it leaves AATD’s kitchen. In addition, AATD’s operations team would like to be able to locate delivery vehicles. On multiple occasions, deliveries have been delayed due to traffic problems, and they’d like to be able to identify which vehicles are affected so that they can notify customers of a potential delay.

To add this functionality, we’ll need to update the orders service to publish locations to a new deliveryStatuses stream. That stream will then be consumed by Apache Pinot, and we’ll update the /orders/<order_id> endpoint to include the latest location. We will also go back and include the delivery latitude and longitude coordinates in the orders stream and add columns for those values to the equivalent table in Apache Pinot.

The traffic problems feature will also use the deliveryStatuses stream, but we’ll add a new /orders/delayed/<area> endpoint to identify affected vehicles. This endpoint will be consumed by a new section of the dashboard.

Figure 10-1 shows the new pieces of infrastructure.

Figure ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Building Real-Time Analytics Applications

Building Real-Time Analytics Applications

Darin Briskman
Advanced Analytics with PySpark

Advanced Analytics with PySpark

Akash Tandon, Sandy Ryza, Uri Laserson, Sean Owen, Josh Wills
Graph-Powered Analytics and Machine Learning with TigerGraph

Graph-Powered Analytics and Machine Learning with TigerGraph

Victor Lee, Phuc Kien Nguyen, Alexander Thomas
Architecting Data and Machine Learning Platforms

Architecting Data and Machine Learning Platforms

Marco Tranquillin, Valliappa Lakshmanan, Firat Tekiner

Publisher Resources

ISBN: 9781098138783Errata Page