Vertica lost its lead a long time ago. There are better columnstore data warehouses like MemSQL and Clickhouse, and most people are just moving to the cloud with Redshift, BigQuery and Snowflake.
Druid doesn't really compete with these systems but is more of an addition if you need low-latency queries against defined and fully-indexed fields along with pre-aggregation (the source of its performance). It also has a lot more operational complexity with very basic SQL support.
As of 2020, I don't see much of a use for Druid since columnstores already support real-time updates and are adding indexing, aggregation pipelines and concurrency scaling.
Druid doesn't really compete with these systems but is more of an addition if you need low-latency queries against defined and fully-indexed fields along with pre-aggregation (the source of its performance). It also has a lot more operational complexity with very basic SQL support.
As of 2020, I don't see much of a use for Druid since columnstores already support real-time updates and are adding indexing, aggregation pipelines and concurrency scaling.