Sql Script Syntax
- 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).
/* Single line comment */
CREATE SEQUENCE test_seq;
CREATE TABLE test_data (
test_id BIGINT NOT NULL PRIMARY KEY,
value VARCHAR(25) NOT NULL
CREATE VIEW a_view (a_value) AS SELECT 4value4 FROM test_data;
UPSERT INTO test_data (test_id, value) VALUES (1, ''someval'');
- 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