What's New In Apache Pinot 1.2.0?

Summary

Victor Gof introduces Apache Pinot 1.2, an open-source real-time analytics database, highlighting its new features, performance improvements, and bug fixes. Enhancements include multi-stage query engine functions for trend analysis and running averages, JSON indexing improvements, and an 'isJson' function. UPSERTs now have a consistency model configuration, and SQL query formatting in the console is introduced for better usability. With over 400 commits and contributions from around the world, Apache Pinot 1.2 offers a robust solution for real-time analytics and complex joins, catering to a wide range of use cases.

Takeaways

• 🌐 Apache Pinot 1.2 is an open-source, real-time analytical database supported by companies like Uber, LinkedIn, and Cisco.
• 🔍 It includes enhancements in the multi-stage query engine introduced in version 1.1, allowing for complex join-like operations.
• 📈 New functions like 'lag', 'lead', 'first', and 'last value' are available for trend analysis and running averages.
• 📘 Improvements have been made in JSON indexing and handling, with a new function 'isJson' to check if text is a JSON object.
• 🔄 UPSERTs (UPSERTs are a combination of UPDATE and INSERT) have a new consistency model configuration for better customization to specific use cases.
• 🛡️ There are performance enhancements and security improvements in Apache Pinot 1.2.
• 🖌️ A quality of life feature is the ability to format SQL queries directly within the Pinot query console for better readability.
• 🌟 The release is a result of over 400 commits and contributions from over three dozen committers worldwide.
• 📚 Listeners are encouraged to visit p.apache.org to download the latest artifacts and binaries.
• 📝 For a detailed blog post about new features and improvements, go to Star Tree.
• 🙌 The video is presented by Victor Goff, emphasizing the collaborative spirit of open-source contributions to the Apache Pinot project.

Q & A

What is the main topic of the video?

The main topic of the video is an overview of the features and improvements in Apache Pinot 1.2, an open-source real-time analytical database.

What is Apache Pinot?

Apache Pinot is an open-source, real-time analytical database that is used for massive data and real-time insights, supported by companies like Uber, LinkedIn, and Cisco.

What new features are introduced in Apache Pinot 1.2?

Apache Pinot 1.2 introduces new functions like lag, lead, first, and last value for trend analysis and running averages, improvements in JSON indexing, a new function to check if a text is a JSON object, and upsert configuration enhancements.

What is the purpose of the multi-stage query engine in Apache Pinot?

The multi-stage query engine allows users to perform complex join-like operations directly within Apache Pinot.

What is the significance of the 'isJson' function in Apache Pinot 1.2?

The 'isJson' function helps to verify if a particular piece of text is a JSON object, which is useful for JSON enthusiasts and improves JSON handling in the database.

What is an upsert in the context of Apache Pinot?

An upsert (update or insert) is a widely used feature in Apache Pinot that allows for updating a record if it exists or inserting it if it doesn't, with new consistency model configurations in Apache Pinot 1.2.

What quality of life feature is mentioned for the Apache Pinot query console?

The ability to format SQL queries within the Apache Pinot query console is a quality of life feature that helps with readability and organization of the queries.

How many commits are there between the previous version and Apache Pinot 1.2?

There are over 400 commits between the previous version and Apache Pinot 1.2.

What does the speaker encourage the audience to do after watching the video?

The speaker encourages the audience to visit p.apache.org to download the latest artifacts and binaries and to go to Star Tree to read a detailed blog post about the new features and improvements.

Who is the speaker in the video?

The speaker in the video is Victor Gof.

How can one contribute to the Apache Pinot project?

One can contribute to the Apache Pinot project by making commits and participating in the open-source collaboration, as highlighted by the speaker mentioning contributions from all over the world.