Vertica Blog
Soniya Shah smiling

Soniya Shah

Information Developer

Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.

I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.

Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!

Connect With Soniya on

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

What’s New in Vertica 9.1?

Soniya Shah, Information Developer
April 30, 2018

This blog post was authored by Soniya Shah. In Vertica 9.1 we introduce new functionality including: • Eon Mode, now available in production environments • Machine Learning Enhancements • Management Console Updates • Voltage SecureData Integration • Python UDTF • AWS Licensing Updates • Security Updates • Upgrade and Installation Changes • S3 Session Parameter...

Understanding the Vertica Query Optimizer

Soniya Shah, Information Developer
April 26, 2018

This blog post was authored by Soniya Shah. The Vertica query optimizer uses statistics about the data to create a query plan, which contains a set of operations to compute the requested result. Depending on the properties of the projections defined in your database, the optimizer can choose faster and more efficient operations. This is...

Upgrading Vertica

Soniya Shah, Information Developer
April 24, 2018

This blog post was authored by Soniya Shah. With each release, Vertica adds new features and enhancements. To access these new features, you must upgrade your database. Before performing an upgrade, you must shut down your database. Upgrade Path You should always upgrade only to the immediate next version. Upgrading to a version that is...
Database Server Room

Using Vertica Machine Learning to Analyze Smart Meter Data

Soniya Shah, Information Developer
April 23, 2018

Machine learning and data science have the potential to transform businesses because of their ability to deliver non-obvious, valuable insights from massive amounts of data. However, many data scientist's workflows are hindered by computational constraints, especially when working with very large data sets. While most real-world data science workflows require more than multiple cores on...

Vertica Quick Tip: Check if a Date Range Overlaps another Date Range

Soniya Shah, Information Developer
April 19, 2018

This blog post was authored by Jim Knicely. The OVERLAPS Vertica built-in function evaluates two time periods and returns true when they overlap, false otherwise. dbadmin=> SELECT (DATE '2018-04-18', DATE '2018-04-21') OVERLAPS (DATE '2018-04-22', DATE '2018-04-25'); overlaps ---------- f (1 row) Have Fun!

Vertica Quick Tip: Getting the Root of a Number

Soniya Shah, Information Developer
April 18, 2018

This blog post was authored by Jim Knicely. You can find the square root of a number with the |/ operator and the cube root of a number with the ||/ operator. Have Fun!