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

Changing the Default Database Time Zone

Sarah Lemaire, Manager, Vertica Documentation
July 18, 2018

Jim Knicely authored this tip. When you first install Vertica, the default database time zone is controlled by the TZ environment variable. If TZ is undefined, Vertica uses the operating system time zone. You can change the default database time zone later by altering the value of the TZ environment variable or the operating system...

Vertica Quick Tip: Keepalive settings for AWS Network Load Balancer

Phil Molea, Sr. Information Developer, Vertica
July 18, 2018

Serge Bonte authored this post. Network Load Balancers are one of the three types of load balancers supported by Amazon’s Elastic Load Balancing. See: https://docs.aws.amazon.com/elasticloadbalancing/latest/network/introduction.html Since load balancers act as a proxy between clients (such as JDBC) and Vertica servers, it is important to understand how AWS’s NLB handle idle timeouts for connections. The idle...
House diagram showing sensors for lights, weather, security, internal temp, etc.

The Internet of Things (IoT) and Smart Metering

Joy King, VP Product & GTM Strategy, Vertica
July 17, 2018

Every month, my husband receives a driver’s report from Chevrolet, providing him with “feedback” on his driving behavior – everything from the intensity of his braking to the number of lane changes without a blinker to the distance and speed he drove in his Silverado truck. The report also provides specific details on the upcoming...

Subscribe For Email Updates

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

Sign-up

Counting Days, Week Days and Weekend Days Across the Years: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 17, 2018

Jim Knicely authored this post. By combing Vertica’s built-in date formatting functions and the TIMESERIES clause, it’s easy to find the total number of days, total number of week days (Monday - Friday), and the total number of weekend days (Saturday - Sunday) that occur within a multi-year range (i.e., 2016 - 2018), including Leap...

Synonyms: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 16, 2018

Jim Knicely authored this post. A synonym in Oracle is an alternative name for a database object (i.e., table, view, sequence, etc.). Synonyms work great when you want to point a user to a specify schema when a schema is not specified in a query. Although synonyms are not used in Vertica, you can instead...

Average Date: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 12, 2018

Jim Knicely authored this tip. Given a list of dates, how do I find the “average” date? Like this… dbadmin=> SELECT AVG(JULIAN_DAY(mydate)) + '4714-11-24 BC'::DATE avg_date dbadmin-> FROM dates; avg_date --------------------- 2018-07-11 00:00:00 (1 row) Have fun!

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

The Case of Object Names: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 11, 2018

Jim Knicely authored this tip. When creating objects in Vertica (i.e., tables), Vertica preserves the “case” of the object name in the catalog meta-data exactly as you ask. dbadmin=> SELECT table_name FROM tables WHERE table_name ILIKE '%lower_case%'; table_name ------------ lower_case (1 row) dbadmin=> DROP TABLE lower_case; DROP TABLE dbadmin=> CREATE TABLE LOWER_CASE (c1 INT); CREATE...
Database Server Room

Using Java UDX in Vertica

Soniya Shah, Information Developer
July 9, 2018

Michael Flower authored this post. Introduction Vertica has a highly extensible UDx framework, which allows external user-defined functions, parsers and data loaders to be installed onto the Vertica server. This means that a routine written in C++, R, Java or Python can be run in-database as a Vertica SQL function. This blog is based on...

DataGals, Colin, Meg, and Micro Focus

Soniya Shah, Information Developer
July 3, 2018

Crystal North authored this post. What is Inclusion & Diversity? What is an ERG? Those questions are asked often and I am beyond excited to answer them. Inclusion & Diversity are what fuels any sort of growth in any capacity. From family, to friends, to education, to community, to company, to organization, etc etc etc,...

Cerner Wins TDWI Best Practices Award

Phil Molea, Sr. Information Developer, Vertica
July 2, 2018

Steve Sarsfield authored this post. It’s amazing to see our customers ‘crush it’ when it comes to their implementation and best practices industry awards. That’s why I was so happy to hear that Cerner, a long-time Vertica customer, is the recipient of TDWI’s Best practices award for data warehouse. I want to congratulate Cerner on...
A cloud of data points with a businessman's hand holding it up on a black background

Announcing Vertica in Eon Mode for Amazon Linux 2, now available in AWS Marketplace

Sarah Lemaire, Manager, Vertica Documentation
June 28, 2018

Vertica is a blazingly fast SQL analytics database, enabling enterprises to access and derive meaningful insight into big data in sub-seconds or minutes rather than hours or days. Vertica powers the world’s most data driven organizations, delivering unmatched speed and scale with the full suite of advanced analytics and in database machine learning. Vertica for...

Changing the Data Type of a Column in an External Table: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
June 28, 2018

Jim Knicely authored this tip. External tables let you query data stored in files that are accessible to the Vertica database, but not managed by it. When you create the external table, you have to provide column names along with their data types. What happens if you get a data type incorrect? Luckily, you can...