Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How does Vertica compare to Google Dremel?

How does Vertica compare to Google Dremel?

Answers

  • Jim_KnicelyJim_Knicely Administrator

    Vertica is much better! :wink:

  • moshegmosheg Employee

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.