Search found 36 matches
- Thu Apr 25, 2013 6:52 pm
- Forum: Python
- Topic: Converting Stored Procedures to Python: Issues
- Replies: 1
- Views: 15841
Re: Converting Stored Procedures to Python: Issues
Hopefully this doesn't apply in your case, but I've seen very slow performance when loading records into Vertica via pyodbc due to the Python program being designed to do a commit after every record. A much better design is to commit records in batches. Also, have you looked at Pyvertica from Spilga...
- Thu Jan 31, 2013 8:48 pm
- Forum: vSQL
- Topic: Substitution Variables...
- Replies: 2
- Views: 7334
Re: Substitution Variables...
Code: Select all
dbadmin=> \set myname '''' debbie ''''
dbadmin=> select 'My name is ' || :myname ;
?column?
-------------------
My name is debbie
(1 row)
- Tue Jan 29, 2013 11:25 pm
- Forum: Vertica Data Load
- Topic: How to COPY data into tables with default values?
- Replies: 2
- Views: 8090
Re: How to COPY data into tables with default values?
Does this work?:
Code: Select all
copy test_load ( a, b ) from '/usr/home/debfawn/test_load.txt' EXCEPTIONS '/usr/home/debfawn/test_load.log';
- Fri Jan 25, 2013 5:22 am
- Forum: Vertica Error Codes
- Topic: SIGNAL_NUMBER
- Replies: 2
- Views: 16194
Re: SIGNAL_NUMBER
I'm guessing that v_monitor.process_signals contains linux process signals. You can find more documentation on those here: http://www.kernel.org/doc/man-pages/online/pages/man7/signal.7.html According to the linux documentation, a signal of 10 corresponds to "User Defined." I'm sorry, that's not ver...
- Wed Dec 19, 2012 9:39 pm
- Forum: Vertica SQL
- Topic: Random Number (Between Negative and Positive)
- Replies: 4
- Views: 10837
Re: Random Number (Bewteen Negative and Positive)
You'll need to check the boundaries, but something like this should do it:
Code: Select all
SELECT RANDOMINT(200)-100;
- Wed Dec 05, 2012 3:32 am
- Forum: Vertica SQL
- Topic: SQL control structure LOOP
- Replies: 1
- Views: 7289
Re: SQL control structure LOOP
I don't think Vertica supports FOR loops natively. I use either python programs or bash scripts to handle FOR loop control queries.
- Wed Dec 05, 2012 2:18 am
- Forum: Announcements, Events and Activities
- Topic: Vertica 6.1 has been released!
- Replies: 5
- Views: 11847
Vertica 6.1 has been released!
From the 6.1 release notes: New Features Guide. Feature highlights in this release are: Analytics Features • Enhanced Support for User Defined Functions in R • New and Improved SQL functions: WITH clause, EXCEPT, INTERSECT, and MINUS Data Management Features • Hadoop Distributed File System (HDFS) C...