Apache Druid vs. Grist

It is extremely well suited to rapid ingest of data from large data sources, due to the fact that you can restrict what is ingested by column/field, so that you only pull in the data you actually want or need.

As stated earlier, the open source version could use better cluster management tools, and troubleshooting tools for failing jobs/tasks.

This is well suited to someone (or a team) who are technically minded and have a dataset that they need to be able to use in many ways. It's less appropriate for a team who isn't technically minded and/or don't have the data they need to manipulate. It would be useful for things that you could use a database or spreadsheet for such as CRM, Advertising database, Business tracking, Health tracking etc.

Incentivized

• Rapid ingest
• Limiting ingest to only the relevant fields/columns
• Easy ingest spec creation

• Provides amazing customer service, help, examples, and explains what they are having you do
• The layout is easy

• Security configuration is problematic
• Cluster management could have more features
• Troubleshooting incomplete tasks/jobs is a chore

• Making the user permissions more obvious on how to use them - They are highly adaptable, but hard to understand how to use them
• Small changes such as auto colouring the choices/toggles options and being able to edit them once set.
• Being able to copy the formatting from one column to the next

Incentivized

Grist is easier to use, faster, and loads quicker with heavy data.

• Integration with S3 storage has saved about 35% on our storage, over HDFS
• The rapid ingest has saved user's time in the query aspects of their applications.
• The ability to ingest from a variety of data sources has made overall user application queries much simpler

• It's saved a lot of time in both creating an advertising database and managing it week to week effectively. I had previously created in others that haven't worked, and this does, saving me a good 1 hour weekly, and 5 hours or more each time I had problems with the last ones
• Being able to stay on track with this has meant I'm following up at the right time (advertisers) and keeping a professional manner and not losing business due to missed communication
• Saving me $ from buying a program like Access (or Airtable monthly) and then the learning curve that that has. This has a much easier learning curve to say the least.

Incentivized