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...
Child sleeping peacefully under a blue blanket labelled Vertica

Take Vertica and Call Me in the Morning

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

Last night, at 1:37 am, I found myself awake and thinking about Vertica. To anyone who knows me, this should come as no surprise. I was thinking about how different Vertica is from so many other players in the market and I realized that we have for years proudly described Vertica as a full ANSI...

Viewing External Table Definitions: Quick Tip

James Knicely, Vertica Field Chief Technologist
February 1, 2019

An alternative to importing data into Vertica is to query it in place. For that we use external tables. Once an external table is created you can view its definition via the TABLES system table. Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Tables/ExternalTables/CreatingExternalTables.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Tables/ExternalTables/Intro.htm Have fun!
Database Server Room

Generate a Random Integer Within a Range: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 31, 2019

The RANDOMINT functions returns one of n integers from 0 through n – 1. If you need to generate a random integer that falls within a range of integers between X and Y, inclusive, use this simple formula: Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/Mathematical/RANDOM.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/Mathematical/RANDOMINT.htm Have fun!

Subscribe For Email Updates

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

Sign-up

teammates looking at analytical data

Vertica Dialect for Hibernate Updated!

Kathy Taylor, Information Technology Developer, Vertica
January 31, 2019

The Vertica dialect for Hibernate, updated for Vertica 9.2 and Hibernate 5.4.1, is now available for download. The dialect enables Hibernate to map Java classes to database tables in Vertica. Hibernate is an open-source, Object/Relational Mapping (ORM) framework for Java environments. With Hibernate, developers can create an object library that encapsulates object/relational mapping information for...

Seeding a Random Integer: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 30, 2019

The RANDOM function returns a uniformly-distributed random number x, where 0

Seeding a Random Number: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 29, 2019

The RANDOM function returns a uniformly-distributed random number x, where 0

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

Limiting the Amount of Memory Available to a Query: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 28, 2019

Every Vertica DBA has seen a user execute some crazy, memory intensive query that starves every other user request forcing them to queue. To avoid that situation, you can use the MAXQUERYMEMORYSIZE resource pool parameter, which sets the maximum amount of memory that the pool can allocate at runtime to process a query. User JIM...
silhouettes of 2 t-rex dinosaurs battling under a starry sky

Don’t Get Stuck With a Technology Dinosaur

Paige Roberts, Vertica Open Source Relations Manager
January 28, 2019

Unless you have been hiding out in Jurassic Park, you’ve probably heard that most of the IBM PureData System models, aka Netezza, are going the way of the dinosaur this summer. With the announcement of the end of support for one of the first data warehouse appliances, it’s time to look at where to go...

Display a Rounded Number With a Specific Scale: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 25, 2019

The Vertica ROUND function rounds a value to a specified number of decimal places, retaining the original precision and scale. Fractions greater than or equal to .5 are rounded up. Fractions less than .5 are rounded down (truncated). If you’d prefer not to retain the original scale and have the scale of the result be...
Three 3D arrows, different colors pointing in different directions

View Vertica Features Recently Used: Quick Tip

James Knicely, Vertica Field Chief Technologist
January 24, 2019

Curious if Vertica features are being used in your database? If so, the data collector table DC_FEATURES_USED stores recently used Vertica features (i.e. commands, meta-functions and UDXs). Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/DATA_COLLECTOR.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/EnablingAndDisablingDataCollector.htm Have fun!

Try Vertica in a Virtual Machine

Kathy Taylor, Information Technology Developer, Vertica
January 24, 2019

Curious about Vertica? Check out the Vertica Community Edition VM! It’s a free, quick, and an easy hands-on introduction. In the VM, you’ll find everything up and running. You won’t have any setup to do. You’ll find a single-node installation of Vertica Community Edition with the VMart example database, the Vertica client tools, and a...
Modern Database Analytics

Monitoring COPY Statement Events (Part 2): Quick Tip

James Knicely, Vertica Field Chief Technologist
January 23, 2019

A COPY command is typically composed of two phases. The second phase, if using the DIRECT parameter, includes sorting the data and writing the data in Disk. You can monitor the progress of this phase of the COPY command via the data collector table DC_MERGE_EVENTS. Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/DATA_COLLECTOR.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/EnablingAndDisablingDataCollector.htm Have fun!