Vertica Quick Tip: Who am I?

Soniya Shah, Information Developer
May 10, 2018

This blog post was authored by Jim Knicely. There are several ways to figure out who is the session user. This comes in handy for logging. Type: \h or \? for help with vsql commands \g or terminate with semicolon to execute query \q to quit jim=> select user; current_user -------------- jim (1 row) jim=>...

Vertica Quick Tip: Eon Mode

Soniya Shah, Information Developer
May 9, 2018

This blog post was authored by Jim Knicely. You can now deploy a Vertica cluster with an Eon Mode database instead of an Enterprise mode database. In Enterprise Mode, the original Vertica "share nothing" configuration, each database node stores a portion of the data and performs a portion of the computation. In Eon Mode, computational...

Vertica Quick Tip: Using vsql Almost Anywhere

Soniya Shah, Information Developer
May 8, 2018

This blog post was authored by Jim Knicely. I’m an old school kind of guy so I love our vsql command line interface (CLI) tool. What’s cool is if I am on a remote Linux host, I can copy the vsql binary from the database host and run then run it locally. [dbadmin@s18384357 ~]$ scp...

Subscribe For Email Updates

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

Sign-up

Vertica Quick Tip: User Defined Functions to the Rescue

Soniya Shah, Information Developer
May 7, 2018

This blog post was authored by Jim Knicely. A friend recently asked me why we don’t have certain functions available in Vertica that are offered in databases like MySQL. I shrugged it off as we have bigger fish to fry. But he kept pushing so I showed him how easy it is to implement a...

How do you use Vertica analytics and machine learning today?

Soniya Shah, Information Developer
May 4, 2018

One of the coolest aspects of Vertica is its in-database machine learning functionality. As part of our third round of product management surveys, we're asking you to take the time to answer how you use Vertica analytics today. We're hoping to get answers we can use to expand upon our growing analytics and machine learning...

Vertica in Eon Mode Paper Accepted for ACM SIGMOD/PODS Conference

Soniya Shah, Information Developer
May 4, 2018

Every year, the ACM SIGMOD/PODS conference is held as a forum for database researchers, developers, and users to explore innovations in the field and exchange ideas. The conference is an opportunity for thought leaders to talk with each other and hear from one another through presentations, workshops, and tutorials. This year, Ben Vandiver, Shreya Prasad,...

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

Vertica in Eon Mode: Tables, Parameters, Functions, and Useful Queries

Soniya Shah, Information Developer
May 3, 2018

This blog post was authored by Rakesh Bankula. The purpose of this document is to list new system tables, configuration parameters and meta-functions that were added for Vertica Eon mode. This document also has sample queries you can run on the new system tables to get up to speed with Eon mode. This document assumes...
Three 3D arrows, different colors pointing in different directions

Vertica Quick Tip: Get Rid of all Those Q’s

Soniya Shah, Information Developer
May 3, 2018

This blog post was authored by Jim Knicely. If you guys are like me I prefer the CLI. So admintools is my friend. However, at many client sites I see admintools is kind of ugly. So to get it looking a little better: Run this in Linux: And add the command to your .bashrc file...

Vertica Quick Tip: Forget the Column Name of a System Table?

Soniya Shah, Information Developer
May 2, 2018

This blog post was authored by Jim Knicely. If you are like me I am constantly forgetting the column names from our system tables. Use this simple trick to get the column names. Have Fun!
Modern Database Analytics

Vertica Quick Tip: Capitalize Only the First Letter of Each Word

Soniya Shah, Information Developer
May 1, 2018

This blog post was authored by Jim Knicely. A few years ago when I was an Oracle DBA a client thought they’d stump me by asking how they could capitalize only the first letter of each word for a given input. I immediately said try the initcap function. She was amazed. Guess what, Vertica has...
Programmer

Constantly Inspired #StandUp #LiftUp

Soniya Shah, Information Developer
May 1, 2018

This blog post was authored by Crystal North. Wow. I have spent the last month reflecting every single work day as to why I love my job. I started this personal focus because I had read one too many status updates on LinkedIn that just seemed so unauthentic, so negative, or so salesy. I wanted...

Running an Eon Mode Database: Live in Vertica 9.1

Soniya Shah, Information Developer
May 1, 2018

This blog post was authored by Sarah Lemaire. Before now, you could only operate your Vertica database in Enterprise Mode, the traditional Vertica architecture where your data is distributed across the local nodes. Now, Vertica 9.1, released in April, 2018, allows you to operate your database in Eon Mode, which was previously released as beta...