Vertica Blog

Vertica Blog


surprised data analyst

What You Never Knew About Vertica Could Surprise You

I just started working on the Vertica team. As the “new guy,” my first few weeks of work have been largely about cramming as much Vertica information into my brain as possible in the shortest time possible. That’s my favorite part of working in the big data analysis world. You always have to keep learning....

Exporting to Parquet: Quick Tip

Jim Knicely authored this tip. Vertica can export a table, columns from a table, or query results to files in the Parquet format. dbadmin=> EXPORT TO PARQUET (directory = '/home/dbadmin/dim') AS SELECT * FROM dim; Rows Exported --------------- 1 (1 row) One restriction is the path to export must not exist. How do I get...
Small chalkboard on a desk with Thank You written on it

Thanks, Google!

This week began with a compliment from Google that made me so proud on behalf of Vertica! On Wednesday, July 25, at the with two algorithms – linear and logistic regression – and also confirmed that these new machine learning functions could be accessed using standard SQL via Google BigQuery, opening the door for database...
House diagram showing sensors for lights, weather, security, internal temp, etc.

The Internet of Things (IoT) and Smart Metering

Every month, my husband receives a driver’s report from Chevrolet, providing him with “feedback” on his driving behavior – everything from the intensity of his braking to the number of lane changes without a blinker to the distance and speed he drove in his Silverado truck. The report also provides specific details on the upcoming...

Saving an Apache Spark DataFrame to a Vertica Table

Before you save an Apache Spark DataFrame to a Vertica table, make sure that you have the following setup: • Vertica cluster • Spark cluster • HDFS cluster. The Vertica Spark connector uses HDFS as an intermediate storage before it writes the DataFrame to Vertica. This checklist identifies potential problems you might encounter when using...

Can you tell us about your data lake?

It's the fourth round of Vertica product management surveys and we have really appreciated getting your feedback! In this survey, we want to know all about your data lake. We want to know what tools you use, how much data is in your lake, and the types of workloads you are running. We are hoping...
Diagram of Vertica compute and storage together in Enterprise Mode and storage centralized, and compute separate in Eon Mode

Introducing the Eon Mode Concept

Vertica was born at a tipping point in the world of Enterprise Data Warehouses. It was designed from the first line of code to address new levels of data volumes and analytical performance. But it was also designed to break the tightly integrated hardware and software appliances offered by industry leaders at the time including...

How Cisco and Vertica empower high performance analytics for the most demanding workloads

This blog post was authored by Steve Sarsfield. Hadoop and HDFS is capable of storing massive volumes of data, but performing analytics on Hadoop can be challenging. Despite the apparent low-cost cost of Hadoop, it is best suited for data lake and data science solutions, where the number of concurrent analytical users is low. In...

Introducing the Parallel Streaming Transformation Loader (PSTL) Solution

This blog post was authored by Soniya Shah. At Vertica, we understand how important it is that our customers can make decisions in near real time. Being able to do this not only requires the massive parallel processing that Vertica offers, but the ability to transform and ingest your data into Vertica as quickly as...

CIO Forum – New York

Attending CIO Forum this year? Come see

The Right Tool for the Job: Using Apache Hadoop with Vertica for Big Data Analytics

I have an entrepreneur friend who used to carry a butter knife around.  He claimed this “almighty” tool was the only one he ever needed!  While the butter knife does serve a wide range of purposes (especially with a stretch of the imagination), in practice it doesn't’ always yield optimal results.  For example, as a...

Installing Vertica SQL on Hadoop

Interested in adding Vertica's analytic capabilities to your Hadoop cluster? Watch this tutorial video to learn how you can install Vertica on Hadoop, giving it faster access to your data!