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

Vertica Quick Tip: Projection Create Types

Soniya Shah, Information Developer
April 2, 2018

This blog post was authored by Jim Knicely. The DDL produced by the EXPORT_OBJECTS function typically contains a create type for a projection. In the above example the create type is L for “Lazy”, meaning that I inserted data into the table when no projections existed yet. Here is a list of the projection create...
Commercial passenger plane with Vertica painted on the tail

Vertica Wins First Place for Edge-Based Analytics at University of Central Arkansas Raspberry Pi Bakeoff

Tim Donar
April 2, 2018

We had the opportunity to enter our Vertica flight tracking demo at the University of Central Arkansas’s university raspberry pi bakeoff. We won first place, competing against a number of other raspberry pi-based projects! For more information on how to use Vertica to track commercial aircraft in near real time, read Mark Whalley’s blog series...

Improving Performance and Memory Acquisitions for Vertica Queries

Soniya Shah, Information Developer
March 29, 2018

This blog post was authored by Shrirang Kamat. The following design considerations will help you improve the performance and memory of your Vertica queries. When creating table definitions, you should carefully choose the size of the lookup column based on your data. Properly sizing your column based on your data will help to improve performance....

Subscribe For Email Updates

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

Sign-up

Vertica Quick Tip: Summary of Cluster State

Soniya Shah, Information Developer
March 29, 2018

This blog post was authored by Jim Knicely. The GET_CLUSTER_STATE_SUMMARY function can be used to quickly view the current status of your Vertica cluster. All nodes are up: One node is down: dbadmin=> SELECT get_cluster_state_summary(); get_cluster_state_summary --------------------------------------------------------------------------------------------------------------------------- Cluster State: test2 UNKNOWN: 1 of 4 (v_test2_node0004) UP: 3 of 4 (v_test2_node0001, v_test2_node0002, v_test2_node0003) (1 row) Have...

Vertica Quick Tip: What’s the Maximum Column Size?

Soniya Shah, Information Developer
March 28, 2018

This blog post was authored by Jim Knicely. There exists a maximum number of characters that can be stored in columns having a data type of VARCHAR or LONG VARCHAR. In case you’ve forgotten those maximum values for the version of Vertica you are using, there are two handy functions that provide this information. To...
Commercial passenger plane with Vertica painted on the tail

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

Mark Whalley, Manager, Vertica Education
March 27, 2018

Part 6: Extract, Transform and Load ADS-B messages into Kafka I have discussed in previous blog posts the continuous stream of messages from aircraft transponders, captured and decoded using the DUMP1090 application, which we are planning on feeding into a series of Kafka topics, prior to loading into their corresponding tables in a Vertica database....

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
Three 3D arrows, different colors pointing in different directions

Vertica Quick Tip: Case Insensitive Session Queries

Soniya Shah, Information Developer
March 27, 2018

This blog post was authored by Jim Knicely. By default Vertica is case sensitive when it comes to comparing strings. You can change this behavior by setting the session locale to LEN_S1. Note that you will see a pretty hefty performance hit when using the LEN_S1 locale. A better option would be to store your...

Vertica Quick Tip: Automatically Close an Idle Session

Soniya Shah, Information Developer
March 26, 2018

This blog post was authored by Jim Knicely. The IDLESESSIONTIMEOUT parameter can be used to close a session that has been idle for a period of time. An idle session is one that has no queries running. dbadmin=> \c - jim You are now connected as user "jim". dbadmin=> SELECT current_session(); current_session ------------------------------- v_test2_node0001-3667:0x2a19e (1...
Data Gals

What is it like being a girl in a room of many boys?

Soniya Shah, Information Developer
March 26, 2018

This blog post was authored by Crystal Farley (North). I volunteered to be the Chairperson for the virtual chapter of DataGals because I think connecting women across the world is a great way to continue to #PushforProgress. Why not bridge the gap and create a community where we encourage diversity and inclusion of everyone that...
Programmer

How Cisco and Vertica empower high performance analytics for the most demanding workloads

Soniya Shah, Information Developer
March 22, 2018

This blog post was authored by Steve Sarsfield. Hadoop and HDFS is capable of storing massive volumes of data, but performing analytics on Hadoop can be challenging. Despite the apparent low-cost cost of Hadoop, it is best suited for data lake and data science solutions, where the number of concurrent analytical users is low. In...

Vertica Quick Tip: EXPLAIN Plan in JSON Format

Soniya Shah, Information Developer
March 22, 2018

This blog post was authored by Jim Knicely. The EXPLAIN command returns the optimizer's query plan for executing a specified query. ------------------------------ QUERY PLAN DESCRIPTION: ------------------------------ EXPLAIN SELECT the_date FROM big_date_table WHERE the_date_as_date BETWEEN '09-19-2017' AND '09-19-2018'; Access Path: +-STORAGE ACCESS for big_date_table [Cost: 5M, Rows: 25M] (PATH ID: 1) | Projection: public.big_date_table_super | Materialize:...

Projection Delete Concerns

Soniya Shah, Information Developer
March 21, 2018

This blog post was authored by Curtis Bennett. Deletes in Vertica are a complicated topic. I’ve had many people say to me that they’d heard that one should never do deletes in Vertica, or that deletes in Vertica are slow. Nothing could be further from the truth. But like anything in a database, they should...