Search found 77 matches

by sarah
Thu Jul 30, 2015 7:29 pm
Forum: New to Vertica Database Development
Topic: Change the default delimiter of FDelimitedParser()
Replies: 4
Views: 61864

Change the default delimiter of FDelimitedParser()

Hoday!

Is it possible to change the default pipe symbol delimiter of the FDelimitedParser() parser for flex tables?

Thanks!
by sarah
Fri Mar 06, 2015 8:29 pm
Forum: New to Vertica
Topic: How secure is drop database from admintools?
Replies: 0
Views: 4920

How secure is drop database from admintools?

Howdy, When I drop a database from admintools, I see the message "Dropping database irrevocably destroys ALL data. Type 'yes' to confirm." I type yes, hit enter and the database is dropped. I checked the file system and the database directory along with all the files are gone. But how secure is this...
by sarah
Thu May 01, 2014 1:40 am
Forum: Vertica Installation
Topic: Install of Vertica 7 fails (install_vertica script)
Replies: 2
Views: 16472

Re: Install of Vertica 7 fails (install_vertica script)

Oh my! Skwa, it was a dash instead of a hyphen in front of the r! I cut and pasted the command from a Word document someone else created. Maybe Word replaced the hyphen with a dash per spellcheck? Anyway, much thanks!
by sarah
Wed Apr 30, 2014 9:50 pm
Forum: Vertica Installation
Topic: Install of Vertica 7 fails (install_vertica script)
Replies: 2
Views: 16472

Install of Vertica 7 fails (install_vertica script)

Hi, I am trying to perform a simple install of Vertica 7 on a single node cluster. I can install the rpm fine, but the install script is failing with an error on the -r option? I don't know why :( [root@vertica-demo2 temp]# ls vertica-6.1.3-0.x86_64.RHEL5.rpm vertica-7.0.1-0.x86_64.RHEL5.rpm [root@v...
by sarah
Tue Apr 22, 2014 4:32 pm
Forum: Vertica Database Administration
Topic: Who created a schema?
Replies: 3
Views: 6948

Re: Who created a schema?

Ok, sorry. I was thinking if the schema owner was changed, how would I know who created it. But we can't change a schema owner, so I guess this is a none issue :oops: dbadmin=> create user sarah; CREATE USER dbadmin=> create schema sarah; CREATE SCHEMA dbadmin=> select schema_owner from schemata whe...
by sarah
Tue Apr 22, 2014 3:35 pm
Forum: Vertica Database Administration
Topic: Who created a schema?
Replies: 3
Views: 6948

Who created a schema?

Hi,

Per viewtopic.php?f=3&t=1831 I now know when a schema was created, but how do I know who create it?
by sarah
Tue Apr 22, 2014 1:57 pm
Forum: Vertica Database Administration
Topic: When was schema created?
Replies: 2
Views: 5881

Re: When was schema created?

Thank you, scutter!

Go to advanced search