Vertica Blog

Welcome to the New Vertica Blog!

Posted March 28, 2019 by Ben Smith, Senior Product Marketing Manager

Read More

Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

This week, some very cool things have gone into the newest version of the that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do exactly that. But,...
Chicago cityscape with various data type icons and network connection concept

Can You Hear Me Now? Network Optimization at Work

For sports fans, there’s nothing that matches the heart-stopping action of the NCAA Division I Men’s Basketball Tournament – more commonly known as March Madness. This year’s tournament delivered a four-year high in terms of its , causing an advertiser frenzy in hopes to capture those audiences. If you watched this year’s tournament, you couldn’t...
Cupcakes with blue icing and lit birthday candles

How Old Am I (In Months)?

You are probably aware that Vertica has a built-in function named AGE_IN_YEARS. It returns the difference in years between two dates, expressed as an integer. Example: My son is turning 18 this year! I was curious to know how many months he’s been on the planet, so I figured that I could just multiply his...
Machine Learning programmer in glasses looks at graphs

Data Analytics and Machine Learning for Start-Ups on the Fast Track

Tuesday, 4/30/19 Workbar Back Bay 6:00-8:00 PM Are you a data-driven start-up that makes decisions based on insight from high-performance analytics and machine learning? Would you like to choose the best analytical tool/ML for the job beyond limited open source offerings, but don’t have the budget? Do you want to hear best practices on how...

5 companies that are using data analytics to transform customer experience

Analyzing customer behavior is becoming a mandate for every business in every industry to understand, engage, and retain customers – with the ultimate goal of increasing lifetime value. By understanding how your customers behave and interact with your organization, you can better serve, and profit, from the interactions. Data is central to this equation in...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Display the Vertica Process Memory Allocated

For common Vertica cluster configurations, there should be a single running Vertica process on each node. You can use the Linux ps command to determine the process ID of the Vertica process. Once you have the process ID, you can display the amount of memory that has been allocated to the Vertica process using the...

Display Database Statement Counts by Type

There are many types of statements that can be executed in Vertica. Examples include queries, DDL (Data Definition Language), and utility statements. To summarize all the types of statements being executed, you can query the QUERY_PROFILES system table. Example: I’d like to view a count of each statement type across my cluster since the first...
Vertica Team at Data Innovation Summit booth

Data Innovation Summit 2019

Having attended the Big Data Analytics – Europe event in Rotterdam on the 12th March, on 14th/15th, Captain Mark Whalley and fellow Captains from Vertica Airways paid a flying visit to the Whilst there, they crewed the Vertica booth answering questions from passengers and visitors and assuring them that their journey with Vertica would be...

Explore Popular Topics

Hand writing the text: Helpful Tips

Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

Time series analytics evaluate the values of a given set of variables over time and group those values into a window (based on a time interval) for analysis and aggregation. This feature comes in handy if I need to generate a list of dates using some interval, for example 1 MONTH. Example: But why did...
Southern Data Science Conference, April 11, 12

Join Vertica at the Southern Data Science Conference in Atlanta

Next week – April 11-12 – Atlanta, GA will host the . Held at the Crowne Plaza Atlanta Midtown, this event is geared to data scientists converging to hear from the industry’s best and brightest minds from top companies and research institutes. More than 400 attendees will attend two days of sessions, covered by more...

Truncating a Timestamp

The built-in Vertica function DATE_TRUNC truncates date and time values to the specified precision. The return value is the same data type as the input value. All fields that are less than the specified precision are set to 0, or to 1 for day and month. Example: So did the current Millennium begin on January...
Commercial passenger plane with Vertica painted on the tail

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

Preparing Vertica to consume messages from Kafka How time has flown (no pun intended!).  At long last getting back to continuing this project on tracking commercial aircraft… Having covered ADS-B, the Raspberry Pi, DUMP1090, Zookeeper and Kafka and then in the how to develop an Extract, Transform and Load (ETL) application to present a continuous...

Partition a Table By More Than One Column

The Vertica partitioning capability divides one large table into smaller pieces based on values in one or more columns. Partitions can make data lifecycle management easier and improve the performance of queries whose predicate is included in the partition expression. To partition a table by more than one column, use the HASH function! Example: Helpful...

Accept the EULA When Installing Vertica

After installing Vertica, you have to ACCEPT the EULA the first time you start admintools on any Vertica node. To avoid having to do that, you can accept the EULA during the install using the --accept-eula or –Y option! Example: Helpful Links: Have fun!