Code: Select all
SELECT
*
FROM query_requests
WHERE request_type = 'QUERY'
AND request ilike 'update%';
Search found 16 matches
- Thu Aug 16, 2012 2:17 pm
- Forum: Vertica SQL
- Topic: Monitoring the inserts and updates
- Replies: 6
- Views: 15898
Re: Monitoring the inserts and updates
Check out the system table query_requests.
- Thu Aug 16, 2012 2:05 pm
- Forum: Perl
- Topic: How to Execute vsql Commands in Perl
- Replies: 1
- Views: 15186
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?
We have some PERL running in an ETL and using the COPY command. What issues are you having?
- Wed May 16, 2012 12:38 pm
- Forum: SQuirreL SQL Client
- Topic: SQuirrel and Vertica 5.1.x JDBC Issue!
- Replies: 1
- Views: 15859
Re: SQuirrel and Vertica 5.1.x JDBC Issue!
Running 5.1.5 JDBC driver w/ no issues.
- Sun May 13, 2012 8:39 pm
- Forum: General
- Topic: Linux Version
- Replies: 4
- Views: 8226
Re: Linux Version
Debian package with a lot of modifications. 
There was a lot of bash and python file editing as well.
There was a lot of bash and python file editing as well.- Sat May 12, 2012 9:39 am
- Forum: vSQL
- Topic: Running commands from vSQL
- Replies: 6
- Views: 17659
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...
- Sat May 12, 2012 8:59 am
- Forum: SQuirreL SQL Client
- Topic: Setting up SQuirreL
- Replies: 8
- Views: 37929
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...
- Sat May 12, 2012 8:56 am
- Forum: vSQL
- Topic: Running commands from vSQL
- Replies: 6
- Views: 17659
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...