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 | |
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
News
April 01, 2014 | 1.1 - Initial release |
Oct 24, 2014 | 1.2 - Vertica 7.1 support for liquibase 3.2.2 |
Feb 23, 2015 | 1.2-1 use default schema when not provided |