Liquibase Vertica Extension

Overview

Summary

Extends Liquibase to support HP Vertica DB

Current Version

1.2

Author

Jony Vesterman Cohen (jony.cohenjo@gmail.com)

 

Issue Tracking

 

SVN Repository

https://github.com/cohenjo/liquibase-vertica

Supported Database

HP Vertica

Usage

To use, simply include the liquibase-vertica-<version>.jar file in your classpath.

Available Commands/Tags

All tags strive to be as close as possible to the product documentation.

<createTable>

Creates a table. this supports the additional properties such as segmentation, ksafe etc.

<createProjection>

Creates a table projection.

Example

    <changeSet author="jony" id="1">
        <ext:createTable tableName="t7">
            <column name="id" type="INT">
                <constraints primaryKey="true" primaryKeyName="C_PRIMARY"/>
            </column>
            <column name="i1" type="INT">
                <constraints nullable="false"/>
            </column>
            <column name="i2" type="INT"/>
        </ext:createTable>
    </changeSet>
    <changeSet author="jony" id="2">
        <ext:createProjection nodes="ALL NODES" orderby="id" projectionName="t7_super" schemaName="bla" segmentedby="hash(t7.id)" subquery="Select * from t7" ksafe="">
            <column encoding="AUTO" name="id" type="INT"/>
            <column encoding="AUTO" name="i1" type="INT"/>
            <column encoding="AUTO" name="i2" type="INT"/>
        </ext:createProjection>
    </changeSet>

Files

liquibase-vertica-1.2-1.jar

liquibase-vertica-1.2.jar

liquibase-vertica-1.1.jar

News

April 01, 2014

1.1 - Initial release

Oct 24, 20141.2 - Vertica 7.1 support for liquibase 3.2.2
Feb 23, 20151.2-1 use default schema when not provided