The Vertica Academy Is Open for Learning

Posted September 9, 2019 by Joy King, VP, Vertica Product Management & Product Marketing

Introducing an Industry First – Vertica in Eon Mode for Pure Storage

Jeremiah Morrow, Senior Product Marketing Manager – Partner Ecosystem
September 17, 2019

This week at the Pure Accelerate conference, Vertica and Pure Storage of Vertica in Eon Mode for Pure Storage, the industry’s first and only analytical database solution with a separation of compute and storage architecture for on-premises analytic workloads. Why is this important to you? The rush to migrate analytic workloads to the cloud was,...

Vertica Big Data Conference Registration is Open!

Ben Smith, Senior Product Marketing Manager
September 16, 2019

We’re excited to announce that for the next Vertica Big Data Conference (BDC), held March 30 – April 2, 2020, at the Encore Boston Harbor Hotel. Don’t miss out on the early bird pricing rate of $695 (a $300 savings), along with buy 3 get 1 free group discounts! What is the Big Data...

7 Critical Capabilities for Embedded Analytics

Ben Smith, Senior Product Marketing Manager
September 12, 2019

Software and technology vendors serving a range of industries – from security to healthcare – are increasingly turning to embedded analytics as a way to deliver value-added services and applications to their customers. Enterprises that embrace embedded analytics are changing the dynamics of business in every vertical market. The most disruptive companies in these industries...

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

Photo of actual roadrunner running on a road showing yellow stripe in the middle

Have VSQL Beep Upon Command Completion

Jim Knicely, Vertica Principal Solution Architect
September 6, 2019

There are a lot of cool command line options available to VSQL. One of my favorites is the –b option which causes Vertica to “beep” when a command completes. This is very useful if you are running a very long sequence of SQL commands via a script. You can go off and do other things...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Easy Development Schema Cleanup (i.e., Have Vertica Drop a Bunch of Tables for You)

Jim Knicely, Vertica Principal Solution Architect
September 5, 2019

On a development database, I have a lot of tables in the PUBLIC schema having similar names starting with “test_”. I’d like to drop all of these tables quickly. To do that, I can have Vertica generate the DROP commands and then execute them for me! P.S. Be careful with this command! Make sure when...

Helpful Tips in blue text with magnifying glass

Investigate Data Collector Table Data Produced by Scrutinize

Jim Knicely, Vertica Principal Solution Architect
September 5, 2019

The diagnostics tool scrutinize collects a broad range of information from a Vertica cluster. Part of the output from scrutinize includes data collector table data. Once extracted, we can easily load the data from a data collector table file into a Vertica Flex Table for analysis! Let’s take a look at the data from the...

Machine learning robot studying equations and graphs

In-Database Machine Learning 2: Calculate a Correlation Matrix – A Data Exploration Post

Arash Jalel Zadeh Fard, Senior Software Engineer at Vertica
September 5, 2019

In the , we discussed some of the reasons why it makes sense to do your machine learning inside the database. This will be the first post where we discuss some of the steps involved in the in-database machine learning workflow. Generally, the first thing you need to do is explore your data. This can...

Explore Popular Topics

DBadmin
SQL
VSQL
Best Practices
machine learning
Advanced Analytics
Cloud
Eon Mode
AWS
Security
Checklists
Vertica
Time series
Projections
Vertica 9

Construction site crane building a blue SQL 3D text.

Load Data Enclosed By and Embedded With Double Quotes

Jim Knicely, Vertica Principal Solution Architect
September 4, 2019

Loading string data that is enclosed in double quotes where the string also contains double quotes can be problematic. We could alter the data so that it includes an escape character prior to each embedded double quote, but maybe that’s not possible. Another solution would be to use a FILLER to load the data then...

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!