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...
Database Server Room

Find Out When Vertica Was Last Updated

James Knicely, Vertica Field Chief Technologist
March 25, 2019

You can check the data collector table DC_UPGRADES to see when you upgraded Vertica by version! Example: Helpful Link: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/Glossary/DataCollector.htm Have fun!
Chicago cityscape with various data type icons and network connection concept

Vertica Receives High Rankings in All Four Data Warehouse Use Cases in Gartner Critical Capabilities for Data Management Solutions for Analytics Report

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

This week, Gartner published its Critical Capabilities for Data Management Solutions for Analytics (DMSA) report. This research scores 19 vendors in the Data Management Solutions market based on four primary data warehouse use cases: Traditional Data Warehouse, Real-Time Data Warehouse, Logical Data Warehouse, and Context-Independent Data Warehouse. Vertica increased its rankings from 2018 in all...
lady on cell phone with laptop computer

Maxcom Telecomunicaciones Gets More Than They Bargained For With Vertica

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

Maxcom Telecomunicaciones is a Mexican integrated telecommunications operator providing managed voice and data services. The Mexican federal regulations changed recently, requiring Maxcom to retain call detail record (CDR) data for two years, rather than two months. It also required them to answer queries on that data far faster, sometimes within an hour, any time of...

Subscribe For Email Updates

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

Sign-up

Brace Yourself: 5G is Coming

Ben Smith, Senior Product Marketing Manager
March 21, 2019

Find out how machine learning and predictive analytics can be a growth engine for telcos and mobile operators in the age of 5G

Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

James Knicely, Vertica Field Chief Technologist
March 20, 2019

When your query contains the ORDER BY clause to sort the result set, alphanumeric NULL data will sort to the bottom if the sort is in ascending order (ASC) and to the top if the sort is in descending order (DESC), while integer NULL data does the opposite. Example: I want the NULL values in...

In Loving Memory of Phil Molea

Soniya Shah, Information Developer
March 20, 2019

  Phil worked for Vertica as an Information Developer for close to five years.  He was a very important part of our Vertica team and part of our Vertica family. Phil enjoyed working in the Vertica community, the base product documentation, as well as with our Technology Partners.  He was very well liked and respected...

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

Do you have experience using Vertica?

Soniya Shah, Information Developer
March 20, 2019

The Vertica Product Management team is collecting feedback on what new features and functionality our customers would like to see added to the product. We’ve been actively gathering product-related feedback for nearly a year and have been using it to make more informed decisions about how we manage the Vertica product roadmap. Thank you for...

Using sed to Handle Empty String NULL Values Enclosed in Control Characters

James Knicely, Vertica Field Chief Technologist
March 19, 2019

You can load data files into a Vertica table using the COPY command. Your data can be delimited and separated by control characters. Unfortunately if you also enclose NULL values as an empty string, you might run into a data cast issue. Example: One work around is to clean up the source file using the...

Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

James Knicely, Vertica Field Chief Technologist
March 18, 2019

You can load data files into a Vertica table using the COPY command. Your data can be delimited and separated by control characters. Unfortunately if you also enclose NULL values as an empty string, you might run into a data cast issue. Example: One work around is to use a COPY FILLER. Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/BulkLoadCOPY/BulkLoadingData.htm...
Three 3D arrows, different colors pointing in different directions

Monitor/Clean Up the CopyErrorLogs Directory

James Knicely, Vertica Field Chief Technologist
March 15, 2019

The COPY statement automatically saves a copy of each rejected row in a rejected-data file. COPY also saves a corresponding explanation of what caused the rejection in an exceptions file. By default, Vertica saves both files in a database catalog subdirectory called CopyErrorLogs. After you’ve reviewed and resolved any issues with the load, it’s a...

Tracking the Current Transaction Start Date and Time

James Knicely, Vertica Field Chief Technologist
March 14, 2019

The built-in Vertica function TRANSACTION_TIMESTAMP returns a value of type TIME WITH TIMEZONE, which represents the start of the current transaction. It’s very useful for keeping track of when the transaction started for a group of table inserts. Example: dbadmin=> INSERT INTO test SELECT 1, SYSDATE, TRANSACTION_TIMESTAMP(); OUTPUT -------- 1 (1 row) dbadmin=> INSERT INTO...
Modern Database Analytics

Simple ASCII Charting Using SQL

James Knicely, Vertica Field Chief Technologist
March 13, 2019

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: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/String/REPEAT.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/Analytic/MAXAnalytic.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/Aggregate/COUNTAggregate.htm