https://pinot.apache.org/ logo
#general
Title
# general
j

Jinal Panchal

05/02/2022, 12:42 PM
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?
m

Mayank

05/02/2022, 1:06 PM
j

Jinal Panchal

05/02/2022, 1:12 PM
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?
m

Mayank

05/02/2022, 1:37 PM
Not at the moment. You need to denormalize the tables upfront, or can use presto/trino for joins.
j

Jinal Panchal

05/02/2022, 1:44 PM
Okay, so is pinot not built for applications where we need relations or relational use case?
m

Mayank

05/02/2022, 1:48 PM
It is not a relational database, it is an OLAP datastore
👍 1