Modern Database Analytics

What’s New in Vertica 9.0.1: Ranger Integration

Soniya Shah, Information Developer
January 31, 2018

This blog post was co-authored by Mitchell Tracy and Monica Cellio. Hadoop clusters can use authorization services to determine which users can access what data in Hive and, by extension, HDFS. In Vertica 9.0 we added support for one of the most common such services, Apache Sentry, and in 9.0.1 we now support Apache Ranger...
Programmer

Vertica Quick Tip: Proper Ordering of IP Addresses

Soniya Shah, Information Developer
January 31, 2018

This blog post was authored by Jim Knicely. Often times we store IP addresses in a VARCHAR column in a Vertica table. When querying the data and sorting by the IP address, we see that IP addresses are sorted by its VARCHAR value instead of its numeric value. Fortunately Vertica has the INET_ATON function which...

Vertica at the Aeronaut Brewery: Adventures in Data Architecture

Soniya Shah, Information Developer
January 30, 2018

This blog post was authored by Sarah Lemaire. Vertica hosted a Meetup at the Aeronaut Brewery in Somerville for customers and prospective customers, including data scientists from Nuance, J.Jill, and True Fit. After some cold beer to warm us up on a cold night, we were lucky enough to hear JB Huang, Head of Data...

Subscribe For Email Updates

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

Sign-up

Vertica Quick Tip: The <=> operator

Soniya Shah, Information Developer
January 30, 2018

This blog post was authored by Jim Knicely. The operator performs an equality comparison like the = operator, but it returns true, instead of NULL, if both operands are NULL, and false, instead of NULL, if one operand is NULL. Have fun!

Vertica Quick Tip: A Truly Unique Constraint

Soniya Shah, Information Developer
January 29, 2018

This blog post was authored by Jim Knicely. According to the ANSI standards SQL:92, SQL:1999, and SQL:2003, a UNIQUE constraint should disallow duplicate non-NULL values, but allow multiple NULL values. A Unique Constraint in Vertica does just that! But what if I do not want to allow more than one NULL value? Well, there’s a...

What’s New in Vertica 9.0.1: S3 Backup Encryption

Soniya Shah, Information Developer
January 29, 2018

This blog post was authored by James Kelley. Amazon S3 offers flexibility, efficiency, and scale. But does it offer security? With the release of Vertica 9.0.1, Vertica offers users the ability to encrypt their backups to S3 with server-side encryption. Vertica supports the following forms of S3 encryption: Server-Side Encryption with Amazon S3-Managed Keys (SSE-S3)...

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
Database Server Room

What’s New in Management Console 9.0.1

Soniya Shah, Information Developer
January 25, 2018

This blog post was authored by Lisa Donaghue. Vertica 9.0.1 introduces Management Console (MC) improvements to cloud monitoring. Tag AWS Instances Management Console with Provisioning, available on the AWS Marketplace, includes a Cluster Creation wizard to provision databases on AWS resources. With Vertica 9.0.1, you can tag instances as you create them through the Cluster...

Vertica Quick Tip: Lightning Fast Text Search

Soniya Shah, Information Developer
January 25, 2018

This blog post was authored by Jim Knicely. Searching the contents of a sizeable CHAR, VARCHAR, LONG VARCHAR, VARBINARY, or LONG VARBINARY field within a table to locate a specific keyword can be quite time consuming. Especially when dealing in Big Data. Fortunately, Vertica includes a text indexing feature which allows you to query that...
Database Server Room

Vertica Quick Tip: Generating a Random String

Soniya Shah, Information Developer
January 24, 2018

This blog post was authored by Jim Knicely. We saw in a previous Vertica Quick Tip that we can create a SQL function that generates random dates. How about one that generates random strings? Have fun!

Loading in Eon Mode

Soniya Shah, Information Developer
January 23, 2018

This blog was co-authored by Yuanzhe Bei, Ryan Roelke, Amin Saeidi, Soniya Shah, and Natalia Stavisky. This blog was updated in July 2018. Overview As of Vertica 9.1.x, you can operate your database in Eon Mode. Eon Mode separates the computational processes from the storage layer of your database. Deployment of Eon Mode is limited...

Vertica Quick Tip: Which Rows Will Commit?

Soniya Shah, Information Developer
January 23, 2018

This blog post was authored by Jim Knicely. Did you ever update a bunch of rows in a table, then forget which ones you changed? Fearing you might have updated an incorrect record, you might have to roll back and start again. Or, in Vertica you can first check which records have been modified prior...

Vertica Quick Tip: Date Arithmetic with Intervals

Soniya Shah, Information Developer
January 22, 2018

This blog post was authored by Jim Knicely. In the last Vertica Quick Tip we saw how easy date arithmetic can be. Well, it can be even easier with Intervals! What is today’s, yesterday’s and tomorrow’s date? Again, you’re not limited to whole days! You can also easily add and subtract partial days (i.e. hours,...