Search found 1702 matches

by JimKnicely
Tue Apr 25, 2017 8:27 pm
Forum: New to Vertica SQL
Topic: What resource pool did query use?
Replies: 1
Views: 5

Re: What resource pool did query use?

Hi Julie, Try joining the dc_requests_issued and dc_resource_acquisitions data collector tables... Something like this: select a.node_name, a.time, a.request, b.pool_name from dc_requests_issued a join dc_resource_acquisitions b on b.transaction_id = a.transaction_id and b.statement_id = a.statement...
by JimKnicely
Tue Apr 25, 2017 4:45 pm
Forum: Vertica Links
Topic: Analytics Meets Machine Learning: Next Steps to Data-Driven Decisions
Replies: 0
Views: 50

Analytics Meets Machine Learning: Next Steps to Data-Driven Decisions

Analytics Meets Machine Learning: Next Steps to Data-Driven Decisions What: We’re hosting this webcast to promote our in-database machine learning capabilities. During this webcast, attendees will learn about the emergence (or reemergence) of machine learning and "A.I.," and how data-management pra...
by JimKnicely
Sat Apr 22, 2017 12:26 pm
Forum: Vertica Database Administration
Topic: Backups
Replies: 1
Views: 15

Re: Backups

Hi,

Looks like you don't have the rights to create a new file in the directory you're currently in when you ran vbt.py.

Try changing the owner/group or rights on that directory, or simply switching to a directory where you have write access, and then run ./vbr.py --setupconfig again.

Thanks!
by JimKnicely
Sat Apr 22, 2017 12:06 pm
Forum: Vertica Links
Topic: Vertica Integration with DBSolo: Connection Guide
Replies: 0
Views: 44

Vertica Integration with DBSolo: Connection Guide

Using DBSolo ? Find out how to integrate it with Vertica in this awesome post at the Vertica Knowledge Base . This document explains how to connect DB Solo, a feature-rich SQL query tool, with Vertica Analytic Database. Read it here: https://my.vertica.com/kb/DBSolo-Connection-Guide/Content/Partner/...
by JimKnicely
Sat Apr 22, 2017 12:03 pm
Forum: Vertica Links
Topic: Understanding the Vertica Replay Delete Algorithms
Replies: 0
Views: 77

Understanding the Vertica Replay Delete Algorithms

Very informative post about the "Vertica Replay Delete Algorithms"... What is Replay Delete? Because storage containers are reorganized as part of the Tuple Mover, recovery, refresh, and rebalance operations, the position of deleted records may change in the newly created storage container. In Verti...
by JimKnicely
Sat Apr 22, 2017 12:01 pm
Forum: Vertica Links
Topic: Vertica QuickStart for Tableau
Replies: 0
Views: 67

Vertica QuickStart for Tableau

Check out the Vertica Knowledge Base article "Vertica QuickStart for Tableau"... This document explains how to deploy and use the Vertica QuickStart for Tableau. The document includes the setup information that you need to get up and running, and it provides an overview of the Tableau dashboards and...
by JimKnicely
Tue Apr 18, 2017 2:08 pm
Forum: Vertica Links
Topic: Vertica Security Vulnerability Hotfixes
Replies: 0
Views: 75

Vertica Security Vulnerability Hotfixes

SECURITY VULNERABILITY HOTFIXES A critical security vulnerability has been found in Vertica. An unauthenticated entity with the ability to establish a connection to the client socket, can reset the password of a known user. Vertica has fixed this vulnerability in hotfixes, and strongly recommends u...

Go to advanced search