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...
winding road into the distance with clocks on tall stands along the way

It’s Time for Time Series

Joy King, VP Product & GTM Strategy, Vertica
February 19, 2019

Recently, as I always do, I was reading about some emerging trends in our industry and a headline popped out at me -- did you know that time series databases are one of the fastest growing specialty database platforms? That was a surprise to me, so I did a little more research. Time After Time,...

Tracking Table Row Counts Over Time: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 15, 2019

I would like to track the row counts from all of my database tables over time. Doing so will help me predict future growth. How do I do that? Like this… Are the row counts accurate? Yup! Now I can add my table row count job to CRONTAB so that it runs once a day...

Auditing Database DDL Operations: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 14, 2019

Starting with Vertica 9.2, you can now track all DDL operations (i.e. CREATE, ALTER, TRUNCATE, etc.) that are being executed in your database! The LOG_QUERIES system table provides summary information about those operations. Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/Security/DatabaseAuditing.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/LOG_QUERIES.htm Have fun!

Subscribe For Email Updates

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

Sign-up

Reset the ROUNDROBIN Load Balancing Counter: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 12, 2019

The ROUNDROBIN load balancing scheme chooses the next host from a circular list of hosts in the cluster that are up. You can use the RESET_LOAD_BALANCE_POLICY function to reset the counter each host in the cluster maintains to track which host it will refer a client to when the native connection load balancing scheme is...

Random Host Load Balancing: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 11, 2019

Native connection load balancing is a feature built into the Vertica server and client libraries that helps spread the CPU and memory overhead caused by client connections across the hosts in the database. It can prevent unequal distribution of client connections among hosts in the cluster. Typically folks implement the ROUNDROBIN load balancing scheme which...
padlock with key on pile of chains

Data Day Texas: Keep Your Architecture Open and Avoid Mindset Lock-in

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

Data Day Texas is an event in Austin that was started about nine years ago by an old acquaintance of mine, Lynn Bender, who founded Global DataGeeks. The one big theme that struck me this year as running through the whole conference was the highly cooperative landscape that has developed between proprietary and open source...

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
Three 3D arrows, different colors pointing in different directions

Another Way to De-Duplicate Table Rows: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 8, 2019

To remove duplicate table rows it is typically better (i.e. faster) to create a temporary table that contains all of the distinct rows from a table, drop the original table, then rename the temp table to the original table’s name. The issue with that solution is that you’ll need to be sure that the original...

Combining Functions to Extract Discrete Data From a String: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 7, 2019

Vertica has 1000s of built-in functions including String Functions, which perform conversion, extraction, or manipulation operations on strings or return information about strings. Regular Expression Functions let you perform pattern matching on strings of characters. There is real power in combing Vertica functions to accomplish almost any task in SQL. I want to extract the...
Modern Database Analytics

What’s the Distance Between Two Zip Codes? Quick Tip

James Knicely, Vertica Field Chief Technologist
February 6, 2019

Vertica has a built-in function called DISTANCEV which returns the distance (in kilometers) between two points using the Vincenty formula. Because the Vincenty formula includes the parameters of the WGS-84 ellipsoid model, you need not specify a radius of curvature. You specify the latitude and longitude of both the starting point and the ending point....
Programmer

Calculate a Year’s Chinese Zodiac Animal: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 5, 2019

The Chinese Zodiac (Sheng Xiao) is based on a twelve-year cycle where each year is represented by an animal sign. The twelve animal signs in order are the rat, ox, tiger, rabbit, dragon, snake, horse, sheep, monkey, rooster, dog and pig. The animal sign is calculated according to the Chinese lunar calendar. I can never...

Elastic Throughput Scaling: Overview

Phil Molea, Sr. Information Developer, Vertica
February 5, 2019

Manvendra Panwar authored this post. Elastic Throughput Scaling (ETS) enables Vertica to increase concurrency through which we can achieve higher throughput. ETS can take advantage of redundant shard subscriptions to automatically identify the nodes in the cluster that can execute a query. More Nodes (N) than Shards (S): Achieving higher throughput • S nodes can...

Finding All Columns Storing Some Value: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 4, 2019

A long time ago a database developer asked me how she could produce a list of all table columns in the database which store a given value. Note that she was in the process of normalizing tables and wanted to find every fact table that referenced a particular string value to replace it with a...