Search found 106 matches

by Josh
Wed Jan 28, 2015 1:58 pm
Forum: vSQL
Topic: Is there a GET command?
Replies: 4
Views: 18485

Is there a GET command?

Good morning,

Is there a command in vsql that acts like the GET command in Oracle SQL*Plus that will just loads a host operating system file into the SQL buffer?
by Josh
Tue Jan 27, 2015 2:30 pm
Forum: New to Vertica Database Administration
Topic: unable to connect via UNIX socket to /tmp/4803 (pid=31982)
Replies: 2
Views: 10606

unable to connect via UNIX socket to /tmp/4803 (pid=31982)

Hi, I am trying to bring up an older cluster that hasn't been up in a while. When It do, I get a error. Here is the output of the dbLog file: [dbadmin@vertica01 snowfall]$ cat dbLog /===========================================================================\ | The Spread Toolkit. | | Copyright (c) ...
by Josh
Thu Jan 15, 2015 10:59 pm
Forum: Vertica SQL
Topic: Weird result with FLOAT operations
Replies: 2
Views: 5765

Re: Weird result with FLOAT operations

This is occurring on version 6.1.3-9
by Josh
Thu Jan 15, 2015 10:41 pm
Forum: Vertica SQL
Topic: Weird result with FLOAT operations
Replies: 2
Views: 5765

Weird result with FLOAT operations

Hi, We are getting the below strange error while we do the subtraction. When we query to substract the same value, we are getting some floating value... vertica=> select sb.curr_inv_bal_1mo , sb.sch_principal_1mo, sb.curr_inv_bal_1mo - sb.sch_principal_1mo as MINUS_V from etl_2.sch_bal_principal_3mo...
by Josh
Wed Jan 07, 2015 12:51 pm
Forum: New to Vertica Database Administration
Topic: /opt/vertica/oss/python/bin/python: No such file or director
Replies: 0
Views: 7428

/opt/vertica/oss/python/bin/python: No such file or director

Hi guys, I am getting a weird error when in trying to install Vertica. Here is the output: [root@vertica01 temp]# /opt/vertica/sbin/install_vertica -s XXX.XXX.XXX.81,XXX.XXX.XXX.245,XXX.XXX.XXX.73 -r vertica-7.1.1-0.x86_64.RHEL5.rpm -T Vertica Analytic Database 7.1.1-0 Installation Tool >> Validatin...
by Josh
Sat Dec 06, 2014 1:06 pm
Forum: New to Vertica Database Administration
Topic: Where can I find DB comment???
Replies: 3
Views: 8336

Where can I find DB comment???

Hey,

When creating a DB in admintools we have the option to add a "comment" when naming the DB. Anyone know where (i.e. system table) in the DB the comment can be retrieved?

Thanks in advance!
by Josh
Thu Nov 20, 2014 3:12 pm
Forum: Vertica Data Load
Topic: Loading 7-zip compressed files
Replies: 3
Views: 18002

Re: Loading 7-zip compressed files

Thank you, Jim!

Go to advanced search