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...
Hand writing the text: Helpful Tips

View the Query Plan for a COPY Statement

James Knicely, Vertica Field Chief Technologist
May 16, 2019

Vertica 9.2.1 now supports the ability to see the query plan produced by the EXPLAIN command for a COPY command. Wait, where is the plan? Oh, I need at least one table projection to get a plan! Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Statements/EXPLAIN.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/QueryManagement/QueryPlans/ExplainOutputOptions/EXPLAINOutputOptions.htm Have fun!
Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

Paige Roberts, Vertica Open Source Relations Manager
May 10, 2019

This week, some very cool things have gone into the newest version of the Vertica Analytics Platform that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do...
Tips and Tricks Orange Button

Close All Sessions for a User with a Single Command

James Knicely, Vertica Field Chief Technologist
May 9, 2019

The Vertica CLOSE_SESSION function can be used to close a user session one session at a time. If you have a user that has opened a bunch of sessions, closing them one at a time would be a very long and tedious process. That’s where the CLOSE_USER_SESSIONS function comes in handy. It will stop all...

Subscribe For Email Updates

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

Sign-up

Vintage businessman concept wearing futuristic helmet at office

Table Schemas for Global and Local Temp Tables

James Knicely, Vertica Field Chief Technologist
May 8, 2019

By default, Vertica stores Global Temporary Tables in the Public schema and Local Temporary Tables in the V_TEMP_SCHEMA schema. Vertica uses the default schemas if a schema name is not provided when creating temporary tables: I can specify a different schema name for a Global Temporary Table: But not for a Local Temporary Table: Helpful...

DATAx Gaming Analytics Summit in San Francisco

Ben Smith, Senior Product Marketing Manager
May 8, 2019

According to a recent report from Newzoo and Arm, the Mobile Gaming market is expected to top $100 billion by 2021, up from $56 billion in 2017. As the global adoption of smartphones continues to expand, so too does the use of mobile and online gaming. To capitalize on this growth, game developers are looking...
Helpful Tips message on post-it note

Make Comparisons on Subqueries that Return Multiple Rows

James Knicely, Vertica Field Chief Technologist
May 7, 2019

You typically use comparison operators (such as =, >, < ) only on subqueries that return one row. With ANY and ALL operators, you can make comparisons on subqueries that return multiple rows. I want to check if an integer is greater than any of the integers in a set of rows. If I try...

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
Chicago cityscape with various data type icons and network connection concept

Network Optimization Makes Telecom Service Better Than Okay

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
May 1, 2019

For sports fans, there’s nothing that matches the heart-stopping action of the NCAA Division I Men’s Basketball Tournament – more commonly known as March Madness. The tournament in 2019 delivered a four-year high in terms of its Turner ratings, causing an advertiser frenzy in hopes to capture those audiences. If you watched this year’s tournament,...
Business card that says Expert Tips,

Create a Python UDx to Order a List of Values

James Knicely, Vertica Field Chief Technologist
April 25, 2019

User-Defined Extensions (UDxs) are functions contained in external shared libraries that are developed in C++, Python, Java, or R using the Vertica SDK. The external libraries are defined in the Vertica catalog using the CREATE LIBRARY statement. They are best suited for analytic operations that are difficult to perform in SQL, or need to be...

See You at IoT World Conference Next Month

Ben Smith, Senior Product Marketing Manager
April 25, 2019

Are you attending the IoT World Conference in Santa Clara from May 13-16th? Come by booth #1254 to hear why more and more companies, including medical device manufacturers, wearable product developers, network service providers, and manufacturing intelligence software companies, are turning to Vertica to manage their growing volumes of IoT data. Vertica is purpose-built for...
Hand writing the text: Helpful Tips

Forcing a Merge Join

James Knicely, Vertica Field Chief Technologist
April 23, 2019

The Vertica optimizer implements a join with one of the following algorithms: Merge join is used when projections of the joined tables are sorted on the join columns. Merge joins are faster and use less memory than hash joins. Hash join is used when projections of the joined tables are not already sorted on the...
Quick Tip - blue button

Displaying the Vertica Code Name

James Knicely, Vertica Field Chief Technologist
April 23, 2019

Every major release of Vertica has a code name. To find out the Vertica code name of your database, you can query the DC_STARTUPS Data Collector table. Example: Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/QueryingDataCollectorTables.htm Have fun!
Machine learning robot studying equations and graphs

1 – Why Would You Do Machine Learning in a Database?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
April 22, 2019

Co-authored with Paige Roberts. A lot of modern scalable analytical databases like Vertica allow you to do machine learning data analytics from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they...