Search found 1768 matches

by JimKnicely
Sun Oct 15, 2017 2:14 am
Forum: Vertica Database Administration
Topic: Need data like logonsource in Teradata
Replies: 1
Views: 25

Re: Need data like logonsource in Teradata

Check the V_MONITOR.SESSIONS and the V_MONOTR.USER_SESSIONS system tables: See: SESSIONS: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/SESSIONS.htm USER_SESSIONS: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Syste...
by JimKnicely
Thu Oct 05, 2017 2:53 pm
Forum: Vertica Links
Topic: Vertica Integration with Microsoft SQL Server Integration Services: Connection Guide
Replies: 0
Views: 128

Vertica Integration with Microsoft SQL Server Integration Services: Connection Guide

"Vertica Integration with Microsoft SQL Server Integration Services: Connection Guide" is an article that explains how to connect to Vertica with Microsoft SQL Server Integration Services (SSIS)!

Check it out here:
https://my.vertica.com/kb/SSIScg/Conten ... SSIScg.htm
by JimKnicely
Thu Oct 05, 2017 12:03 pm
Forum: Vertica Backup & Recovery
Topic: Full backup creates Snapshot
Replies: 1
Views: 66

Re: Full backup creates Snapshot

If you delete the backups on disk, then Vertica will create a new full backup the next time you run vbr.

See:
https://my.vertica.com/docs/7.1.x/HTML/ ... ackups.htm
by JimKnicely
Mon Oct 02, 2017 6:29 pm
Forum: General
Topic: change active partition (v8.1.1)
Replies: 1
Views: 94

Re: change active partition (v8.1.1)

Hii,

This is a current feature request that is coming soon! I'll update this thread when I find out which of the upcoming releases will have it!

Thanks!
by JimKnicely
Mon Oct 02, 2017 6:23 pm
Forum: Vertica Links
Topic: Integrating with Apache Spark
Replies: 0
Views: 33

Integrating with Apache Spark

The Vertica Connector for Apache Spark is a fast parallel connector that allows you to use Apache Spark for pre-processing data. Apache Spark is an open-source, general purpose, cluster-computing framework. The Spark framework is based on Resilient Distributed Datasets (RDDs), which are logical coll...
by JimKnicely
Mon Oct 02, 2017 6:22 pm
Forum: Vertica Links
Topic: Analytic Queries in Vertica
Replies: 0
Views: 29

Analytic Queries in Vertica

Great blog post "Analytic Queries in Vertica"! Analytic functions handle complex analysis and reporting tasks. Here are some example use cases for Vertica analytic functions: Rank the longest standing customers in a particular state Calculate the moving average of retail volume over a specific time ...
by JimKnicely
Mon Oct 02, 2017 6:17 pm
Forum: Vertica Links
Topic: Get Vertica Community Edition!
Replies: 0
Views: 53

Get Vertica Community Edition!

Join the MyVertica Community and Download the HPE Vertica Community Edition. Register today as a new member of the growing MyVertica Community and download the HPE Vertica Community Edition to: Experience Big Data analytics at the highest performance and extreme scale at no cost and no time limit Ga...

Go to advanced search