2.6. presto校验¶
2.6.1. verifier下载¶
wget https://repo1.maven.org/maven2/com/facebook/presto/presto-verifier/0.217/presto-verifier-0.217-executable.jar
2.6.2. 制作可执行客户端¶
mv presto-verifier-0.224-executable.jar verifier
chmod +x verifier
2.6.3. 表创建¶
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)
2.6.4. config.properties¶
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
2.6.5. 客户端使用¶
./verifier verify config.properties
2.6.6. 软连接建立¶
ln -s /usr/local/presto-server-0.217/verifier /usr/local/bin/verifier