Search found 1783 matches

by JimKnicely
Mon Jan 15, 2018 4:27 pm
Forum: Vertica in the AWS Cloud
Topic: Vertica Supported EC2 Instance Types
Replies: 2
Views: 56

Re: Vertica Supported EC2 Instance Types

Hi, Vertica provides several validation utilities that can be used prior to deploying Vertica to help determine if your hosts and network can properly handle the processing and network traffic required by Vertica. These utilities can also be used if you are encountering performance issues and need t...
by JimKnicely
Thu Jan 04, 2018 3:58 pm
Forum: Vertica Links
Topic: Authentication Methods for dbadmin
Replies: 0
Views: 107

Authentication Methods for dbadmin

Cool new Vertica blog post! In Vertica, when you create a new database, there are no configured authentication methods. In this case, Vertica assumes that all users, including the dbadmin, have an implicit password authentication. Users can use this authentication method both for authenticating over...
by JimKnicely
Thu Jan 04, 2018 3:57 pm
Forum: Vertica Links
Topic: DataGals Year in Review
Replies: 0
Views: 78

DataGals Year in Review

The DataGals had an amazing 2017! Everyone on our steering committee – Lisa Donaghue, Styliani Pantela, Soniya Shah, Diem Tran, and Sharada Vesta would like to wish you a very happy new year! Check out our year in review below. We look forward to a successful 2018. Happy holidays from the DataGals!...
by JimKnicely
Thu Jan 04, 2018 3:55 pm
Forum: Vertica Links
Topic: What’s New in Vertica 9.0.1?
Replies: 0
Views: 75

What’s New in Vertica 9.0.1?

What’s New in Vertica 9.0.1?

Find out here:

https://my.vertica.com/blog/whats-new-vertica-9-0-1/
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: 102

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

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

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

Go to advanced search