Skip to main content

Apache Pinot – SD Times Open Source Project of the Week

Apache Pinot is an open-source analytics platform that utilizes an OLAP database to provide low-latency insights into large amounts of data.

OLAP stands for Online Analytical Processing and is a method in which data from multiple sources can be used together, allowing companies to group data from websites, applications, internal systems, and more together for analysis.

“For example, a retailer stores data about all the products it sells, such as color, size, cost, and location. The retailer also collects customer purchase data, such as the name of the items ordered and total sales value, in a different system. OLAP combines the datasets to answer questions such as which color products are more popular or how product placement impacts sales,” AWS wrote in a post explaining OLAP.

Key features of Apache Pinot include low-latency queries, the ability to handle hundreds of thousands of concurrent queries per second, batch and streaming ingestion, versatile joins, rich indexing options, and more.

It was first created at LinkedIn in 2013 because the company wanted to provide its users interactive analytics, but with the amount of data LinkedIn had already amassed at that time, it was struggling to find something that could scale at the level it needed.

“Pinot was born as an answer to our problems, a web-scale real-time analytics engine designed and built at LinkedIn. Pinot enables us to slice, dice and scan through massively large quantities of data in real-time across a wide variety of products,” said Praveen Neppalli Naga, engineering manager at LinkedIn at the time, wrote in a blog post when the project was first announced.

It powers 25 of LinkedIn’s user-facing features such as Who Viewed My Profile, Company Follow Analytics, Jobs Analytics, and more, as well as over 30 of the company’s internal tools, such as its A/B testing platform.

In 2018, Apache Pinot joined the Apache Software Foundation as an incubator project and became a top-level project in 2021.

Since its creation it has been adopted by a number of major companies, including Robinhood, Slack, Stripe, Target, Uber, and Walmart.

The most recent release is 1.1, which came out in March, adding features such as vector index support and multi-stage query engine improvements.

Looking forward, some of the things the project maintainers are working on in 2024 include making V2 on-by-default, enabling column null storing by default, full PostgreSQL compliance, pagination, and continuing ease-of-use updates such as improved documentation, more user friendly error messages, and more.

The post Apache Pinot – SD Times Open Source Project of the Week appeared first on SD Times.



from SD Times https://ift.tt/G3CSocx
Labels:

Comments

Post a Comment

Popular posts from this blog

Difference between Web Designer and Web Developer Neeraj Mishra The Crazy Programmer

Have you ever wondered about the distinctions between web developers’ and web designers’ duties and obligations? You’re not alone! Many people have trouble distinguishing between these two. Although they collaborate to publish new websites on the internet, web developers and web designers play very different roles. To put these job possibilities into perspective, consider the construction of a house. To create a vision for the house, including the visual components, the space planning and layout, the materials, and the overall appearance and sense of the space, you need an architect. That said, to translate an idea into a building, you need construction professionals to take those architectural drawings and put them into practice. Image Source In a similar vein, web development and design work together to create websites. Let’s examine the major responsibilities and distinctions between web developers and web designers. Let’s get going, shall we? What Does a Web Designer Do?
Post a Comment
Read more

A guide to data integration tools

CData Software is a leader in data access and connectivity solutions. It specializes in the development of data drivers and data access technologies for real-time access to online or on-premise applications, databases and web APIs. The company is focused on bringing data connectivity capabilities natively into tools organizations already use. It also features ETL/ELT solutions, enterprise connectors, and data visualization. Matillion ’s data transformation software empowers customers to extract data from a wide number of sources, load it into their chosen cloud data warehouse (CDW) and transform that data from its siloed source state, into analytics-ready insights – prepared for advanced analytics, machine learning, and artificial intelligence use cases. Only Matillion is purpose-built for Snowflake, Amazon Redshift, Google BigQuery, and Microsoft Azure, enabling businesses to achieve new levels of simplicity, speed, scale, and savings. Trusted by companies of all sizes to meet
Post a Comment
Read more

2022: The year of hybrid work

Remote work was once considered a luxury to many, but in 2020, it became a necessity for a large portion of the workforce, as the scary and unknown COVID-19 virus sickened and even took the lives of so many people around the world.  Some workers were able to thrive in a remote setting, while others felt isolated and struggled to keep up a balance between their work and home lives. Last year saw the availability of life-saving vaccines, so companies were able to start having the conversation about what to do next. Should they keep everyone remote? Should they go back to working in the office full time? Or should they do something in between? Enter hybrid work, which offers a mix of the two. A Fall 2021 study conducted by Google revealed that over 75% of survey respondents expect hybrid work to become a standard practice within their organization within the next three years.  Thus, two years after the world abruptly shifted to widespread adoption of remote work, we are declaring 20
Post a Comment
Read more