Hi, Thanks for your suggestion. It turns out that move_partitions_to_table() does trigger a moveout. This is quite normal as Vertica will try to empty the WOS to disk before moving the partition. That said, there is a bug in Vertica 7.1.0-1, which means that move_partitions_to_table() generates a mo...

Hi, In my ETL processes, I have a few lines like: select move_partitions_to_table ('stg.A', 0, 24, 'tmp_table.A') erroring out with ERROR: A Moveout operation is already in progress on projection stg.B_all_nodes_b0 [txnid 45035996338570033 session fqdn-25466:0xd053] In short, a moveout on table A fa...

Hi, The issue has been resolved and the repository is public again. Regarding the connection to vertica, pyvertica just uses the system odbc configuration, which can be overridden via the ODBCINI environment variable. You can then just pass a DSN to pyvertica. Pyvertica itself depends on pyodbc, whi...

Hello, We at Spilgames are using a lot of python with Vertica. Over time we developed a Python library which currently features a high speed loader and an extendable base class to write batch importers. Some helper scripts are shipped with as well for instance to easily import csv-like formatted fil...