Search found 1704 matches

by JimKnicely
Wed Apr 26, 2017 2:34 pm
Forum: New to Vertica Database Administration
Topic: Change owner of schema?
Replies: 8
Views: 3982

Re: Change owner of schema?

Hi, Having the ability to change the owner of a schema after the schema has been created is on the road map! In the mean time, the work around is as follows: Rename the current schema to a different name Recreate the intended schema with the desired owner Move the tables to the intended schema with:...
by JimKnicely
Wed Apr 26, 2017 1:31 pm
Forum: Vertica Links
Topic: What’s New in Vertica 8.1: Supported Platforms
Replies: 0
Views: 33

What’s New in Vertica 8.1: Supported Platforms

Vertica Release 8.1 continues to enhance and broaden our platform support!

Check out the new Operating Systems supported for the Vertica Server here:
https://my.vertica.com/blog/whats-new-v ... platforms/
by JimKnicely
Tue Apr 25, 2017 8:27 pm
Forum: New to Vertica SQL
Topic: What resource pool did query use?
Replies: 1
Views: 24

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

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

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

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

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

Go to advanced search