...
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, 2014 | 1.2 - Vertica 7.1 support for liquibase 3.2.2 |