MYSQL Connector is used to query an external MySQL database.
Presto verifier is used to test Presto against another database (such as MySQL).
Presto is a distributed SQL query engine. It is an open source software project to develop a database.
There are various Presto applications:
Presto architecture components are given below:
The logs files of the Presto server are given below:
We can create table by using command:
presto:tutorials> create table mysql.tutorials.sample as
select * from mysql.tutorials.author;
We should use Presto because of its features:
In Presto, there are various data types in Presto.
There are various functions of Presto that are given below:
Function--->Description
Abs(x):It returns the absolute value of X.
Cbrt(x):It returns the cube root of x.
Ceiling(x):It returns the x value rounded up to nearest integer.
Ceil(x):Arial for ceiling(x)
Log2(x):It returns the base 2 logarithm of x.
JMX stands for Java Management Extension. It gives information about the java virtual machine and software running inside JVM.
The Config properties of Presto are given below table:
Config Properties----->Description
task. info -refresh-max-wait:It reduces coordinator work load.
task.max-worker-threads:It splits the process and assigns to each worker nodes.
distributed-joins-enabled:It is Hashed based distributed joins.
node-scheduler.network-topology:It sets network topology to scheduler.
The default port of Presto is 8080.
There are following features of Presto: