Search found 16 matches

by DataWhisperer
Thu Aug 16, 2012 2:17 pm
Forum: Vertica SQL
Topic: Monitoring the inserts and updates
Replies: 6
Views: 6030

Re: Monitoring the inserts and updates

Check out the system table query_requests.

Code: Select all

SELECT 
  *
 FROM query_requests
WHERE request_type = 'QUERY'
  AND request ilike 'update%';
by DataWhisperer
Thu Aug 16, 2012 2:05 pm
Forum: Perl
Topic: How to Execute vsql Commands in Perl
Replies: 1
Views: 6357

Re: How to Execute vsql Commands in Perl

Hi,

We have some PERL running in an ETL and using the COPY command. What issues are you having?
by DataWhisperer
Wed May 16, 2012 12:38 pm
Forum: SQuirreL SQL Client
Topic: SQuirrel and Vertica 5.1.x JDBC Issue!
Replies: 1
Views: 6093

Re: SQuirrel and Vertica 5.1.x JDBC Issue!

Running 5.1.5 JDBC driver w/ no issues.
by DataWhisperer
Sun May 13, 2012 8:39 pm
Forum: General
Topic: Linux Version
Replies: 4
Views: 1772

Re: Linux Version

Debian package with a lot of modifications. :-) There was a lot of bash and python file editing as well.
by DataWhisperer
Sat May 12, 2012 9:39 am
Forum: vSQL
Topic: Running commands from vSQL
Replies: 6
Views: 7778

Re: Running commands from vSQL

I haven't played much with extensions. I should spend some time checking them out. Very true, I should have mentioned that. Backticks are great for that if you need values from bash. Toss in some grep, awk and sed, you can do some scripting work to set variables. datawhisperer=> \set vertica_pid `ps...
by DataWhisperer
Sat May 12, 2012 8:59 am
Forum: SQuirreL SQL Client
Topic: Setting up SQuirreL
Replies: 8
Views: 14393

Re: Setting up SQuirreL

Has anyone else had issues w/ time and timezones using SQuirreL? We use it extensively, but have a few people in different timezones and of course SQuirreL localizes the time to them. Normally I don't care, but it's doing this to the TIME data-type, which is unacceptable. It's treating it like TIMET...
by DataWhisperer
Sat May 12, 2012 8:56 am
Forum: vSQL
Topic: Running commands from vSQL
Replies: 6
Views: 7778

Running commands from vSQL

Haven't seen much here, but it is possible to run bash commands from the vsql prompt. Why is this handy? Well updating your SVN repo to execute new code w/o having to leave vsql or open another prompt. Example 1: Get your working directory datawhisperer=> \! pwd /home/datawhisperer Example 2: SVN up...

Go to advanced search