Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Principal Data Architect (BI) at a media company with 1,001-5,000 employees
Real User
I like the fast analytical functions and ability to extend functionality.

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

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

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 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.
PeerSpot user
PeerSpot user
Senior Data Architect at a media company with 1,001-5,000 employees
Real User
Having the ability invoke analytic functions without having write self join SQL statements is beneficial.

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.
PeerSpot user
Buyer's Guide
OpenText Analytics Database (Vertica)
May 2025
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
858,038 professionals have used our research since 2012.
PeerSpot user
Owner at a tech vendor
Vendor
We switched from our previous solution because SQL Server did not scale.

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.
PeerSpot user
PeerSpot user
Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees
Vendor
We could use it to offer Analytics As A Service to our customers.

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
PeerSpot user
Data Scientist at a tech vendor with 201-500 employees
Vendor
We were able to implement new algorithms without having to move data out of Vertica into a compute cluster.

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
We're 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
I like Recovery by table. I would like messages to Vertica startup commands improved.

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
The most valuable feature for me is the columnar data store.

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
Buyer's Guide
Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Buyer's Guide
Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros sharing their opinions.