Search found 298 matches

by scutter
Wed Oct 12, 2016 1:56 pm
Forum: Vertica SQL
Topic: Running Count Distinct
Replies: 4
Views: 553

Re: Running Count Distinct

I just submitted this exact request a few weeks ago through Product Management. The more customers who request it, the more likely it is to be implemented. Open a ticket asking for it.

—Sharon
by scutter
Wed Sep 21, 2016 1:08 pm
Forum: Vertica SQL Functions
Topic: Clear audit data?
Replies: 2
Views: 910

Re: Clear audit data?

I would hope that there’s no way to clear it. Otherwise HP would have no way to know if you’ve been within your license limit.

I see from the LICENSE_AUDITS view definition that it’s basedon vs_license_audits rather than a dc table which could be flushed.

—Sharon
by scutter
Mon Sep 19, 2016 2:18 am
Forum: Vertica SQL
Topic: Overlapping time intervals
Replies: 2
Views: 760

Re: Overlapping time intervals

Something like this? create table activity(userid integer, login_ts timestamp); insert into activity values(1, '1/12/2016 03:24:12'); insert into activity values(1, '2/5/2016 12:43:40'); insert into activity values(1, '1/13/2016 09:00'); insert into activity values(1, '1/23/2016 09:00'); insert into...
by scutter
Mon Jul 25, 2016 12:30 pm
Forum: General
Topic: Vertica Query returns zero records and when re-run returns some records
Replies: 2
Views: 1261

Re: Vertica Query returns zero records and when re-run returns some records

> Rows that are being returned are most likely not yet purged. Rows that have been deleted won’t be returned in the result set. SELECT statements default to being executed on the latest epoch, which won’t include the deleted records. Whether or not deleted records have been purged is irrelevant, sin...
by scutter
Sun Jun 19, 2016 9:11 pm
Forum: Vertica SQL
Topic: projection_usage table not all tables got query_start_timestamp
Replies: 2
Views: 1803

Re: projection_usage table not all tables got query_start_timestamp

Systems tables are really views on top of Data Collector tables. So the time span for the data in the system table is dependent upon the retention of the data in the DC tables. You can see the current effective retention for each table on each node in the DATA_COLLECTOR table. You can increase the r...
by scutter
Mon Jun 13, 2016 11:07 pm
Forum: Vertica SQL
Topic: Named value pair data in VARCHAR
Replies: 1
Views: 615

Re: Named value pair data in VARCHAR

Already answered in the HP Vertica Community.

Go to advanced search