Liquibase Vertica Extension

Overview

Summary	Extends Liquibase to support HP Vertica DB
Current Version	1.1
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

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                   xmlns:vert="http://www.liquibase.org/xml/ns/dbchangelog-ext/vert"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                   http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
                   http://www.liquibase.org/xml/ns/dbchangelog-ext/vert
                   ../liquibase/ext/vertica/xml/dbchangelog-ext.xsd">
    <changeSet author="jony" id="1">
        <vert: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"/>
        </vert:createTable>
    </changeSet>
    <changeSet author="jony" id="2">
        <vert:createProjection nodes="ALL NODES" orderby="id" projectionName="t7_super" schemaName="bla" segmentedby="hash(t7.id)" subquery="Select * from t7" ksafe="">
            <vert:columnv encoding="AUTO" name="id" type="INT"/>
            <vert:columnv encoding="AUTO" name="i1" type="INT"/>
            <vert:columnv encoding="AUTO" name="i2" type="INT"/>
        </vert:createProjection>
    </changeSet>
</databaseChangeLog>

Files

	File	Modified

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.

No files shared here yet.

Drag and drop to upload or browse for files

News

April 01, 2014

1.1 - Initial release