Tips and Techniques for Vertica Integration with Denodo

Denodo is a data federation tool that integrates data from various data sources including enterprise, big data, cloud, and real-time data services. It enables you to quickly and easily access data through reports, dashboards, mobile, and web applications for analytical and operational use cases. Denodo already has an integration with Vertica. It leverages Vertica’s query...

Let Business Intelligence and Data Science Coexist!

Business intelligence and data science frequently compete for resources, and BI got there first. Vertica in Eon Mode subclusters can help them coexist.
Quick Tip - blue button

Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync

An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...
Visual Storytelling with SQL

VSQL, Visual Storytelling through Query Language

This tip expands on my earlier post: “” Visual story telling has not just the ability to capture attention, it make things simple to understand. Consider the following to boost your query result set readability. What is the visual correlation between CPU utilization and Canary Queries elapsed time?

Channeling Greatness with Vertica

Micro Focus was recently featured on The Channel Company’s list of The Coolest System and Platform Companies of the 2020 Big Data 100. What makes Micro Focus so cool?

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

AWS Cloud and Vertica Future Looks Bright

Get Ready for AWS Linux 2

The Vertica team is excited to share that we have achieved the Amazon Linux 2 Ready designation as part of the (AWS) Service Ready Program. The AWS Service Ready Program is designed to help customers identify products that integrate with AWS services in order to quickly evaluate tools that run on AWS services. Vertica made...
Vertica plus RapidMiner

Announcing Vertica Integration With RapidMiner Studio Connection Guide

RapidMiner Studio is a visual integrated environment that enables data preparation, data mining, machine learning, building predictive models and business analysis. It’s an easy plug and play tool to design and execute analytical workflows. We are pleased to announce the release of a connection guide which will help users to quickly get Vertica and RapidMiner...
Who's awesome? BDC is awesome!

Top 10 Highlights from the Virtual Vertica BDC 2020

While it was a difficult decision to take the virtual, the registration numbers, session reviews, and overall feedback confirmed that this was our most successful BDC ever! If you did not have a chance to or missed any of the sessions, no worries. All sessions were recorded and PDFs of the presentations are available ....

Explore Popular Topics

Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s , on the first day of the – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever to get industry-changing analytics, including even more advanced...
Happy engineer with wide arms and graphs floating above him

Vertica Engineers Go Deep at Vertica BDC – Last Chance to Register!

I have had the privilege over the last few weeks to work with the Vertica engineering team as they developed, practiced and polished their presentations for the virtual Vertica Big Data Conference. Years back, I was an engineer, and spent the vast majority of my days alone in an office writing, compiling and testing code....
Helpful Tips message on post-it note

Export to CSV File With Fields Enclosed by Quotes

It's easy to export table data to a CSV file using vsql. Although there isn't a VSQL option to enclose each output field in quotes, you can accomplish that task with the Linux sed command. Once the formatting looks good, you can redirect the output to your CSV file: Helpful Links: Have fun!
goldfinch songbird in a field of thistle in Wales

COVID-19 Birdsong

For a number of years, when presenting one of my favourite Vertica demos, in which I talk about , I would typically start with a short, 30-second video clip to get the audience’s attention. The inspiration for this clip came about when I was staring aimlessly into the blue sky above my home in Pennard...