Hive

Hive was my first foray into data warehouse tools (other than a super clunky, outdated tool for pulling limited SQL results from a single table at a time). The ability to query across multiple tables, to quickly examine schemas, and to track your previous queries and results was huge in enabling us to experiment with new ways of scripting back-end processes with immediate, hands-on results. It was also able to plug directly into other areas of our workflow without much issue - we pulled data directly from Hive into Tableau, and we queried data from Hive in R to perform QA.

Overall, Hive works for our Marketing team and customer service is exceptional (especially [SENSITIVE CONTENT HIDDEN]).

The biggest frustration is that we tested a few systems and chose Hive because it combined messaging, we liked the look of it, and the ability to link external apps if desired. The ultimate reason we chose Hive, though, was because when tested, projects with a date range for a due date showed up at the beginning of that range, which is exactly what we needed and no other system did that. However, a month after we switched and installed, that changed and they now show on the due date which causes issues (and extra messages and meetings) for our team to make sure stuff is being worked on proactively.

We've had a large amount of issues with recurring actions and auto-snooze as mentioned above and I've reported it several times.

We've had Hive around 8-10 months and just went through redoing our entire workspace to hopefully make it more streamlined due to the systemic issues we were having. With that, I'll say there are several ways to utilize Hive and you can find what fits for your team.

So overall, good and bad - mostly good.