Search found 1755 matches

by JimKnicely
Thu Aug 10, 2017 2:41 pm
Forum: Vertica Links
Topic: AIM lists top 7 reasons HPE Vertica 8 is a good fit for every organization
Replies: 0
Views: 78

AIM lists top 7 reasons HPE Vertica 8 is a good fit for every organization

Analytics India Magazine, recently listed the top 7 reasons that make HPE Vertica 8 a good fit for every organization. Delving into why HPE Vertica 8 is the best fit for businesses to create an analytics-driven enterprise, we couldn't agree more!

Read about it here:
https://t.co/ATNojWVbvQ
by JimKnicely
Thu Aug 10, 2017 2:32 pm
Forum: Vertica Links
Topic: What’s New in Vertica 8.1.1: Backup to Amazon S3 - Blog Post
Replies: 0
Views: 52

What’s New in Vertica 8.1.1: Backup to Amazon S3 - Blog Post

Posted on Thursday, August 3rd, 2017 at 1:32 pm. Written by James As more businesses move their infrastructure from on-premises solutions to cloud-based and hybrid environments, Vertica has kept pace. In version 8.1.1, Vertica introduced support for backup and restore to and from Amazon’s Simple Sta...
by JimKnicely
Thu Aug 10, 2017 2:30 pm
Forum: Vertica Links
Topic: Geospatial Analysis on Shapefile of Longitude and Latitude Data Using Vertica: Hurricane Bonnie - Blog Post
Replies: 0
Views: 70

Geospatial Analysis on Shapefile of Longitude and Latitude Data Using Vertica: Hurricane Bonnie - Blog Post

Posted on Monday, August 7th, 2017 at 1:51 pm. This blog post was authored by Ginger Ni . Like any natural disaster, hurricanes can leave behind extensive damage to life and property. The question asked by NGOs, government agencies, and insurance companies is, “How can we predict the locations where...
by JimKnicely
Thu Aug 10, 2017 2:28 pm
Forum: Vertica Links
Topic: View Privileges - Blog Post
Replies: 0
Views: 46

View Privileges - Blog Post

Posted on Tuesday, August 8th, 2017 at 12:38 pm. Written by Soniya This set of examples shows the privileges a user needs for various operations related to views, including creating and querying. A view is a virtual table based on the result set of a SQL statement, also called a SQL query. To select...
by JimKnicely
Wed Aug 09, 2017 1:29 pm
Forum: Vertica Database Administration
Topic: Remove a node that's never coming back
Replies: 6
Views: 176

Re: Remove a node that's never coming back

@sKwa: Yeah, no worries! I missed the part where jaspot said he was running Vertica 6 :oops: I wasn't questioning you or the docs for 6.1 but just wanted to point out that you can't remove a non-existent node in Vertica 8 the same way you may have in Vertica 6.1. Although, I think you should be able...
by JimKnicely
Tue Aug 08, 2017 10:44 pm
Forum: Vertica Database Administration
Topic: Remove a node that's never coming back
Replies: 6
Views: 176

Re: Remove a node that's never coming back

Not sure the 6.1 docs apply to later releases of Vertica (i.e. 8.1.x). From my understanding of the issue, there is no host (physical) to remove. So how do you run the "/opt/vertica/sbin/update_vertica -R host" command when the host no longer exists? ;) For that matter, first you'll need to remove t...
by JimKnicely
Tue Aug 08, 2017 6:35 pm
Forum: Vertica SQL
Topic: Managing Disk space by deleting the older records when the disk is 60% full
Replies: 8
Views: 199

Re: Managing Disk space by deleting the older records when the disk is 60% full

How many database tables do you need to delete data from?

Go to advanced search