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...

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...

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.

I have a similar question. Does vertica support using a SELECT clause within a user-defined function?

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...

I'll take a look at the extension, thanks.

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...