TrustRadius: an HG Insights company

Apache Hive vs. OpenText Vertica

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Apache Hive

    Score8 out of 10
    N/AApache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.N/A

    OpenText Vertica

    Score9.4 out of 10
    N/AThe Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica is owned and supported by OpenText.N/A
    Pricing
    Apache HiveOpenText Vertica
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Apache HiveOpenText Vertica
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details
    More Pricing Information
    Community Pulse
    Apache HiveOpenText Vertica
    Considered Both Products
    Apache
    Chose Apache Hive
    We selected Hive because it supports SQL, schema and provides structure on top of hadoop. Having data structured has its benefits, especially if there are thousands of users processing on the same data over and over again. Pig provides the ability to process unstructured data. …
    Incentivized
    OpenText
    Chose OpenText Vertica
    Presto would be a good solution that would be less expensive and would also allow direct querying of all our data on Hadoop while maintaining good speed.
    Incentivized
    Chose OpenText Vertica
    Vertica is great for small low complex queries and has great query performance over the other technologies that I have worked with.
    Vertica fails to Hive wrt scalability and resource isolation, where Hive exploits Hadoop's resource isolation.
    Presto is almost comparable to …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    User Ratings
    Apache HiveOpenText Vertica
    Likelihood to Recommend
    8.0
    (35 ratings)
    8.0
    (7 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    8.5
    (7 ratings)
    -
    (0 ratings)
    Support Rating
    7.0
    (6 ratings)
    7.9
    (2 ratings)