Apache Presto Configuration Settings Apache Presto

What is Apache Presto - Configuration Settings?

This section on Presto will discuss the configuration settings.

Presto Verifier

Presto Verifier is used to test Presto against another database (such as Oracle), or to test two Presto clusters against each other.

Create Database in MySQL

First we need to open MySQL server and create a database using the below command.

Now we need to create “test” database in the server, creating a table by loading it with below query.

Add Config Settings

We need to create a properties file to configure the verifier −

Here, in the query-database field, enter the following details − mysql database name, user name, and password.

Download JAR File

We need to download Presto-verifier jar file by visiting the below link,

https://repo1.maven.org/maven2/com/facebook/presto/presto-verifier/0.149/

Now the version “presto-verifier-0.149-executable.jar” is downloaded on our machine.

Execute JAR

Now we need to execute the JAR file using the below command,

Run Verifier

Now we need to run the verifier using the below command,

Create Table

Let’s create a simple table in “test” database using the below query.

Insert Table

After creating a table, insert two records using the below query,

Run Verifier Query

Execute the following sample query in the verifier terminal (./verifier config.propeties) to check the verifier result.

Sample Query

As select * from mysql.test.product query refers to mysql catalog, where test is database name and product is the table name. Presto server is used to access mysql connector in this way.

Now, to see the performance we need to test two same select queries. In the same way, performance results are tested by running other queries. We can also connect two Presto clusters to check the performance results.


Face Book Twitter Google Plus Instagram Youtube Linkedin Myspace Pinterest Soundcloud Wikipedia

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Apache Presto Topics