Search found 301 matches

by scutter
Thu Apr 13, 2017 12:41 pm
Forum: General
Topic: Vertica - All in!
Replies: 4
Views: 710

Re: Vertica - All in!

Nice! You would have been my first guess if you weren’t faking us out!
by scutter
Wed Apr 12, 2017 10:04 pm
Forum: General
Topic: Vertica - All in!
Replies: 4
Views: 710

Re: Vertica - All in!

That’s funny!! Maybe Stephen W?

—Sharon
by scutter
Fri Mar 31, 2017 3:08 am
Forum: Vertica Data Load
Topic: Parse Json from Vertica VARCHAR column
Replies: 3
Views: 975

Re: Parse Json from Vertica VARCHAR column

Hi PJ, You can parse json stored in a column without using a flex table. Here are two examples: First storing the json in a varbinary column as a vmap. This would be ideal if queries are executed repeatedly on the same json so that you only generate the vmap once. create table t(vmap long varbinary(...
by scutter
Wed Oct 12, 2016 1:56 pm
Forum: Vertica SQL
Topic: Running Count Distinct
Replies: 4
Views: 874

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

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

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

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

Go to advanced search