Search found 1806 matches

by JimKnicely
Fri Jan 26, 2018 2:19 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: The LIMIT Analytic Function
Replies: 0
Views: 268

Vertica Quick Tip: The LIMIT Analytic Function

Vertica Community Blog post authored by Jim Knicely Vertica contains an abundance of built-in SQL analytic functions. One of the lesser known but also one of the coolest is the LIMIT analytic function. Read more here: https://forum.vertica.com/discussion/239345/vertica-quick-tip-the-limit-analytic-...
by JimKnicely
Fri Jan 26, 2018 2:17 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: How to Query for NaN Values
Replies: 0
Views: 279

Vertica Quick Tip: How to Query for NaN Values

Vertica Community Blog post authored by Jim Knicely We’re introducing a new series: Vertica Quick Tips! These tips are intended to give you concise information to help you get the most out of using Vertica. NaN (Not a Number) does not equal anything, not even another NaN. You can query for them usi...
by JimKnicely
Mon Jan 15, 2018 4:27 pm
Forum: Vertica in the AWS Cloud
Topic: Vertica Supported EC2 Instance Types
Replies: 2
Views: 608

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

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

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

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

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

Go to advanced search