Vertica Blog

Vertica Blog

Hadoop

Exporting to Parquet: Quick Tip

Phil Molea, Sr. Information Developer, Vertica
August 29, 2018

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!

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...
House diagram showing sensors for lights, weather, security, internal temp, etc.

The Internet of Things (IoT) and Smart Metering

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

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...
Programmer

Saving an Apache Spark DataFrame to a Vertica Table

Soniya Shah, Information Developer
June 14, 2018

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?

Soniya Shah, Information Developer
June 5, 2018

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

Joy King, VP Product & GTM Strategy, Vertica
May 16, 2018

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...
Programmer

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

Soniya Shah, Information Developer
March 22, 2018

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

Soniya Shah, Information Developer
March 19, 2018

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

maura.mcginnis@hpe.com
October 23, 2017

Attending CIO Forum this year? Come see
Programmer

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

Chana Zolty
July 26, 2016

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

Gary Gray, Principal Information Developer
January 27, 2016

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!

Kerberos Authentication for Hadoop Integration: Keeping your data safe

Sarah Lemaire, Manager, Vertica Documentation
August 27, 2015

Like all Vertica releases, 7.1.2 includes a bunch of new features. One specific feature can help make your HDFS data safer: Kerberos integration for Hadoop. This blog will give you an overview of using Kerberos authentication with Vertica for SQL on Hadoop.