How does Vertica compare to Google Dremel?

woodworkingmash

How does Vertica compare to Google Dremel?

Jim_Knicely

Vertica is much better!

mosheg

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:

• In addition to almost any cloud Vertica can run also on-prem
• Analyze All of Your Data. No longer move data or settle for siloed views
• Achieve Scale and Performance
• No fear to grow data volumes , users or concurrent activities
• Partition pruning and predicate push down also on external tables . E.g., On Parquet files
• Query-Optimized Storage
• Fully automated Database Designer tool
• Near-Real-Time Analytics in pure Column Store
• Automatic Data Marts (Flatten Tables)
• Pre-Aggregation for Cubes (LAPS)
• Freedom from Underlying Storage
• All You Need for IoT, Clickstream or Geospatial
• End-to-End ML Workflow Support
• Native JSON, Log Formats, Orc, Parquet
• Flexible architecture suits nearly any project
• Offers users the freedom to choose deployment mode,
  Shared nothing or shared everything architecture in the same product