Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel

Summary

Extends Liquibase to support HP Vertica DB

Current Version

1.12

Author

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

 

Issue Tracking

 

SVN Repository

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

Supported Database

HP Vertica

...

Creates a table projection.

Example

Code Block
<?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<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"/>
        </vertext:createTable>
    </changeSet>
    <changeSet author="jony" id="2">
        <vert<ext:createProjection nodes="ALL NODES" orderby="id" projectionName="t7_super" schemaName="bla" segmentedby="hash(t7.id)" subquery="Select * from t7" ksafe="">
            <vert:columnv<column encoding="AUTO" name="id" type="INT"/>
            <vert:columnv<column encoding="AUTO" name="i1" type="INT"/>
            <vert:columnv<column encoding="AUTO" name="i2" type="INT"/>
        </vertext:createProjection>
    </changeSet>
</databaseChangeLog>

Files

Attachmentspatterns*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