Vertica Blog

Concurrency and Workload Management

Vertica workloads range from simple primary key lookups to analytical queries that include several large tables and joins. Different types of load jobs must keep the data updated. Vertica has a mixed-workload management capability that is easy to use. Vertica can process queries both concurrently and in parallel. Concurrency means having multiple jobs running in […]

How to Set Vertica in Read-Only

You probably know that you can create READ ONLY users in Vertica. These users can view everything within a schema, but don’t have the proper permissions to change anything within the database. This is useful for sets of users that don’t need as many permissions or for users that should not be able to change […]

DataGals Hosts a Year Up Event

This week, the DataGals hosted an event to raise awareness for Year Up. Year Up provides young adults, aged 18-24 with the skills and experience they need to succeed in the professional workplace. Here at Vertica, we are proud supporters of the Year Up program. We have hired Year Up interns, who have worked with […]

Check Out Our New LinkedIn Account

The Vertica Technical Team is pleased to announce we have a new LinkedIn account! Please connect with us for the latest posts and updates from the Vertica Community, including the blog and knowledge base. Your feedback helps us create more content that can better serve your needs. If you have ideas or suggestions, please share […]

Understanding Users, Privileges, and Roles

Every Vertica database has one or more users. When users connect to the database, they log in with credentials that a superuser defines. Database users should only have access to the database resources they need to perform their tasks. To navigate these necessities, Vertica has designated users, privileges, and roles. About Users Database users use […]

In-Database Approximate Median and Percentile Functions

This blog post was authored by Ginger Ni. Median and percentile functions are commonly used data statistic functions. They are also used in other sophisticated data analysis algorithms, such as the robust z-Score normalization function. Vertica has exact MEDIAN and PERCENTILE_CONT functions, but these functions do not scale well for extremely large data sets, because […]

Introducing the Vertica Test Drive for Clickstream Analytics

Recently, Vertica engineers introduced the new Vertica for Clickstream Analytics test drive on AWS. If you’re a Vertica user, you might be familiar with our test drives on AWS – both run on SQL on Hadoop. One uses MapR and the other uses Hortonworks. With this test drive, you can discover the capabilities of A/B […]

Getting Rid of Range Joins

You can use range joins to categorize data into buckets. Vertica provides performance optimizations for =, and BETWEEN predicates. These optimizations are particularly useful when a column from one table is restricted to be in a range specified by two columns of another table. Range joins can be long running if you have very large […]

New Uses for Directed Queries

Directed queries were introduced in Vertica 7.2. Directed queries were originally designed to achieve two goals: • Preserve current query plans before a scheduled upgrade. • Enable you to create query plans that improve optimizer performance. Since their introduction, users have found new and compelling ways to use directed queries—notably, using them to substitute one […]

What’s New in Vertica 8.1: Flex Tables Enhancements

As of Vertica 8.1, you can execute CTAS statements to create flex tables. CREATE TABLE AS (CTAS) statement Previously, Vertica supported creating tables using the AS SELECT clause. Frequently called CTAS, this SQL statement lets you create a new table that contains the results from querying another table. However, in previous Vertica versions, CTAS was […]