Want to deploy your JVM, Node.js and Go apps effortlessly to AWS? Try our service Boxfuse

Phoenix

Versions

  • 4.2.2 and later

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

Existing database setup