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.
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?
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.