2.4. Presto Verifier

The Presto Verifier can be used to test Presto against another database (such as MySQL),or to test two Presto clusters against each other. We use it to continuously test trunkagainst the previous release while developing Presto.

Running Verifier

Create a MySQL database with the following table and load it with the queries you would like to run:

CREATE TABLE verifier_queries (
    id int(11) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
    suite varchar(256) NOT NULL,
    name varchar(256) DEFAULT NULL,
    control_catalog varchar(256) NOT NULL,
    control_schema varchar(256) NOT NULL,
    control_query text NOT NULL,
    test_catalog varchar(256) NOT NULL,
    test_schema varchar(256) NOT NULL,
    test_query text NOT NULL,
    control_username varchar(256) NOT NULL DEFAULT 'verifier-test',
    control_password varchar(256) DEFAULT NULL,
    test_username varchar(256) NOT NULL DEFAULT 'verifier-test',
    test_password varchar(256) DEFAULT NULL,
    session_properties_json varchar(2048) DEFAULT NULL)

Next, create a properties file to configure the verifier:

source-query.suite=my_suite
source-query.database=jdbc:mysql://localhost:3306/my_database?user=my_username&password=my_password
control.gateway=jdbc:presto://localhost:8080
test.gateway=jdbc:presto://localhost:8081
test-id=1

Lastly, download presto-verifier-0.220-executable.jar, rename it to verifier,make it executable with chmod +x, then run it:

./verifier verify config.properties

Configuration Reference