No more typing reviews! Try our Samantha, our new voice AI agent.
PeerSpot user
it_user505317
DW Admin at a hospitality company with 1,001-5,000 employees
Vendor
Sep 1, 2016
Download
It is the foundation of our new Data Warehouse platform because of the scalability and query speed.
Pros and Cons
  • "It is the foundation of our new Data Warehouse platform."
  • "There have been some issues with deleting and updating data from tables."

What is most valuable?

Scalability, query speed.

How has it helped my organization?

It is the foundation of our new Data Warehouse platform.

What needs improvement?

Data velocity and manageability.

For how long have I used the solution?

The utilization/launching project has lasted for a bit more than a year now.

Buyer's Guide
OpenText Analytics Database (Vertica)
June 2026
Free Report: OpenText Analytics Database (Vertica) Reviews and More
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
DOWNLOAD NOW
900,747 professionals have used our research since 2012.

What was my experience with deployment of the solution?

There have been some issues with deleting and updating data from tables.

What do I think about the stability of the solution?

No

What do I think about the scalability of the solution?

No

How are customer service and support?

Customer Service:

I have not been in contact with their customer service.

Technical Support:

I have not been in contact with their tech support.

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

We used Oracle but it did not scale well enough

How was the initial setup?

It was straightforward.

What about the implementation team?

I was not involved with the implementation.

What was our ROI?

Don't know.

What's my experience with pricing, setup cost, and licensing?

The pricing is very flexible

Which other solutions did I evaluate?

There was a proof of concept for a number of technologies but I wasn't involved in those.

What other advice do I have?

It looks promising.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
PeerSpot user
it_user505263
Principal Data Architect (BI) at a media company with 1,001-5,000 employees
Real User
Sep 1, 2016
Download
I like the fast analytical functions and ability to extend functionality.
Pros and Cons
  • "Customer Service: Great Technical Support: Great"
  • "Sometimes users write bad queries that has brought down the cluster."

What is most valuable?

Bulk loading data using copy

Fast analytical functions

Ability to extend functionality

How has it helped my organization?

Great reporting.

What needs improvement?

Faster deletes!

For how long have I used the solution?

4 years

What was my experience with deployment of the solution?

None

What do I think about the stability of the solution?

Sometimes users write bad queries that has brought down the cluster. Need a way to better manage resources.

What do I think about the scalability of the solution?

None

How are customer service and technical support?

Customer Service:

Great

Technical Support:

Great

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

No

What about the implementation team?

In house implementation.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
Buyer's Guide
OpenText Analytics Database (Vertica)
June 2026
Free Report: OpenText Analytics Database (Vertica) Reviews and More
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
DOWNLOAD NOW
900,747 professionals have used our research since 2012.
PeerSpot user
it_user505260
Senior Data Architect at a media company with 1,001-5,000 employees
Real User
Sep 1, 2016
Download
Having the ability invoke analytic functions without having write self join SQL statements is beneficial.
Pros and Cons
  • "We are trying to data mine customer event data, and having the ability to invoke analytic functions without having to write self-join SQL statements is just brilliant."
  • "Ability to use analytic functions in where clauses, being able to use aliases in the where and order by clauses will make query writing/reading a lot easier."

Valuable Features:

Analytic functions.

Improvements to My Organization:

We are trying to data mine customer event data. Having the ability invoke analytic functions without having write self join SQL statements ... just brilliant.

Room for Improvement:

Ability to use analytic functions in where clauses, being able to use aliases in the where and order by clauses will make query writing/reading a lot easier.

Use of Solution:

2 years.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flag as inappropriate
PeerSpot user
PeerSpot user
it_user505137
Owner at a tech vendor
Vendor
Sep 1, 2016
Download
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.

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 technical 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.
Flag as inappropriate
PeerSpot user
PeerSpot user
it_user505218
Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees
Vendor
Sep 1, 2016
Download
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.
Flag as inappropriate
PeerSpot user
PeerSpot user
it_user505212
Data Scientist at a tech vendor with 201-500 employees
Vendor
Top 20
Sep 1, 2016
Download
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.
Flag as inappropriate
PeerSpot user
PeerSpot user
it_user505182
Data Scientist at a tech services company with 501-1,000 employees
Real User
Sep 1, 2016
Download
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.
    Flag as inappropriate
    PeerSpot user
    PeerSpot user
    it_user505101
    Senior Database Administrator at a financial services firm with 51-200 employees
    Vendor
    Sep 1, 2016
    Download
    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.
    Flag as inappropriate
    PeerSpot user
    PeerSpot user
    it_user504552
    Sr. Developer, Big Data at a comms service provider with 51-200 employees
    Vendor
    Aug 31, 2016
    Download
    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
      Flag as inappropriate
      PeerSpot user
      PeerSpot user
      it_user504570
      CIO at a tech vendor with 1,001-5,000 employees
      Vendor
      Top 20
      Aug 31, 2016
      Download
      Features valuable to me include: massive data ingestion performance and SQL standard query engine.
      Pros and Cons
      • "Massive data ingestion performance."
      • "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.
      Flag as inappropriate
      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: June 2026
      DOWNLOAD NOW
      Buyer's Guide
      Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros sharing their opinions.
      Buyer's Guide
      OpenText Analytics Database (Vertica)
      June 2026
      DOWNLOAD NOW
      Quick Links
      Learn More: Questions: