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?
Search found 106 matches
- Wed Jan 28, 2015 1:58 pm
- Forum: vSQL
- Topic: Is there a GET command?
- Replies: 4
- Views: 18485
- 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) ...
- 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
- 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...
- 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...
- 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!
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!
- 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!