For me the ease of use and versatility. Having tried the others, Presto, Impala, Dremio, none really work as well for my use cases. The fact that I can write a query to join data from an API with a PCAP, with zero schema prep is really incredible. I've also always appreciated that Drill uses standard SQL rather than a proprietary dialect of SQL is a huge win because it means the learning curve is muj lower.

Bottom line, a user can unzip Drill and with very minimal work, explore their data no matter where it is, with minimal config. This works as well on a laptop as a big cluster.