Vertica Receives High Rankings in All Four Data Warehouse Use Cases in Gartner Critical Capabilities for Data Management Solutions for Analytics Report

This week, Gartner published its Critical Capabilities for Data Management Solutions for Analytics (DMSA) report. This research scores 19 vendors in the Data Management Solutions market based on four primary data warehouse use cases: Traditional Data Warehouse, Real-Time Data Warehouse, Logical Data Warehouse, and Context-Independent Data Warehouse. Vertica increased its rankings from 2018 in all […]

Maxcom Telecomunicaciones Gets More Than They Bargained For With Vertica

Maxcom Telecomunicaciones is a Mexican integrated telecommunications operator providing managed voice and data services. The Mexican federal regulations changed recently, requiring Maxcom to retain call detail record (CDR) data for two years, rather than two months. It also required them to answer queries on that data far faster, sometimes within an hour, any time of […]

Brace Yourself: 5G is Coming

  Whether you work in the telecommunications and mobile operator markets or not, you’ve undoubtedly heard the buzz around 5G networks and how they’ll change the relationship among smart phones, carriers, and consumers. For those who haven’t kept up with this news, 5G is the next generation cellular wireless network expected to launch broadly in […]

Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

When your query contains the ORDER BY clause to sort the result set, alphanumeric NULL data will sort to the bottom if the sort is in ascending order (ASC) and to the top if the sort is in descending order (DESC), while integer NULL data does the opposite. Example: dbadmin=> \d test List of Fields […]

In Loving Memory of Phil Molea

  Phil worked for Vertica as an Information Developer for close to five years.  He was a very important part of our Vertica team and part of our Vertica family. Phil enjoyed working in the Vertica community, the base product documentation, as well as with our Technology Partners.  He was very well liked and respected […]

Do you have experience using Vertica?

The Vertica Product Management team is collecting feedback on what new features and functionality our customers would like to see added to the product. We’ve been actively gathering product-related feedback for nearly a year and have been using it to make more informed decisions about how we manage the Vertica product roadmap. Thank you for […]

Using sed to Handle Empty String NULL Values Enclosed in Control Characters

You can load data files into a Vertica table using the COPY command. Your data can be delimited and separated by control characters. Unfortunately if you also enclose NULL values as an empty string, you might run into a data cast issue. Example: dbadmin=> \d test1 List of Fields by Tables Schema | Table | […]

Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

You can load data files into a Vertica table using the COPY command. Your data can be delimited and separated by control characters. Unfortunately if you also enclose NULL values as an empty string, you might run into a data cast issue. Example: dbadmin=> \d test1 List of Fields by Tables Schema | Table | […]

Monitor/Clean Up the CopyErrorLogs Directory

The COPY statement automatically saves a copy of each rejected row in a rejected-data file. COPY also saves a corresponding explanation of what caused the rejection in an exceptions file. By default, Vertica saves both files in a database catalog subdirectory called CopyErrorLogs. After you’ve reviewed and resolved any issues with the load, it’s a […]

Tracking the Current Transaction Start Date and Time

The built-in Vertica function TRANSACTION_TIMESTAMP returns a value of type TIME WITH TIMEZONE, which represents the start of the current transaction. It’s very useful for keeping track of when the transaction started for a group of table inserts. Example: dbadmin=> SELECT * FROM test; c1 | created_timestamp | created_transaction_timestamp —-+——————-+——————————- (0 rows) dbadmin=> INSERT INTO […]