Vertica Blog

Vertica Blog

Vertica

Announcing Vertica Eon 9.x Essentials Course

We have just released a new instructor-led course: Vertica Eon 9.x Essentials Course code: VT120EON This course provides live instructions on Vertica Eon v9.3, accompanied by comprehensive hands-on labs. Running on a public cloud platform, Vertica Eon Essentials allows users to directly connect with the Vertica Eon database and the Management Console to interact with...
Happy dog running in grass

Vertica Big Data Conference 2020 – Are You Excited Yet?

The Vertica Big Data Conference (BDC) clock is ticking and my excitement is growing by the minute! I want to make sure that our Vertica community is up to date on the latest news, especially some of the General Session speakers and Breakout tracks. And let’s not forget one of the most special components of...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

The have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon Mode Improvements Eon...
Bullet train rendering with Vertica on side, and zooming effect with "Depot" sign behind

Vertica in Eon Mode Depot – Where Did You Go?

Separating compute from storage is such a hot topic these days. “Instance types” and “S3 Object Storage” are core to the language of the public clouds (unless you’re Azure, then substitute S3 with Blob but leave the Object Storage part). This next-generation architecture enables so many operational and economic advantages – workload isolation, elastic scaling,...
Interns hiking at Blue Hills Reservation, Milton, Mass.

Intern Spotlight: Becoming an Engineer

My name is Richard Xu and I am a sophomore at Harvard University, studying Computer Science. This summer, Vertica has taught me how to be an engineer. Starting a career as a freshman is challenging. I may have the technical know-how and coding abilities, but the freshman stigma loomed over me. At the career fair...

Intern Experience: Documentation at Vertica

My name is . I am currently a rising senior at the University of Massachusetts Amherst, pursuing a dual degree in English and Psychology, as well as an IT minor. I also hold a certificate in Professional Writing and Technical Communication. I am grateful to have been a part of that program, as I came...

Intern Spotlight: UX Design and the Vertica Forum Relaunch

My name is and I am a rising senior at the University of Massachusetts Amherst, studying English with concentrations in and Digital Humanities. I have a deep interest in User Experience Design (UXD) and I am passionate about creating innovative web content. This past summer, I joined the Information Development team to redesign the using...
Cow peering around edge of frame with blue sky and clouds in shape of a comic book thought bubble.

Make a Cow Display Query Results in VSQL

I used to have fun with the amusing old Linux command Cowsay. It inserts any input into a word bubble and draws an ASCII cow to talk to you. You can make the cow display your query results in VSQL! Helpful Links: Have fun!
Business card that says Expert Tips,

Stop a Stubborn Query that Won’t Cancel

Sometimes a running SQL statement hangs and cannot be stopped using the CLOSE_SESSION or INTERRUPT_STATEMENT function. To stop it, first grab the culprit’s SESSION_ID, TRANSACTION_ID, and STATEMENT_ID from the QUERY_REQUESTS system table, then you can move it to a resource pool that has no resources! After the move and subsequent re-plan, the query will “usually”...
Helpful Tips in blue text with magnifying glass

Loading Data Stored in Scientific Notation to an Integer Column

Scientific notation is a way of expressing numbers that are too big or too small to be conveniently written in decimal form. Vertica can display numbers in scientific notation in decimal form with ease. That is, unless the value is a string! You first have to convert the VARCHAR to a NUMERIC and then to...
Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

This week, some very cool things have gone into the newest version of the that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do exactly that. But,...

Display the Vertica Process Memory Allocated

For common Vertica cluster configurations, there should be a single running Vertica process on each node. You can use the Linux ps command to determine the process ID of the Vertica process. Once you have the process ID, you can display the amount of memory that has been allocated to the Vertica process using the...