Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

We are happy to announce the alpha release of the Vertica SQL Driver for Go. Go, also called GoLang, is a statically-typed, high performance language, syntactically similar to C. Originating at Google, it has grown rapidly in popularity over the past decade and has become a language of choice for highspeed components. The Vertica SQL...
hands in surgical gloves hold vial with small amount of blood

Is Data Warehouse as a Service Out for Your Blood?

Last weekend, I finally had the chance to watch the popular, yet alarming HBO documentary – . If you haven’t seen it, it’s a true story that centers on Elizabeth Holmes, ex-Theranos CEO, who dropped out of Stanford to build a company that promised to revolutionize blood testing using a small amount of blood from...
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...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

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!

Explore Popular Topics

Big Data sign next to cute baby yellow elephant

Big Data – Big Asset or Big Liability

The newly converged Cloudera recently announced its quarterly earnings and the market was very disappointed, resulting in a stock price drop of 42% and a lot of negative media coverage. One headline that stuck out to me read: “Does Cloudera’s Stock Drop Signal the End of Big Data?” I thought, “No, I don’t think Cloudera’s...

Fun April Fool’s Day Trick Using Directed Queries

Directed Queries in Vertica encapsulate information that the optimizer can use to create a query plan. Directed queries can serve the following goals: Preserve current query plans before a scheduled upgrade. In most instances, queries perform more efficiently after a Vertica upgrade. In the few cases where this is not so, you can use directed...
Early desktop computer monochrome built-in monitor

Vertica Announces Vertica Analytic Database, Eon Mode on Premise, Academic Edition

April 1, 2019, FOR IMMEDIATE RELEASE Vertica is pleased to announce Vertica in Eon Mode on Premise, Academic Edition.  Vertica’s director of marketing, Ross Pushback, says “Schools have always utilized personal analytics.” [We think he means “report cards” – ed.]   “Our contribution is the flexibility offered by the separation of compute and storage, which schools...

Properly Identifying Identifiers

Vertica Identifiers (names) of objects such as schemas, tables, projections, column names, and so on, can be up to 128 bytes in length. Unquoted SQL identifiers must begin with one of the following: Non-Unicode letters: A–Z or a-z Underscore (_) Subsequent characters in an identifier can be any combination of the following: Non-Unicode letters: A–Z...

Welcome to the New Vertica Blog!

If you're a regular visitor to the vertica.com website, you've probably noticed a few changes to our blog recently. The Vertica team is excited to launch our new and improved blog in order to help you, our audience, more easily navigate posts, explore specific areas of interest, and follow your favorite contributors. Same great content;...

Run the Same Query Over and Over Again in vsql

The \g vsql meta-function sends the query in the input buffer to the server. This is great for interactively testing if a previous query run time was a fluke, and you don’t feel like typing in a long SQL statement again. Example: Helpful Link: Have fun!