Hello, I've started exploring Pinot..
So is there any way to define primary key & foreign key relationships so that we can maintain mapping?
Because, how will it support join without maintaining relationships?
So, there is no way to maintain relationships, right?
We have use case like there is student table & subject table, which has foreign key relationship based on subjectID.
So, is there any way by which it supports hibernate-ORM like functionality to update/modify child table(referenced) based on parent table(referencing) modification?
05/02/2022, 1:37 PM
Not at the moment. You need to denormalize the tables upfront, or can use presto/trino for joins.
05/02/2022, 1:44 PM
Okay, so is pinot not built for applications where we need relations or relational use case?
05/02/2022, 1:48 PM
It is not a relational database, it is an OLAP datastore