Bulk loading data using copy
Fast analytical functions
Ability to extend functionality
Bulk loading data using copy
Fast analytical functions
Ability to extend functionality
Great reporting.
Faster deletes!
4 years
None
Sometimes users write bad queries that has brought down the cluster. Need a way to better manage resources.
None
Great
Technical Support:Great
No
In house implementation.
Analytic functions.
We are trying to data mine customer event data. Having the ability invoke analytic functions without having write self join SQL statements ... 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.
2 years.
Geospatial
Profiling, query optimize, management.
1 year
Some bugs, they were rapidly fixed.
Minute
Not yet
Excellent
Technical Support:Very good
SQL Server did not scale.
Manage big data fast and easy.
The time that the mediation process takes and historical information that I can store.
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".
Excellent!
Technical Support:Excellent!
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.
User Defined Extensions
Analytic Functions
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.
More Machine Learning algorithms--Random Forest for sure!
Very responsive
Technical Support:Excellent
In-house
Group by performance
Analytic functions
We could run group by queries thousand of times faster, we are able to test more models and improve accuracy.
Debug custom functions in r.
One year
None
None
None
Great! Email response is quickly and also within reported issues are resolved.
Technical Support:Ggreat, they really understand what they are talking about.
Straightforward, very easy.
In house
Recovery by table
Copy cluster
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.
Improve Vertica logging and messages to Vertica startup commands.
4 years
Columnar data store
Add geospatial indexes (sounds like they have done it in version 8.0)
No
No
No
Above average
Setup was very simple