Vertica Blog

Vertica Blog

Vertica

TOP 5 - with stars on white background - 3D

Top 5 Reasons Why You Win Big with Data at the Vertica Big Data Conference 2020

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
December 9, 2019

A few years ago, we held a user conference for our growing Vertica community. However, we underestimated its success – selling out the inaugural event because we had booked a venue that couldn’t accommodate the interest of hundreds of customers, prospects, and partners for what turned out to be Boston’s biggest and best Big Data...

Announcing Vertica 9.3 Instructor-Led Training Courses

Drea Brandford, Technical Consultant
November 21, 2019

Just in time for the release of version 9.3, Vertica is pleased to announce the release of two updated instructor-led training courses: Vertica 9.3 Essentials and Vertica 9.3 Descriptive Analytics. A description of each course follows: Vertica 9.3 Essentials This 4-day course explores the capabilities of the Vertica platform solution in Enterprise mode, and prepares...

Announcing Vertica Eon 9.x Essentials Course

Herb Collins, Technical Consultant
November 13, 2019

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?

Joy King, VP, Vertica Product Management & Product Marketing
October 25, 2019

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

Paige Roberts, Vertica Open Source Relations Manager
October 16, 2019

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?

Joy King, VP, Vertica Product Management & Product Marketing
October 3, 2019

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

Deb Chatigny, Manager, Information Development
September 9, 2019

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

Yashika Issrani, Summer 2019 Information Development Intern
August 21, 2019

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

Julia Avila
August 20, 2019

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

Jim Knicely, Vertica Principal Solution Architect
August 19, 2019

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

Jim Knicely, Vertica Principal Solution Architect
August 19, 2019

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

Jim Knicely, Vertica Principal Solution Architect
July 17, 2019

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...