3 ms·

How does Drill compare to more popular tools like Hive and Presto?

• aksakalli 5y ago
  I used Apache Drill to query json line log files stored in Azure Blob. It is very easy to configure and run it. I used in embedded mode for not so big queries and some visualisation in Apache Superset. It worked really well. I created some views in parquet to speed it up. Be aware, there is no such thing as schemaless, Drill is schema on-read and if your files contain changing schemas, it is painful to workaround all the errors you face. JSON is too ambiguous when it comes to types.
• cowsandmilk 5y ago
  If the “Director of Customer Solutions” for the company selling presto feels the need to write a blog post declaring Apache drill dead, that might be a sign that it is actually competing pretty well with presto.
  • atombender 5y ago
    Well, I was seeking a technical comparison.
• g8oz 5y ago
  Presto has been rebranded to Trino. Trino supports MATCH_RECOGNIZE from the SQL:2016 standard which is pretty cool. The only database engine that does that so far is Oracle.
  • deleted 5y ago
    [deleted]