Small chalkboard on a desk with Thank You written on it

Thanks, Google!

Joy King, VP Product & GTM Strategy, Vertica
July 31, 2018

This week began with a compliment from Google that made me so proud on behalf of Vertica! On Wednesday, July 25, at the Google Cloud Next 2018 event, Google launched a Machine Learning (ML) beta with two algorithms – linear and logistic regression – and also confirmed that these new machine learning functions could be...

What are your Data Loading Preferences?

Soniya Shah, Information Developer
July 30, 2018

We’re back with our newest product management survey for this summer! This time we’re asking about how you load your data – everything from the ETL tools you use to how you manage your information. The answers you provide will help us fit Vertica into your infrastructure in a way that is ideal for your...

Comparing Two Times: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 30, 2018

Jim Knicely authored this tip. There are several cool built-in functions that you can use to compare two times. Have fun!

Subscribe For Email Updates

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

Sign-up

Avoid a Division by Zero Error with the NULLIF and NULLIFZERO Functions: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 30, 2018

Jim Knicely authored this tip. The NULLIF built-in Vertica function compares two expressions. If the expressions are not equal, the function returns the first expression. If the expressions are equal, the function returns NULL. The NULLIFZERO built-in Vertica function evaluates to NULL if the value in the column is 0. Both come in handy when...
Three 3D arrows, different colors pointing in different directions

Determining Candidate Segmentation Keys: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 26, 2018

Jim Knicely authored this tip. Hash segmentation allows you to segment a projection based on a built-in hash function that provides even distribution of data across multiple nodes, resulting in optimal query execution. In a projection, the data to be hashed consists of one or more column values, each having a large number of unique...
Convenience in big letters in the center and lots of little images around it of conveniences like mobile phones, global searches, public transportation, etc.

Convenience But at What Cost?

Joy King, VP Product & GTM Strategy, Vertica
July 25, 2018

Convenience is so important to me. Move quickly and get things done. That’s probably why I am so addicted to Amazon Prime despite the fact that I could save money if I would just do a little research and find better prices for the things I buy. My impatience and one click buyer behavior is...

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
Modern Database Analytics

Comparing Two Dates: Quick Tip

Sarah Lemaire, Manager, Vertica Documentation
July 25, 2018

Jim Knicely authored this post. There are several cool built-in functions that you can use to compare two dates. Have fun!
Programmer

Sending Emails from the Vertica Database

Phil Molea, Sr. Information Developer, Vertica
July 25, 2018

Maurizio Felici authored this post. You can create an external procedure to send alert emails from the Vertica database. For more information on external procedures see Using External Procedures in the Vertica documentation. Follow the procedure below to create an external procedure for sending emails. NOTE: These procedures were performed on the Linux OpenSUSE distribution....

Table Last Accessed

Sarah Lemaire, Manager, Vertica Documentation
July 24, 2018

Jim Knicely authored this post. You can query the data collector table DC_PROJECTIONS_USED to ascertain when a table was last accessed and by whom. Helpful Links: PROJECTION_USAGE Querying Data Collector Tables Have fun!

Master Blog Series : Vertica in Eon Mode

Soniya Shah, Information Developer
July 23, 2018

This post was authored by Soniya Shah. In Vertica 9.0 we introduced Eon Mode. Since then, there have been many improvements in recent releases. Vertica in Eon Mode is a new architecture that separates compute and storage, allowing users to take advantage of cloud economics that enable rapid scaling and shrinking of clusters in response...

Determining the Per-Node Storage of a Segmented Table

Sarah Lemaire, Manager, Vertica Documentation
July 23, 2018

Jim Knicely authored this blog. You can join a few system tables together to find the disk space used and the row counts by node for segmented tables: Skew in the data distribution across the nodes is an indicator of a poor choice of the table's segmentation key. Have fun!
Database Server Room

How many seconds since midnight?

Sarah Lemaire, Manager, Vertica Documentation
July 19, 2018

Jim Knicely authored this post. There are many reasons you might want to know the number of seconds that have passed since midnight (i.e. Event Logging). You could combine several Vertica built-in date manipulation functions to calculate the number of seconds since midnight, but the easiest way is to use the MIDNIGHT_SECONDS function! The MIDNIGHT_SECONDS...