Vertica's Blog

What’s New in Dragline (7.1.0): Resource Pool Routing

Resource Pool Routing from Vertica Systems on Vimeo.

HP Vertica 7.1.x introduces new features that allow you to dynamically reroute queries to secondary resource pools.

Use the new CASCADE TO parameter when creating or altering a resource pool to indicate a secondary resource pool to which queries can cascade and execute when they exceed the RUNTIMECAP of the pool on which they started running. This way, if a query exceeds its initial pool’s RUNTIMECAP, it can cascade to a designated secondary pool with a larger RUNTIMECAP instead of causing an error.

Because grant privileges are not considered on secondary pools, you can use this functionality to designate secondary resource pools where user queries can cascade to without giving users explicit permission to run queries on that pool.

Check out this video to learn more about dynamically rerouting queries.
For more information, see the documentation.

What’s New in Dragline (7.1.0): Active Standby Nodes

Active Standby Nodes Video

Active Standby Nodes from Vertica Systems on Vimeo.

HP Vertica 7.1.x introduces active standby nodes.

An active standby node is a type of HP Vertica node that does not perform computations or contain data, but exists as a backup, ready to replace a node that’s failed. When the active standby node replaces the failed node, the active standby node performs all the calculations of the failed node.

As an example, imagine your database cluster as a team of basketball stars, working together to play a game. Normally, things go pretty smoothly. But what if one of your players gets injured? In basketball, it is likely that another team member, Read More »

What’s New in Dragline (7.1.0): Projections with Expressions

Projections with Expressions Video

Projections with Expressions from Vertica Systems on Vimeo.

HP Vertica 7.1 introduces the ability to use expressions with projections.

When you create a projection, you now have the option to use an expression as a column definition. For example, you can declare a column that sums two variables. When you load data into a projection with expressions, HP Vertica automatically calculates the values according to the expressions and inserts the data into that new projection. Once you create a projection with expressions, you can query the projection directly to access your pre-calculated data and eliminate resource-intensive computations at query time.

Watch this video to learn more about Read More »

MySQL Ate My Homework: Five Reasons You Should Always Use a Subpar Data Platform

shutterstock_145410211 [Converted]



falling short of a standard <the service at the restaurant was subpar, to say the least>

Synonyms: bush, bush-league, crummy (also crumby), deficient, dissatisfactory, ill, inferior, lame, lousy,off, paltry, poor, punk, sour, suboptimal, subpar, substandard, unacceptable, unsatisfactory, wack [slang], wanting, wretched, wrong

Related Words: abysmal, atrocious, awful, [slang], brutal, damnable, deplorable, detestable, disastrous, dreadful,execrable, gnarly [slang], horrendous, horrible, pathetic,stinky, sucky [slang], terrible, unspeakable; defective, faulty,flawed; egregious, flagrant, gross; bum, cheesy, coarse,common, crappy [slang], cut-rate, junky, lesser, low-grade,low-rent, mediocre, miserable, reprehensible, rotten,rubbishy, second-rate, shoddy, sleazy, trashy; abominable,odious, vile; useless, valueless, worthless; inadequate,insufficient, lacking, meager (or meagre), mean, miserly, , scanty, shabby, short, skimp, skimpy, spare,stingy; miscreant, scurrilous, villainous; counterfeit, fake,phony Read More »

Backing Up and Restoring Your HP Vertica Database

Backing up and restoring your database is an important part of basic database maintenance. HP Vertica lets you create both comprehensive and object-level backups. This article highlights the HP Vertica 7.x features that enhance the backup and restore process.

Previously, you could not add nodes to your cluster between object-level backup creation and restoration. With HP Vertica 7.x, you can add nodes to the cluster after creating an object-level backup and then successfully restore the objects.

Another feature simplifies the mapping section of your configuration file. When creating a backup, you create a configuration file that includes mapping sections that specify all database nodes included in the backup, along with the backup host and directory for each node. Previously, Read More »

DbVisualizer Free for HP Vertica

DB Visualizer for HP Vertica

As a special service to Vertica users and the Big Data community, we have released a new version of DbVisualizer, DbVisualizer Free for Vertica, which is now available for free on the HP Vertica Marketplace. This is an optimized version of DB Visualizer that is unique to Vertica, as it is customized specifically for unique Vertica functions, like viewing projections, and some features usually reserved for the pro version such as multiple execution options. Now available for download here.

Get Started With Vertica Today

Subscribe to Vertica