Search found 7 matches
- Wed Apr 30, 2014 10:18 am
- Forum: General
- Topic: 55V03 - zombie moveout process causing table insert to fail
- Replies: 2
- Views: 7807
55V03 - zombie moveout process causing table insert to fail
Can someone suggest potential solutions to this problem? It seems as if the moveout process on the table doesn't complete, but becomes a zombie process, causing any INSERT/UPDATEs on the table to fail. The error message is below: ('55V03', '[55V03] ERROR: Unavailable: initiator locks for query - Loc...
- Tue Mar 19, 2013 9:25 pm
- Forum: Vertica SQL
- Topic: List of tables in current schema
- Replies: 3
- Views: 10342
List of tables in current schema
Hi, how can I check the list of tables in the current schema? The following query select table_name from v_catalog.tables where table_schema=(select current_schema()) produces the following error: ERROR: Meta-function("current_schema") can be used only in the Select clause; Error while executing the...
- Fri Feb 22, 2013 12:06 pm
- Forum: Python
- Topic: Connecting to Vertica using SQLAlchemy
- Replies: 3
- Views: 27596
Connecting to Vertica using SQLAlchemy
Hi, has anyone ever used an ORM framework such as SQLAlchemy to connect to Vertica ? I tried searching about it on the web but there is scant information. Please let me know if anything is available on this front.
- Thu Sep 27, 2012 3:26 pm
- Forum: Vertica SQL
- Topic: using SELECT clause in Functions
- Replies: 9
- Views: 20860
Re: using SELECT clause in Functions
I have a similar question. Does vertica support using a SELECT clause within a user-defined function?
- Fri Sep 07, 2012 7:46 pm
- Forum: ODBC
- Topic: ODBC connection problems to Vertica
- Replies: 1
- Views: 16910
ODBC connection problems to Vertica
I'm trying to connect to our production database server using Vertica and I am getting this error: [08000][unixODBC][Vertica][VerticaDSII] (160) Connection attempt failed: FATAL: unsupported frontend protocol 3.2: server supports 3.0 to 3.1 [ISQL]ERROR: Could not SQLConnect Our prod database is vers...
- Thu Jun 14, 2012 8:20 pm
- Forum: Vertica SQL
- Topic: ROLLUP function in Vertica?
- Replies: 6
- Views: 14428
Re: ROLLUP function in Vertica?
I'll take a look at the extension, thanks.
- Thu Jun 14, 2012 5:02 pm
- Forum: Vertica SQL
- Topic: ROLLUP function in Vertica?
- Replies: 6
- Views: 14428
ROLLUP function in Vertica?
Hi, is there any equialent of Oracle's analytic ROLLUP function in Vertica? I need to obtain that functionality for some work I am doing in Vertica. http://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_sql.htm#autoId1 The ROLLUP function enables a SELECT statement to calculate multiple levels...