Starrocks is a very popularity olap database. It is really worthy to add a connector for starocks
@colagy Currently, there are no plans to add a connector to Starrocks. What format does Starrocks store the data in? Is ti a columnar format?
What format does Starrocks store the data in? Is ti a columnar format?
Yeah, it’s an OLAP database - a fork of Apache Doris.
Starrocks is Postgres compatible, but they do not support prepared statements yet, which I believe is why you’re getting that exception @colagy (Older versions of Dremio had the same shortcoming).
However, when Starrocks 3.2 is released that would likely work with Dremio’s Postgres connector, but other blockers might obviously turn up.
The above said, a native Starrocks connector would be able to use some of Starrocks native query capabilities more efficiently than through the Postgres connector. It would be a nice addition for sure.
We currently run Dremio clusters on top of Iceberg tables, but we are keeping an eye on Starrocks/Apache Doris developments, since there is great support for continuously updated, materialised views as well as more index options to enable efficient queries (where Iceberg and hence Dremio still are in the early stages IMHO).