Is there any ORM build for apache pinot rather than writing sql query everytime with https call?
t
Tim Veil
01/12/2024, 5:13 PM
not that i'm aware of but we do have a jdbc driver if you'd be more comfortable using that instead of calling the rest endpoints directly
Tim Veil
01/12/2024, 5:19 PM
i haven't tried it with pinot but i've used JOOQ in the past as a way to generate sql. since pinot uses fairly standard sql, its possible you could use jooq to generate pinot compatible sql
h
Hubert Dulay
01/17/2024, 12:30 PM
Also consider that Pinot is an OLAP. ORM tend to be more suitable for relational databases.
➕ 1
s
Sumitra Saksham
01/18/2024, 10:43 AM
Mongoose is a non relational database ORM widely used everywhere
Sumitra Saksham
01/18/2024, 10:43 AM
When we are writing a backend, we have 2 options:
1. Write individual logic functions with SQL Query
2. Write our own parser logic for the schema, we created
Wouldn't it be good if we can create schema in the form of object and then use it to query?