How does Vertica compare to Google Dremel?
Vertica is much better!
The architecture of Dremel is quite similar to the architecture of Pig and Hive.
Since Dremel is not available outside of Google you might look into Vertica vs Impala/Apache Drill.
Vertica provides the following advantages:
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.