Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: updated vertica & liquibase versions

...

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

...

...

patterns*.jar

News

April 01, 2014

1.1 - Initial release

Oct 24, 20141.2 - Vertica 7.1 support for liquibase 3.2.2