Search found 1707 matches

by JimKnicely
Sat Apr 29, 2017 3:37 am
Forum: Vertica Links
Topic: Monitoring Vertica
Replies: 0
Views: 58

Monitoring Vertica

Great new "Knowledge Base" post "Monitoring Vertica"... The purpose of this document is to help you monitor your Vertica database. The document is categorized into sections of query execution. You can use the queries in this document to investigate and troubleshoot database issues by monitoring the ...
by JimKnicely
Sat Apr 29, 2017 3:13 am
Forum: General
Topic: Disk Manager for Vertica Cluster
Replies: 1
Views: 35

Re: Disk Manager for Vertica Cluster

Hi, Vertica 8.1 has support for LVM: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SupportedPlatforms/VerticaSupportforLVM.htm Fyi... The Vertica installer has the option "--skip-fs-checks" that let's you bypass the file system check. But, in prod databases I'd stick with what is suppor...
by JimKnicely
Sat Apr 29, 2017 3:09 am
Forum: Vertica Analytics
Topic: Time Series and gap filling after last record update
Replies: 1
Views: 37

Re: Time Series and gap filling after last record update

Hi, Is this what you want? SELECT item_id, description, price, date FROM ( SELECT item_id, TS_LAST_VALUE(description) as description, TS_LAST_VALUE(price) as price, TS_LAST_VALUE(active) as active, slice_time as date FROM inv_test TIMESERIES slice_time AS '1 days' OVER (PARTITION BY item_id ORDER BY...
by JimKnicely
Wed Apr 26, 2017 2:34 pm
Forum: New to Vertica Database Administration
Topic: Change owner of schema?
Replies: 8
Views: 3998

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

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

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

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

Go to advanced search