I researched and tested Druid two years ago(I don't know too much about
the change of Druid in these two years. New features that I know are : new
UI, fully on K8s etc).
Here are some cases you should consider using Druid other than Kylin
at the moment (using Kylin 5.0-beta to compare the Druid which I used two
years ago):
- Have a real-time datasource like Kafka etc.
- Most queries are small(Based on my test result, I think Druid had better
response time for small queries two years ago.)
- Don't know how to optimize Spark/Hadoop, want to use the K8S/public
cloud platform as your deployment platform.
But I do think there are many scenarios in which Kylin could be better,
like:
- Better performance for complex/big queries. Kylin can have a more
exact-match/fine-grained
Index for queries containing different `Group By dimensions`.
- User-friendly UI for modeling.
- Support 'Join' better? (Not sure at the moment)
- ODBC driver for different BI.(its website did not show it supports ODBC
well)
- Looks like Kylin supports ANSI SQL better than Druid.
I don't know Pinot, so I have nothing to say about it.
Hope to help you, or you are free to share your opinion.
With warm regard
Xiaoxiang Yu
On Fri, Dec 1, 2023 at 11:11 AM Nam Đỗ Duy wrote:
> Dear Xiaoxiang,
> Sirs/Madams,
>
> May I post my boss's question:
>
> What are the pros and cons of the OLAP platform Kylin compared to Pinot and
> Druid?
>
> Please kindly let me know
>
> Thank you very much and best regards
>