Vertica Blog

Welcome to the New Vertica Blog!

Posted March 28, 2019 by Ben Smith, Senior Product Marketing Manager

Read More

Machine learning robot studying equations and graphs

Doing In-Database Machine Learning 1 – Why Would You Do That?

Co-authored with Paige Roberts. A lot of modern like Vertica allow you to do machine learning from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they have two questions. The first...

5 companies that are using data analytics to transform customer experience

Analyzing customer behavior is becoming a mandate for every business in every industry to understand, engage, and retain customers – with the ultimate goal of increasing lifetime value. By understanding how your customers behave and interact with your organization, you can better serve, and profit, from the interactions. Data is central to this equation in...

Simple ASCII Charting Using SQL

It is very easy to create a simple ASCII chart in Vertica using a SQL analytic function! Example: It’s a lot easier to visualize the differences in row counts when viewing them as a chart column! Helpful Links:
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 6. Advantages of In-Database Machine Learning

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. This is the final installment of the discussion. It was a lot of fun catching up and talking shop. In this final interview post, we talked about some of the advantages of doing...

Arithmetic Bit-Shifting

A fun way to manipulate bits in Vertica SQL is with the use of arithmetic bit-shifting, which moves the bits in a number either left or right and fills in the new values with 0s. Bit-shifting left is an easy way to multiply by powers of 2, while bit-shifting right divides by powers of 2....

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Three Takeaways from Barnes-Jewish Hospital Data Disruptors Webcast

Putting data to good use is an area of growing importance across the entire healthcare delivery value chain – from hospitals and health insurers to medical device manufacturers, EHR software vendors, genomic researchers, fitness tracker manufacturers, and more. In fact, according to the 2018 Predictive Analytics in Healthcare from the Society of Actuaries, 58% of...

Convert an Integer to a Binary

Although there is not a built-in function in Vertica to convert an integer to a binary, you can use the Vertica TO_HEX and HEX_TO_BINARY functions to create your own! Example: Helpful Links:
Explore Cloud-Optimized Analytics with Vertica in Eon Mode

Workshop: Explore Cloud-Optimized Analytics with Vertica in Eon Mode

Vertica will be offering a 2-day workshop this week, March 13 and 14, in Cambridge, MA, designed to bring Vertica users up-to-speed with Eon Mode.  Eon Mode is a recently released alternative to Vertica Enterprise Mode that provides highly elastic compute on the cloud. Register now, or you’ll miss your chance.

Explore Popular Topics

Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 5. Vertica, KNIME, Python and the New Uber Created Vertica-Python Interface

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In this post, we discuss how open source and Vertica interact, with focus on...

Switch the Sign of a Number

To switch the sign of a number you can multiply it by -1. Or you can use the Vertica built-in function NUMERIC_UM to do it for you!

Are These Two String Values Like Each Other?

The Vertica built-in function LIKE is used to determine if two strings are like one another, while the NLIKE function is used to determine if two strings are not like one another. You can even include wildcard symbols!

Identify a Table’s Primary Key Columns

The Vertica system table PRIMARY_KEYS lists the columns in a table's primary key. You can use the LISTAGG function to group the columns of a composite key into a single record! Helpful Link:
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 4. How You Can Help With Your Favorite Open Source Project Without Being an Expert

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In this post, Potts gives a few tips on how anyone who...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 3. Exciting News for Upcoming Python Release 3.8

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In the , we discussed the wide variety of programming languages and...