Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
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

Paige Roberts, Vertica Open Source Relations Manager
March 13, 2019

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

James Knicely, Vertica Field Chief Technologist
March 12, 2019

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

Three Takeaways from Barnes-Jewish Hospital Data Disruptors Webcast

Ben Smith, Senior Product Marketing Manager
March 12, 2019

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 report from the Society of Actuaries, 58%...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Convert an Integer to a Binary

James Knicely, Vertica Field Chief Technologist
March 11, 2019

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: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/String/HEX_TO_BINARY.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/DataTypes/BinaryDataTypes.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/DataTypes/Numeric/INTEGER.htm
Explore Cloud-Optimized Analytics with Vertica in Eon Mode

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

Paige Roberts, Vertica Open Source Relations Manager
March 11, 2019

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

Paige Roberts, Vertica Open Source Relations Manager
March 11, 2019

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

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series

Switch the Sign of a Number

James Knicely, Vertica Field Chief Technologist
March 8, 2019

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?

James Knicely, Vertica Field Chief Technologist
March 7, 2019

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

James Knicely, Vertica Field Chief Technologist
March 7, 2019

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: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/PRIMARY_KEYS.htm
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

Paige Roberts, Vertica Open Source Relations Manager
March 7, 2019

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

Paige Roberts, Vertica Open Source Relations Manager
March 6, 2019

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 first post, we discussed the wide variety of programming languages...
Woman's hand with ring and henna tattoos in man's hand in embroidered sleeve

A Perfect Match – Matrimony.com and Vertica

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
March 5, 2019

If you have ever sought a romantic match in India, chances are you have visited Matrimony.com. According to the Times of India, 92% of singles in India seek love on matrimony sites. Matrimony.com’s flagship brand, BharatMatrimony, alone has more than 4,000 associates serving more than three million active members. But, how does Matrimony.com connect singles...