Search found 1736 matches

by JimKnicely
Thu Jun 15, 2017 2:21 pm
Forum: Vertica Links
Topic: The Vertica Technical Team's new LinkedIn account!
Replies: 0
Views: 88

The Vertica Technical Team's new LinkedIn account!

The Vertica Technical Team is pleased to announce we have a new LinkedIn account! Please connect with us for the latest posts and updates from the Vertica Community, including the blog and knowledge base. Your feedback helps us create more content that can better serve your needs. If you have ideas ...
by JimKnicely
Thu Jun 15, 2017 2:19 pm
Forum: Vertica Links
Topic: Understanding Users, Privileges, and Roles
Replies: 0
Views: 65

Understanding Users, Privileges, and Roles

Another great Vertica Blog post "Understanding Users, Privileges, and Roles" by Soniya! Every Vertica database has one or more users. When users connect to the database, they log in with credentials that a superuser defines. Database users should only have access to the database resources they need ...
by JimKnicely
Thu Jun 15, 2017 2:16 pm
Forum: Vertica Links
Topic: In-Database Approximate Median and Percentile Functions
Replies: 0
Views: 65

In-Database Approximate Median and Percentile Functions

New Vertica blog post authored by Ginger Ni ! Median and percentile functions are commonly used data statistic functions. They are also used in other sophisticated data analysis algorithms, such as the robust z-Score normalization function. Vertica has exact MEDIAN and PERCENTILE_CONT functions, but...
by JimKnicely
Wed Jun 14, 2017 7:48 pm
Forum: Vertica Error Codes
Topic: Unable to create DB: Error : 127.0.0.1 Permission Denied
Replies: 3
Views: 123

Re: Unable to create DB: Error : 127.0.0.1 Permission Denied

Hi, Check the [nodes] section of your /opt/vertica/config/admintools.conf file. You should see an entry like this: [Nodes] node0001 = 127.0.0.1,/d2/vertica,/d2/vertica If you see this, then something went wrong with the install... [Nodes] node0001 = 127.0.0.1,/home/dbadmin,/home/dbadmin If you haven...
by JimKnicely
Sat Jun 10, 2017 2:07 am
Forum: Vertica Links
Topic: Vertica OEM Hardware Sizing Guide
Replies: 0
Views: 127

Vertica OEM Hardware Sizing Guide

Vertica is a massively parallel processing (MPP) database designed to run across a cluster of similar nodes. These nodes should be identical. However, in some cases that is not possible. For example, if you expand a cluster that was originally purchased more than two years prior,the nodes are proba...
by JimKnicely
Sat Jun 10, 2017 1:53 am
Forum: Vertica Links
Topic: Best Practices for Upgrading the Operating System on Nodes in a Vertica Cluster
Replies: 0
Views: 113

Best Practices for Upgrading the Operating System on Nodes in a Vertica Cluster

Great Knowledge Base post "Best Practices for Upgrading the Operating System on Nodes in a Vertica Cluster" every Vertica admin should read! At some point, you may need to upgrade the operating system or Linux kernel on the nodes in your Vertica cluster. This document explains the steps you should t...
by JimKnicely
Sat Jun 10, 2017 1:50 am
Forum: Vertica Error Codes
Topic: Unable to create DB: Error : 127.0.0.1 Permission Denied
Replies: 3
Views: 123

Re: Unable to create DB: Error : 127.0.0.1 Permission Denied

Hi, Most likely cause is a lack of the required file system permissions for the database data directory (i.e. ability to write to a directory). Does the /opt/vertica/log/adminTools.log show any errors? When you installed Vertica, did you specify a data directory? If not, by default it will try to cr...

Go to advanced search