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...
Commercial passenger plane with Vertica painted on the tail

Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time — Part 7

Mark Whalley, Manager, Vertica Education
April 4, 2019

Preparing Vertica to consume messages from Kafka How time has flown (no pun intended!).  At long last getting back to continuing this project on tracking commercial aircraft… Having covered ADS-B, the Raspberry Pi, DUMP1090, Zookeeper and Kafka and then in the previous blog post, how to develop an Extract, Transform and Load (ETL) application to...

Accept the EULA When Installing Vertica

James Knicely, Vertica Field Chief Technologist
April 3, 2019

After installing Vertica, you have to ACCEPT the EULA the first time you start admintools on any Vertica node. To avoid having to do that, you can accept the EULA during the install using the --accept-eula or –Y option! Example: Helpful Links: https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/InstallingVertica/InstallVerticaScript.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/InstallationGuide/InstallingVertica/InstallingVerticaSilently.htm Have fun!
Big Data sign next to cute baby yellow elephant

Big Data – Big Asset or Big Liability

Joy King, VP Product & GTM Strategy, Vertica
April 2, 2019

The newly converged Cloudera recently announced its quarterly earnings and the market was very disappointed, resulting in a stock price drop of 42% and a lot of negative media coverage. One headline that stuck out to me read: “Does Cloudera’s Stock Drop Signal the End of Big Data?” I thought, “No, I don’t think Cloudera’s...

Subscribe For Email Updates

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

Sign-up

Fun April Fool’s Day Trick Using Directed Queries

James Knicely, Vertica Field Chief Technologist
April 1, 2019

Directed Queries in Vertica encapsulate information that the optimizer can use to create a query plan. Directed queries can serve the following goals: Preserve current query plans before a scheduled upgrade. In most instances, queries perform more efficiently after a Vertica upgrade. In the few cases where this is not so, you can use directed...
Early desktop computer monochrome built-in monitor

Vertica Announces Vertica Analytic Database, Eon Mode on Premises, Academic Edition

Chuck Bear, Vertica Chief Architect
April 1, 2019

April 1, 2019, FOR IMMEDIATE RELEASE Vertica is pleased to announce Vertica in Eon Mode on Premise, Academic Edition.  Vertica’s director of marketing, Ross Pushback, says “Schools have always utilized personal analytics.” [We think he means “report cards” – ed.]   “Our contribution is the flexibility offered by the separation of compute and storage, which schools...

Properly Identifying Identifiers

James Knicely, Vertica Field Chief Technologist
March 29, 2019

Vertica Identifiers (names) of objects such as schemas, tables, projections, column names, and so on, can be up to 128 bytes in length. Unquoted SQL identifiers must begin with one of the following: Non-Unicode letters: A–Z or a-z Underscore (_) Subsequent characters in an identifier can be any combination of the following: Non-Unicode letters: A–Z...

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

Welcome to the New Vertica Blog!

Ben Smith, Senior Product Marketing Manager
March 28, 2019

If you're a regular visitor to the vertica.com website, you've probably noticed a few changes to our blog recently. The Vertica team is excited to launch our new and improved blog in order to help you, our audience, more easily navigate posts, explore specific areas of interest, and follow your favorite contributors. Same great content;...

Run the Same Query Over and Over Again in vsql

James Knicely, Vertica Field Chief Technologist
March 28, 2019

The \g vsql meta-function sends the query in the input buffer to the server. This is great for interactively testing if a previous query run time was a fluke, and you don’t feel like typing in a long SQL statement again. Example: Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/MetaCommandReference.htm Have fun!

Display a Query Title in vsql

James Knicely, Vertica Field Chief Technologist
March 27, 2019

The \C vsql meta-function allows you to specify a title string to display with query output! Example: Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/MetaCommandReference.htm Have fun!
Save the Date, Vertica Big Data Conference, March 30 - April 2

Save the Date for the Vertica Big Data Conference

Joy King, VP Product & GTM Strategy, Vertica
March 27, 2019

The next Vertica Big Data Conference (BDC) will be taking place March 30 – April 2, 2020, hosted at the brand-new Encore Boston Harbor Hotel in Boston, Massachusetts! In our very crowded and noisy market, there are more tradeshows and conferences than there are days in the year. So why should anyone be excited about...
Business person checking graph on digital tablet

Embedding Vertica Provides SysMech With Unmatched Telco Analytical Power

Paige Roberts, Vertica Open Source Relations Manager
March 27, 2019

You probably use Vertica on a daily basis, and don’t even realize it. One good example of this for the Telco industry is SysMech. SysMech offers telecommunications companies a powerful new generation of service management applications. SysMech makes Zen Operational Intelligence Software, which embeds Vertica as its analytical engine. Zen correlates complex data from 75...

Convert a String to a Date, Including Unconventional Dates

James Knicely, Vertica Field Chief Technologist
March 26, 2019

The built-in Vertica function TO_DATE converts a string value to a DATE type. Example: We all know that there are 31 days in March. But are there 32 or 33 days in March? No. Vertica simply extends the date returned into the next month! Also note there is no 13th month! Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TO_DATE.htm Have...