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...
Vintage businessman concept pointing on the wall wearing futuristic helmet at office

Descending Sequences

James Knicely, Vertica Field Chief Technologist
April 17, 2019

The default increment for a Vertica sequence is 1. But you can also create a sequence that has a negative increment so that you can have a count down. Example: Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Sequences/Sequences.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Statements/CREATESEQUENCE.htm Have fun!
Helpful Tips message on post-it note

Display Session Sequence Cached Values Remaining

James Knicely, Vertica Field Chief Technologist
April 17, 2019

To optimize the performance of large INSERT SELECT and COPY operations, Vertica uses sequence caching. To allocate cache among the nodes in a cluster for a given sequence, Vertica uses the following process: By default, when a session begins, the cluster initiator node requests cache for itself and other nodes in the cluster. The initiator...
Calendar February 29 for Leap Year

Is This a Leap Year?

James Knicely, Vertica Field Chief Technologist
April 16, 2019

A Common Year in the Gregorian calendar has 365 days. A Leap Year, which has 366 days, occurs nearly every 4 years. One algorithm to determine if a year is a Common or a Leap Year is: I’d like to create a user-defined SQL function in Vertica that will let me know if the year...

Subscribe For Email Updates

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

Sign-up

Cupcakes with blue icing and lit birthday candles

How Old Am I (In Months)?

James Knicely, Vertica Field Chief Technologist
April 16, 2019

You are probably aware that Vertica has a built-in function named AGE_IN_YEARS. It returns the difference in years between two dates, expressed as an integer. Example: My son is turning 18 this year! I was curious to know how many months he’s been on the planet, so I figured that I could just multiply his...
Machine Learning programmer in glasses looks at graphs

Data Analytics and Machine Learning for Start-Ups on the Fast Track

Paige Roberts, Vertica Open Source Relations Manager
April 16, 2019

Tuesday, 4/30/19 Workbar Back Bay 6:00-8:00 PM Are you a data-driven start-up that makes decisions based on insight from high-performance analytics and machine learning? Would you like to choose the best analytical tool/ML for the job beyond limited open source offerings, but don’t have the budget? Do you want to hear best practices on how...

5 companies that are using data analytics to transform customer experience

Ben Smith, Senior Product Marketing Manager
April 15, 2019

Analyzing customer behavior is becoming a mandate for every business in every industry to understand, engage, and retain customers – with the ultimate goal of increasing lifetime value. By understanding how your customers behave and interact with your organization, you can better serve, and profit, from the interactions. Data is central to this equation in...

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

Display the Vertica Process Memory Allocated

James Knicely, Vertica Field Chief Technologist
April 10, 2019

For common Vertica cluster configurations, there should be a single running Vertica process on each node. You can use the Linux ps command to determine the process ID of the Vertica process. Once you have the process ID, you can display the amount of memory that has been allocated to the Vertica process using the...

Display Database Statement Counts by Type

James Knicely, Vertica Field Chief Technologist
April 9, 2019

There are many types of statements that can be executed in Vertica. Examples include queries, DDL (Data Definition Language), and utility statements. To summarize all the types of statements being executed, you can query the QUERY_PROFILES system table. Example: I’d like to view a count of each statement type across my cluster since the first...
Vertica Team at Data Innovation Summit booth

Data Innovation Summit 2019

Mark Whalley, Manager, Vertica Education
April 9, 2019

Having attended the Big Data Analytics – Europe event in Rotterdam on the 12th March, on 14th/15th, Captain Mark Whalley and fellow Captains from Vertica Airways paid a flying visit to the Data Innovation Summit in Stockholm. Whilst there, they crewed the Vertica booth answering questions from passengers and visitors and assuring them that their...
Hand writing the text: Helpful Tips

Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

James Knicely, Vertica Field Chief Technologist
April 8, 2019

Time series analytics evaluate the values of a given set of variables over time and group those values into a window (based on a time interval) for analysis and aggregation. This feature comes in handy if I need to generate a list of dates using some interval, for example 1 MONTH. Example: But why did...
Southern Data Science Conference, April 11, 12

Join Vertica at the Southern Data Science Conference in Atlanta

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
April 8, 2019

Next week – April 11-12 – Atlanta, GA will host the Southern Data Science Conference (SDSC). Held at the Crowne Plaza Atlanta Midtown, this event is geared to data scientists converging to hear from the industry’s best and brightest minds from top companies and research institutes. More than 400 attendees will attend two days of...

Truncating a Timestamp

James Knicely, Vertica Field Chief Technologist
April 5, 2019

The built-in Vertica function DATE_TRUNC truncates date and time values to the specified precision. The return value is the same data type as the input value. All fields that are less than the specified precision are set to 0, or to 1 for day and month. Example: So did the current Millennium begin on January...