Vertica is versatile since it supports both on-premises and cloud infrastructure. Besides, it allows engineers to see how query would be on executed and to optimize it both manually and automatically. Review collected by and hosted on G2.com.

There are standard SQL functions which Vertica has not supported yet. For instance, pivot, except, unnest, array_agg functions is not provided, causing various issues when migrating from another system like BigQuery. Review collected by and hosted on G2.com.

Performance.

We can process millions of records and the aggregation operation is also super fast.

Also, the insert operation is not taking that much time. The usage of CTEs which actually her stands in analogous to temp table operation is also very useful. Review collected by and hosted on G2.com.

A native development environment and absence of parameters and absence of stored procedures. It would be better if you could provide all these and along with some profiler service.

Plus the performance is very poor if we use UNION ALL operation that too with the same data set. Review collected by and hosted on G2.com.

All the syntax and function naming speaks for themself on top of that good documentation always comes to the rescue they also have very active and huge community for helping in case. Review collected by and hosted on G2.com.

no multi-line insert statement is kinda stopping us sometimes need some tweaking around to find the exact solution which will work perfectly It is inherent problem when you comes to columunar DB. Review collected by and hosted on G2.com.

Everything about vertica

It's a very good loved it very much Review collected by and hosted on G2.com.

Nothing is there to dislike

I mean it's good Review collected by and hosted on G2.com.

Quickly ingest a large amount of data from various sources and low cost compared to other analytical databases. Review collected by and hosted on G2.com.

Documentation is poor and has few resources to seek for help other than their official doc site. Review collected by and hosted on G2.com.

There is no need to create data structures again. It enables to integrate millions of rows to be delivered in real time basis.It also provides advanced analytics features that are not there in Teradata or other platforms. Review collected by and hosted on G2.com.

I think vertica should be flexible with cloud providers like Azure, AWS and Google Cloud Platform like Snowflake does. The storage cost and query execution should be more secure using service accounts. Review collected by and hosted on G2.com.

More than a typical data warehousing solution, Vertica offers solutions for most complex analytical workloads and predictive analytics capabilities and works with most cloud service providers, including AWS, GCP and Azure. Review collected by and hosted on G2.com.

Product documentation and learning platform for developers and consultants can be improved so that people who want to learn Vertica can find it easy. Certification offerings to validate consultant knowledge would also help. Review collected by and hosted on G2.com.

The massive parallel processing power of vertica to handle big data is very amazing when compared to other database. It supports on premise Hadoop and other multi cloud. Review collected by and hosted on G2.com.

The integration of Vertica with industry leading BI platform is not straight forward. It will be good if there is a common standard connection component to achieve the same. Review collected by and hosted on G2.com.

One thing that stood out is the ease of use and having my data accessible and being able to integrate various tools like Tableau Server to help visualize and analyze the data with ease. Review collected by and hosted on G2.com.

I was bothered by the fact that I'm not able to migrate the data from one cluster to another as whole schemas instead of exporting the data into an S3 bucket using select statements and then importing that data into the destination cluster which caused multiple issues with some timestamp values in some tables, But I managed to work around this issue by changing the Data partitioning mode to node partitioning. Review collected by and hosted on G2.com.

User interface and the last one is the best in the call I can't find it on my phone so I don't know the number of sleepless nights I had beacuse of harsh mails sent to me by the intial and Review collected by and hosted on G2.com.

Services to use for the support and understanding during my work with the insights you might have already know about this project in under targeted delivery timelines Review collected by and hosted on G2.com.