How to connect Apache pinot (distributed data store) with Ecto?

hi ho!
i’m also trying to show realtime analyzed data and thought liveview paired with apache pinot would be cool ideal for what i’m trying to do. :stuck_out_tongue_winking_eye:
but i haven’t found any information about it yet.
has anyone of you ever connected apache pinot via ecto?
or is there another connector? :face_with_monocle:

I don’t think there’s an Ecto adapter for Pinot, but Pinot can be queried by SQL over HTTP through their query API. The only other connection that I think Pinot has is JDBC (obviously not for Elixir).

There are projects like Trino which could use your Pinot database as a source. Then you could connect with ODBC and hit your Pinot DB through Trino. Really, though, ODBC is terrible and you’d probably be much happier with Pinot’s query API.

1 Like

… thanks!
I’ll try the api then.