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

Monitoring COPY Statement Events (Part 1): Quick Tip

James Knicely, Vertica Field Chief Technologist
January 23, 2019

A COPY command is typically composed of two phases. The first phase includes reading the data from the source, parsing the data, segmenting the data and sending it to the nodes after it is segmented. You can monitor the load events of this phase of the COPY command via the data collector table DC_LOAD_EVENTS. Helpful...

Nested Boolean Operators: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 18, 2019

Vertica supports the following Boolean operators: • AND • OR • NOT To nest Boolean operators, use parenthesis! Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Operators/BooleanOperators.htm Have fun!

Using VSQL as a Calculator: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 18, 2019

A calculator is something used for making mathematical calculations, in particular a small electronic device with a keyboard and a visual display. VSQL mostly fits that description! And for fun, you can also astound your friends using this old calculator trick! 1. Have a buddy pick a number between 1 and 9. 2. Now have...

Subscribe For Email Updates

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

Sign-up

Extracting Characters from the Left and Right Side of a LONG VARCHAR: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 16, 2019

The LEFT SQL function returns the specified characters from the left side of a string, while the RIGHT SQL function returns the specified characters from the right side of a string. Unfortunately, the LEFT and RIGHT SQL functions won’t work on table columns having the LONG VARCHAR data type where the data size can be...

Determining the Current K-Safety: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 15, 2019

K-safety sets the fault tolerance in your Vertica database cluster. The value K represents the number of times the data in the database cluster is replicated. These replicas allow other nodes to take over query processing for any failed nodes. You can view the current K-Safety of a Vertica database in several ways. Helpful Links:...
Database Server Room

Specifying CASCADE When Dropping a Table: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 14, 2019

The DROP TABLE command removes a table and its projections. A projection with a create type of “DELAYED CREATION” is an auto-projection. Auto-projections are superprojections that Vertica automatically generates for tables. If you create a projection manually or via the Database Designer (non-auto projections), you will need to drop the table specifying the CASCADE option....

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

Ordering the List of Values Returned from LISTAGG

James Knicely, Vertica Field Chief Technologist
January 11, 2019

The LISTAGG function transforms non-null values from a group of rows into a list of values that are delimited by a configurable separator. LISTAGG can be used to de-normalize rows into a string of comma-separated values or other human-readable formats. What if I want to order the list of values that LISTAGG returns? Unfortunately, there...

Ignore NULL Values in Non-Correlated Subqueries: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 10, 2019

A subquery is a SELECT statement embedded within another SELECT statement. The embedded subquery is often referenced as the query's inner statement, while the containing query is typically referenced as the query's statement, or outer query block. A subquery returns data that the outer query uses as a condition to determine what data to retrieve....

Drop More than One Table at a Time: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 9, 2019

The DROP TABLE command removes a table and its projections. You can drop more than one table at a time by specifying a comma delimited set of tables! That was easy. How about dropping more than one table? At first you might be tempted to run a DROP TABLES command to drop multiple tables, but...

Allowing Users to Query a View Owned by Another User: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 8, 2019

As we learned in yesterday’s Vertica Quick Tip A View Owner Needs Access to the Underlying Objects, the owner of a View must have direct access to the underlying objects referenced by the view! But what if another user wants to read a view owned by another user? In this case, not only must the...

A View Owner Needs Access to the Underlying Objects: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 7, 2019

You can use the ALTER VIEW … OWNER TO command to change a Vertica database view’s ownership. It’s important to know that a View’s owner must also have access to the underlying objects referenced by the view! Exanple: Great! The user, USER1, can read from the view as expected. But what happens when I change...

Preserving Objects Owned by a Dropped User: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 4, 2019

When you drop a user with the CASCADE option, all objects owned by that user are lost forever! If you’d prefer to save those objects, you first set the GlobalHeirUserName security parameter to a user who will inherit objects after their owners are dropped. This setting ensures preservation of data otherwise lost. Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/SecurityParameters.htm...