Search found 1722 matches

by JimKnicely
Wed May 24, 2017 4:49 pm
Forum: Vertica Links
Topic: Use MERGE to Update 1 Million Rows
Replies: 0
Views: 70

Use MERGE to Update 1 Million Rows

Superb post by Soniya!

To illustrate the true power of MERGE, this article describes how we used MERGE to demonstrate Vertica’s performance at scale.

Read more here: https://my.vertica.com/blog/use-merge-u ... lion-rows/
by JimKnicely
Wed May 24, 2017 4:48 pm
Forum: Vertica Links
Topic: Query Optimization Using Projections
Replies: 0
Views: 55

Query Optimization Using Projections

Another great blog post! In Vertica, tables are logical representations of the data. Vertica stores the actual data in projections. When data is loaded into a Vertica table, Vertica creates or updates a column-store projection. Vertica also compresses and/or encodes projection data, optimizing data ...
by JimKnicely
Wed May 24, 2017 4:44 pm
Forum: Vertica Links
Topic: Big Flat Fact Tables
Replies: 0
Views: 69

Big Flat Fact Tables

Don't optimize your schema for a row store!

Find out why in the very informative blog post written by Soniya...
https://my.vertica.com/blog/big-flat-fact-tables/
by JimKnicely
Wed May 24, 2017 4:40 pm
Forum: Vertica Links
Topic: Using Vertica and HyperLogLog
Replies: 0
Views: 59

Using Vertica and HyperLogLog

Interesting blog post written by Soniya ... This is a guest blog post co-authored by Francois Jehl and Pawel Szostek. Francois is the lead of the Analytics Data Storage team at Criteo; Pawel is a software engineer in the Analytics Data Storage team at Criteo. Criteo is the global leader in digital p...
by JimKnicely
Wed May 24, 2017 4:38 pm
Forum: Vertica Links
Topic: Data Preparation for Machine Learning in Vertica
Replies: 0
Views: 96

Data Preparation for Machine Learning in Vertica

Another awesome blog post by Vincent Xu ! Introduction Machine learning (ML) is an iterative process. From understanding data, preparing data, building models, testing models to deploying models, every step of the way requires careful examination and manipulation of the data. This is especially true...
by JimKnicely
Wed May 24, 2017 4:36 pm
Forum: Vertica Links
Topic: Using Hadoop Rack Locality to Boost Vertica Performance
Replies: 0
Views: 58

Using Hadoop Rack Locality to Boost Vertica Performance

Cool blog post authored by Monica Cellio . When database nodes are co-located on Hadoop data nodes, Vertica can take advantage of the Hadoop rack configuration to execute queries against ORC and Parquet data. Moving query execution closer to the data reduces network latency and can improve performan...
by JimKnicely
Wed May 24, 2017 4:34 pm
Forum: Vertica Links
Topic: What’s New in Vertica 8.1: Connecting to Vertica Updates
Replies: 0
Views: 52

What’s New in Vertica 8.1: Connecting to Vertica Updates

Great post about the "Functional Updates to \timing" in Vertica 8.1!

Read about them here: https://my.vertica.com/blog/whats-new-v ... a-updates/

Go to advanced search