Search found 302 matches

by scutter
Thu Aug 02, 2018 7:14 pm
Forum: Vertica Security
Topic: Objects invisible to users when NOT created by dbadmin
Replies: 2
Views: 105

Re: Objects invisible to users when NOT created by dbadmin

Jim - I've seen this too. It's an issue for non-dbadmin users - to reproduce it you'd have to use a different account and create the view as a non-dbadmin user. You can workaround it by changing the owner of the view to be dbadmin but that's not always ideal. I haven't chased the issue any further t...
by scutter
Thu Apr 13, 2017 12:41 pm
Forum: General
Topic: Vertica - All in!
Replies: 4
Views: 1587

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

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

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

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

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

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

Go to advanced search