Search found 36 matches

by doug_harmon
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...
by doug_harmon
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)
by doug_harmon
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';
by doug_harmon
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...
by doug_harmon
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;  
by doug_harmon
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.
by doug_harmon
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...

Go to advanced search