Search found 221 matches

by Julie
Tue May 09, 2017 1:59 pm
Forum: Vertica SQL
Topic: Empty string handling...
Replies: 1
Views: 13764

Empty string handling...

Hi all,

Anyone know how to replace an empty string (i.e. '') with another string?

This works:

dbadmin=> select replace('TEST', 'TEST', 'FOUND');
replace
---------
FOUND
(1 row)

But this does not:

dbadmin=> select replace('', '', 'FOUND');
replace
---------

(1 row)
by Julie
Tue Apr 25, 2017 7:19 pm
Forum: New to Vertica SQL
Topic: What resource pool did query use?
Replies: 1
Views: 13398

What resource pool did query use?

Hi all,

Anyone know how I can figure out which resource pool was used for a particular query? I checked the query_profiles table and didn't see anything that indicated which pool was used.

Thank you!!!
by Julie
Tue Oct 18, 2016 3:03 pm
Forum: Vertica Database Administration
Topic: Encrypt Data @ Rest?
Replies: 1
Views: 16881

Encrypt Data @ Rest?

Howdy y'all,

So I was wondering what the community is using to encrypt their data on disk. I've read about several solutions (i.e. we looked at Voltage a while back) but was wondering if there is an option that would be best suited for Vertica?

Thanks guys!
by Julie
Tue Sep 20, 2016 9:01 pm
Forum: Vertica SQL Functions
Topic: Clear audit data?
Replies: 2
Views: 16584

Clear audit data?

Anyone know if there is a function to clear the LICENSE_AUDITS system table?
by Julie
Wed Sep 14, 2016 11:37 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 31613

Re: WTF? Vertica is no longer part of HP?

That is a valid question. Seriously, what is the future of Vertica?
by Julie
Thu Sep 08, 2016 12:56 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 31613

Re: WTF? Vertica is no longer part of HP?

No, I was thinking that, but I really doubt that would be possible.
by Julie
Thu Sep 08, 2016 12:50 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 31613

Re: WTF? Vertica is no longer part of HP?

At least the new sales team will have sexy accents :)

Go to advanced search