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)
Search found 221 matches
- Tue May 09, 2017 1:59 pm
- Forum: Vertica SQL
- Topic: Empty string handling...
- Replies: 1
- Views: 14092
- Tue Apr 25, 2017 7:19 pm
- Forum: New to Vertica SQL
- Topic: What resource pool did query use?
- Replies: 1
- Views: 13705
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!!!
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!!!
- Tue Oct 18, 2016 3:03 pm
- Forum: Vertica Database Administration
- Topic: Encrypt Data @ Rest?
- Replies: 1
- Views: 17162
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!
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!
- Tue Sep 20, 2016 9:01 pm
- Forum: Vertica SQL Functions
- Topic: Clear audit data?
- Replies: 2
- Views: 16922
Clear audit data?
Anyone know if there is a function to clear the LICENSE_AUDITS system table?
- Wed Sep 14, 2016 11:37 pm
- Forum: General
- Topic: WTF? Vertica is no longer part of HP?
- Replies: 16
- Views: 31982
Re: WTF? Vertica is no longer part of HP?
That is a valid question. Seriously, what is the future of Vertica?
- Thu Sep 08, 2016 12:56 pm
- Forum: General
- Topic: WTF? Vertica is no longer part of HP?
- Replies: 16
- Views: 31982
Re: WTF? Vertica is no longer part of HP?
No, I was thinking that, but I really doubt that would be possible.
- Thu Sep 08, 2016 12:50 pm
- Forum: General
- Topic: WTF? Vertica is no longer part of HP?
- Replies: 16
- Views: 31982
Re: WTF? Vertica is no longer part of HP?
At least the new sales team will have sexy accents