it_user158742 - PeerSpot reviewer
Director of Software Development at a tech company with 501-1,000 employees
Vendor
It is scalable and worth the expense if you need the production capability that it can support.

What is most valuable?

It has a very good design with high query performance. It provides the scale out capability by adding additional servers instead of scaling up the servers.

How has it helped my organization?

It has provided much better performance than SQL Server for big data analytics.

What needs improvement?

I would like to see integration with the latest Hadoop ecosystem.

For how long have I used the solution?

We have used this solution for three years.

Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 professionals have used our research since 2012.

What do I think about the stability of the solution?

It is usually very stable, but we occasionally see some nodes going down.

What do I think about the scalability of the solution?

There have not been any scalability issues. We are able to support trillions of data elements by adding more servers.

How are customer service and support?

The technical support is pretty good. I would give it a rating of 9/10.

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

We used to use MS SQL Server. It is good for data transactions, but it is not good for big data analytics.

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

It is pretty expensive, but it is worth it if you need the production capability that it can support.

Which other solutions did I evaluate?

We evaluated SQL Server and Teradata.

What other advice do I have?

It is worth a try if you are looking to provide a high-performance, big data analytics database.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Database Admin at a tech services company with 1,001-5,000 employees
Consultant
Replication is the main feature for my use.

Valuable Features

Replication

Improvements to My Organization

Replication and Node recovery in 8.0.

Room for Improvement

vbr.py needs to be improve to support diff no of nodes source to target.

Use of Solution

5 years

Deployment Issues

No

Stability Issues

Yes

Scalability Issues

No

Customer Service and Technical Support

Customer Service:

8

Technical Support:

8/10

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,924 professionals have used our research since 2012.
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

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: I am a real user, and this review is based on my own experience and opinions.
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: I am a real user, and this review is based on my own experience and opinions.
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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Ricardo Díaz - PeerSpot reviewer
COO at a tech services company with 11-50 employees
Consultant
A Good Option for Big Data

Valuable Features

Easy Installation, Easy to add and quit nodes...

Improvements to My Organization

SQLs querys 10 to 1 more fast that another commercial databases

Use of Solution

1 Year

Deployment Issues

Vertica support only SQL ANSI 99

Stability Issues

None

Scalability Issues

None

Customer Service and Technical Support

Customer Service: 10/10Technical Support: 5/10

Initial Setup

Easy

ROI

30%
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user110223 - PeerSpot reviewer
it_user110223Database Expert at a tech services company
Consultant

I think your description is very trivial ! And also Big Data is not all about the database tech sitting in the background.

MunkhsaikhanBayar - PeerSpot reviewer
Project Lead - Digital Transformation Unit at Bodi Electronics LLC
Real User
Scalable big data analytics platform that is reasonably priced compared to other solutions
Pros and Cons
  • "The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
  • "The integration of this solution with ODI could be improved."

What is our primary use case?

Our primary use case for this solution is data analytics.

What is most valuable?

The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.

What needs improvement?

The integration of this solution with ODI could be improved. 

For how long have I used the solution?

I have used this solution for 1 year.

What do I think about the stability of the solution?

This is a stable solution with a fast compression system.

What do I think about the scalability of the solution?

This is a scalable solution. 

How are customer service and support?

The technical support for this solution is really good. The support team are friendly and provide assistance quickly. 

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is straightforward. 

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

The pricing for this solution is very reasonable compared to other vendors.

What other advice do I have?

I would rate this solution a ten out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Manager at Bizinfo Thailand
Reseller
Scalable, reliable, and good support
Pros and Cons
  • "I have found the solution to be scalable."
  • "I have found that coding support could be simplified."

What is our primary use case?

We are using Vertica in our warehouse.

What needs improvement?

I have found that coding support could be simplified.

For how long have I used the solution?

I have been using this solution for approximately five years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

I have found the solution to be scalable.

How are customer service and technical support?

I have used the local support and I prefer them.

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

The price could be cheaper and it is best to negotiate the price.

What other advice do I have?

I rate Vertica an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
PeerSpot user
Buyer's Guide
Download our free Vertica Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Buyer's Guide
Download our free Vertica Report and get advice and tips from experienced pros sharing their opinions.