No more typing reviews! Try our Samantha, our new voice AI agent.
PeerSpot user
Owner at a tech vendor
Vendor
Sep 1, 2016
We switched from our previous solution because SQL Server did not scale.
Pros and Cons
  • "Customer Service: Excellent Technical Support: Very good"
  • "Profiling, query optimize, management."

What is most valuable?

Geospatial

What needs improvement?

Profiling, query optimize, management.

For how long have I used the solution?

1 year

What was my experience with deployment of the solution?

Some bugs, they were rapidly fixed.

Buyer's Guide
OpenText Analytics Database (Vertica)
April 2026
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,244 professionals have used our research since 2012.

What do I think about the stability of the solution?

Minute

What do I think about the scalability of the solution?

Not yet

How are customer service and support?

Customer Service:

Excellent

Technical Support:

Very good

Which solution did I use previously and why did I switch?

SQL Server did not scale.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees
Vendor
Sep 1, 2016
We could use it to offer Analytics As A Service to our customers.
Pros and Cons
  • "Customer Service: Excellent! Technical Support: Excellent!"
  • "Yes, there is a functionality in Vertica "Broadcast" that high the process level of our Network Switch Core. I had a serious problem with this because I interrupted the network service in the company."

Valuable Features

Manage big data fast and easy.

Room for Improvement

The time that the mediation process takes and historical information that I can store.

Deployment Issues

Yes, there is a functionality in Vertica "Broadcast" that high the process level of our Network Switch Core. I had a serious problem with this because I interrupted the network service in the company. We have to change "Point to point".

Customer Service and Technical Support

Customer Service:

Excellent!

Technical Support:

Excellent!

Other Solutions Considered

Yes, Netezza and SAP HANA.

Other Advice

I would like HP to help me to do more uses cases with Vertica. We are very interested in becoming a Business Partner in order to offer Analytics As A Service to our customers.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
OpenText Analytics Database (Vertica)
April 2026
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,244 professionals have used our research since 2012.
PeerSpot user
Data Scientist at a tech vendor with 201-500 employees
Vendor
Top 20
Sep 1, 2016
We were able to implement new algorithms without having to move data out of Vertica into a compute cluster.
Pros and Cons
  • "We were able to implement new algorithms without having to move data out of Vertica into a compute cluster."
  • "More Machine Learning algorithms--Random Forest for sure!"

Valuable Features

User Defined Extensions

Analytic Functions

Improvements to My Organization

We were able to implement new algorithms without having to move data out of Vertica into a compute cluster. This allowed us to offer Analytics for Cybersecurity to our customers.

Room for Improvement

More Machine Learning algorithms--Random Forest for sure!

Customer Service and Technical Support

Customer Service:

Very responsive

Technical Support:

Excellent

Implementation Team

In-house

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Data Scientist at a tech services company with 501-1,000 employees
Real User
Sep 1, 2016
We're able to test more models and improve accuracy.
Pros and Cons
  • "We could run group by queries thousand of times faster, we are able to test more models and improve accuracy."

    Valuable Features

    Group by performance

    Analytic functions

    Improvements to My Organization

    We could run group by queries thousand of times faster, we are able to test more models and improve accuracy.

    Room for Improvement

    Debug custom functions in r.

    Use of Solution

    One year

    Deployment Issues

    None

    Stability Issues

    None

    Scalability Issues

    None

    Customer Service and Technical Support

    Customer Service:

    Great! Email response is quickly and also within reported issues are resolved.

    Technical Support:

    Ggreat, they really understand what they are talking about.

    Initial Setup

    Straightforward, very easy.

    Implementation Team

    In house

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    PeerSpot user
    Senior Database Administrator at a financial services firm with 51-200 employees
    Vendor
    Sep 1, 2016
    I like Recovery by table. I would like messages to Vertica startup commands improved.
    Pros and Cons
    • "After upgrading to latest version, VBR backup used to take more than one week to back up 70 TB of data and now it is taking about 48 hours."
    • "Improve Vertica logging and messages to Vertica startup commands."

    Valuable Features:

    Recovery by table

    Copy cluster

    Improvements to My Organization:

    VBR backup used to take more than one week to back up 70 TB of data. After upgrading to latest version, it is taking about 48 hours.

    Room for Improvement:

    Improve Vertica logging and messages to Vertica startup commands.

    Use of Solution:

    4 years

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    PeerSpot user
    Sr. Developer, Big Data at a comms service provider with 51-200 employees
    Vendor
    Aug 31, 2016
    The most valuable feature for me is the columnar data store.
    Pros and Cons
    • "Setup was very simple"

      Valuable Features:

      Columnar data store

      Room for Improvement:

      Add geospatial indexes (sounds like they have done it in version 8.0)

      Deployment Issues:

      No

      Stability Issues:

      No

      Scalability Issues:

      No

      Customer Service:

      Above average

      Initial Setup:

      Setup was very simple

      Disclosure: My company has a business relationship with this vendor other than being a customer. We are partners with HPE
      PeerSpot user
      PeerSpot user
      CIO at a tech vendor with 1,001-5,000 employees
      Vendor
      Top 20
      Aug 31, 2016
      Features valuable to me include: massive data ingestion performance and SQL standard query engine.
      Pros and Cons
      • "Massive data ingestion performance"
      • "Massive data ingestion performance."
      • "Machine learning implementations."
      • "Machine learning implementations."

      Valuable Features:

      • Massive data ingestion performance
      • Performance
      • SQL standard query engine

      Improvements to My Organization:

      DWH core platform is based on it

      Room for Improvement:

      Use of Solution:

      3 years

      Disclosure: My company does not have a business relationship with this vendor other than being a customer.
      PeerSpot user
      System Architect at a comms service provider with 10,001+ employees
      Real User
      Jul 6, 2016
      We can quickly identify with the root cause analysis where trends are.
      Pros and Cons
      • "We're just now getting into Vertica, but it allows us to store and access big data very quickly."
      • "If you're working in a small business, it will tend to overtake most of their budget from a cost perspective because you need so many servers, so much storage, to be able to handle all that stuff."

      Valuable Features:

      We're just now getting into Vertica, but it allows us to store and access big data very quickly. It comes down to being able to quickly identify where the root cause analysis is and where trends are, so you can actually try to almost predict where problems are before they really become a problem.

      Improvements to My Organization:

      The ability to access in-store, big data, and be able to create keywords for faster resolution and look up an individual, hey we did this problem before. It'll show you all the steps and everything, along with different products. Vertica is pretty much the database behind it. It really does the performance aspect of it.

      Room for Improvement:

      I guess really the only thing there is if you get a server big enough to handle Vertica, it does just fine. If you're working in a small business, it will tend to overtake most of their budget from a cost perspective because you need so many servers, so much storage, to be able to handle all that stuff.

      Stability Issues:

      It's very stable.

      Initial Setup:

      We had no issues deploying it.

      Other Solutions Considered:

      I did not really look at any competition. Basically, it's like I said, we're an HP shop and a lot of their applications are going to a Vertica database for its storage and processing of data. We were doing a lot of Oracle, but Oracle was actually moving towards Vertica in our environment.

      Other Advice:

      Make sure you understand how much data that you're going to be incorporating into the big data, so you can actually define the amount of storage and redundant storage appropriately.

      Disclosure: My company does not have a business relationship with this vendor other than being a customer.
      PeerSpot user
      Buyer's Guide
      Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros sharing their opinions.
      Updated: April 2026
      Buyer's Guide
      Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros sharing their opinions.