Search found 1804 matches

by JimKnicely
Thu Dec 07, 2017 3:06 pm
Forum: Vertica Links
Topic: Flattened Tables - Vertica Blog Post
Replies: 0
Views: 352

Flattened Tables - Vertica Blog Post

Before release 8.1., Vertica users could denormalize their data by combining all fact and dimension table columns in a single ‘fat’ table. These tables facilitated faster query execution. However, this approach required users to maintain redundant sets of normalized and denormalized data, which inc...
by JimKnicely
Fri Nov 17, 2017 5:18 pm
Forum: New to Vertica Database Development
Topic: Increase wait time out period for locked tables
Replies: 4
Views: 4752

Re: Increase wait time out period for locked tables

You can change the Lock Timeout at the SESSION, NODE and DATABASE levels. Examples: dbadmin=> select parameter_name, current_value, default_value from configuration_parameters where parameter_name = 'LockTimeout'; parameter_name | current_value | default_value ----------------+---------------+------...
by JimKnicely
Thu Nov 16, 2017 3:36 pm
Forum: Vertica Links
Topic: What’s New in Vertica 9.0: Sentry Integration
Replies: 0
Views: 338

What’s New in Vertica 9.0: Sentry Integration

Great blog post authored by Mitchell Tracy and Monica Cellio! Hadoop clusters can use authorization services to determine which users can access what data in Hive and, by extension, HDFS. In Vertica 9.0 we now support one of the most common such services, Apache Sentry. Read more here: https://my.ve...
by JimKnicely
Thu Nov 16, 2017 3:33 pm
Forum: Vertica Links
Topic: Data Pipelines: Vertica and Kafka
Replies: 1
Views: 444

Data Pipelines: Vertica and Kafka

New Blog post authored by Tom Wall and Soniya Shah! At Vertica, we want to make it as easy as possible for your Vertica environment to coexist with other tools and technologies. We know that one size does not fit all. Sometimes you need a customized, end-to-end view of your system. Read more: https:...
by JimKnicely
Thu Nov 02, 2017 2:16 pm
Forum: Vertica Links
Topic: Vertica 9.0 and the Google Cloud Platform
Replies: 0
Views: 325

Vertica 9.0 and the Google Cloud Platform

Awesome blog post authored by Lisa Donaghue... In Vertica 9.0, Management Console (MC) provides tools to provision and manage clusters and databases on an AWS environment. You can get started easily with a guided Cluster Creation wizard on AWS. The new Fast Tasks page introduces new users to a few f...
by JimKnicely
Thu Nov 02, 2017 2:13 pm
Forum: Vertica Links
Topic: What’s New in Management Console 9.0?
Replies: 0
Views: 324

What’s New in Management Console 9.0?

What’s New in Management Console 9.0?

Find out here:
https://my.vertica.com/blog/whats-new-m ... nsole-9-0/
by JimKnicely
Thu Nov 02, 2017 2:11 pm
Forum: Vertica Links
Topic: Vertica 9.0 Cheat Sheet
Replies: 0
Views: 348

Vertica 9.0 Cheat Sheet

Vertica 9.0! Get the updated Vertica machine learning cheat sheet here:

https://my.vertica.com/blog/machine-lea ... eat-sheet/

Go to advanced search