Is there any ORM build for apache pinot rather tha...
# general
s
Is there any ORM build for apache pinot rather than writing sql query everytime with https call?
t
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
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
Also consider that Pinot is an OLAP. ORM tend to be more suitable for relational databases.
➕ 1
s
Mongoose is a non relational database ORM widely used everywhere
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?