Pinot has been the de-facto analytics program used by LinkedIn for more than two years to provide insight to information like profile views, company follow analytics and A/B testing analytics. The program provides an OLAP datastore that emphasizes scalability, low latency, data freshness, and high availability. It uses data from Hadoop and Kafka, and provides an SQL-like query language that includes functionality such as: filtering, aggregation, group by, order by, and distinct entries. The source code can be acquired on GitHub, and the project wiki has detailed information about why and how you might want to use this software.
