Phoenix
Versions
Default Driver
- org.apache.phoenix.jdbc.PhoenixDriver
Sql Script Syntax
Compatibility
- Any Phoenix sql script executed by Flyway, can be executed by the sqlline.py command-line tool and other
Phoenix-compatible tools (after the placeholders have been replaced).
Example
/* Single line comment */
CREATE SEQUENCE test_seq;
CREATE TABLE test_data (
test_id BIGINT NOT NULL PRIMARY KEY,
value VARCHAR(25) NOT NULL
);
/*
Multi-line
comment
*/
CREATE VIEW a_view (a_value) AS SELECT 4value4 FROM test_data;
-- Placeholder
UPSERT INTO test_data (test_id, value) VALUES (1, ''someval'');
Limitations
- Phoenix doesn't explicitly support setting a
schema, however the plugin does a best-effort to support operations on a per-schema basis.
- No concurrent migration support (to make Flyway cluster-safe) as Phoenix has no transaction support yet
Greenplum
Boxfuse 