Vertica Blog

Vertica Blog

DBadmin

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

Quick Tip: Replacing non-UTF-8 Characters

James Knicely, Vertica Field Chief Technologist
July 16, 2021

Vertica database servers expect to receive all data in UTF-8 and Vertica outputs all data in UTF-8. However, you can load or insert data into Vertica that is non UTF-8, but you'll want to clean it up. I used to recommend the REGEXP_REPLACE function for that task, but now there is a better way! Vertica...

List the Missing Dates in a Date Series

James Knicely, Vertica Field Chief Technologist
October 22, 2020

The TIMESERIES clause in Vertica makes it easy to list all of the gap days (that is, those that are missing) from a series of dates. Say I have this simple date series: As you can see, there are several dates missing from the series (2020-10-30, 2020-11-02, 2020-11-03 and 2020-11-04). I can list these absent...
Compass rose with true north pointing to "Helpful Tips" text

Getting Every Nth Row from a Table (Enhanced)

James Knicely, Vertica Field Chief Technologist
October 20, 2020

In a previous Vertica Quick Tip we learned how to query every Nth row from a table when we had a unique ID column having sequential values (that is, from a sequence). See, https://www.vertica.com/blog/vertica-quick-tip-getting-every-n-th-row-table/ What if we don’t have a key like that in our table? No problem thanks to the ROW_NUMBER() Analytic Function! Say...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

Paige Roberts, Vertica Open Source Relations Manager
March 31, 2020

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...
WOS ROS differences

Write Optimized Store (WOS) Deprecation – What You Need to Know

Sumeet Keswani, Vertica Product Technology Engineer
March 23, 2020

In Vertica 10.0, WOS (Write Optimized Store) will be deprecated. In this blog, we introduce the historical justification for WOS and its purpose, why we believe that it's no longer needed, and our justification for deprecating it. We'll go over the data and the testing we performed that gives us the confidence to ensure that...
Focused young woman working at laptop in office

New hands-on training at Vertica Academy takes users deep into Vertica Essentials

Mike Perrow, Senior Product Marketing Writer/Editor
March 12, 2020

Since Vertica Academy was launched in September 2019, this versatile online training portal has acquired more than 1,500 registered users (as of beginning of March), and that number is growing daily. Users are finding answers to tough questions that arise as they explore the complex world of big data analytics. They’re finding self-paced courses, webinars...
Helpful Tips text with hand and marker over data center background

Define a Vertica Flattened Table Column as Having Both DEFAULT and SET USING Constraints

James Knicely, Vertica Field Chief Technologist
January 31, 2020

Columns in a flattened table can query other tables with constraints DEFAULT and SET USING . Vertica executes DEFAULT queries only on new rows when they are added to the flattened table, through load operations such as INSERT and COPY. Thereafter, changes in the original data sources have no effect on the flattened table. Vertica...
Compass rose with true north pointing to "Helpful Tips" text

Which Database Mode Is My Database Using?

James Knicely, Vertica Field Chief Technologist
January 14, 2020

You can run Vertica in either Eon Mode or Enterprise Mode. The primary difference between Eon and Enterprise Modes is where they store data. Eon Mode stores data in a shared object store called communal storage, while Enterprise Mode stores data across the filesystems of the database nodes. If you are working with a new...
Tips and Tricks Orange Button

Moving a Table to a New Schema and Inheriting the New Schema Privileges

James Knicely, Vertica Field Chief Technologist
December 6, 2019

You can move a table from one schema to another schema with a simple ALTER TABLE command. But, you might be surprised that the table will not inherit the new schema’s privileges even if the new schema was created using the DEFAULT INCLUDE PRIVILEGES directive. After moving the table you will need to manually alter...

Announcing Vertica 9.3 Instructor-Led Training Courses

Drea Brandford, Technical Consultant
November 21, 2019

Just in time for the release of version 9.3, Vertica is pleased to announce the release of two updated instructor-led training courses: Vertica 9.3 Essentials and Vertica 9.3 Descriptive Analytics. A description of each course follows: Vertica 9.3 Essentials This 4-day course explores the capabilities of the Vertica platform solution in Enterprise mode, and prepares...
Vertica and Amazon logos

Vertica and Amazon – Better Together, for Years

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
October 23, 2019

The year was 2012. Marvel’s The Avengers hit the box office. Facebook went public. NASA's Curiosity rover landed on the surface of Mars. And, the Vertica AMI (Amazon Machine Image) made its debut on AWS Marketplace, enabling data-driven organizations to easily deploy Vertica on the Amazon cloud and start accelerating their analytics. Running Vertica on...