Search found 1800 matches

by JimKnicely
Tue Jan 02, 2018 3:14 pm
Forum: New to Vertica Database Administration
Topic: How to recover data which is dropped by mistake
Replies: 1
Views: 496

Re: How to recover data which is dropped by mistake

Hi, Dropping a partition is permanent action and there is no way to roll it back. Do you have a recent backup? You can restore the table from it. See: https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BackupRestore/RestoringIndividualObjectsfromaFullorPartialBackup.htm I...
by JimKnicely
Thu Dec 07, 2017 3:17 pm
Forum: Vertica Links
Topic: Phrase Search with Vertica Text Search
Replies: 0
Views: 317

Phrase Search with Vertica Text Search

Vertica already provides Text Search. Text Search allows you to quickly search the contents of a single CHAR, VARCHAR, LONG VARCHAR, VARBINARY, or LONG VARBINARY field within a table to locate a specific token. Vertica implements that capability using a dedicated Text Index to store all the individ...
by JimKnicely
Thu Dec 07, 2017 3:13 pm
Forum: Vertica Links
Topic: Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time
Replies: 0
Views: 263

Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time

Awesome 3 Part Blog post by Soniya : Project Overview This post presents an overview of an ongoing series that focuses on using Vertica, Raspberry Pi, and Apache Kafka to track commercial aircraft in near-real time. Part 1: https://my.vertica.com/blog/blog-post-series-using-vertica-track-commercial-...
by JimKnicely
Thu Dec 07, 2017 3:06 pm
Forum: Vertica Links
Topic: Flattened Tables - Vertica Blog Post
Replies: 0
Views: 262

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: 4436

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: 264

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: 366

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

Go to advanced search