Apache Presto Interview Questions & Answers

Question 1. What Is Presto?

Answer :

Presto is a distributed SQL query engine. It is an open source software project to develop a database.

Question 2. What Are The Features Of Presto?

Answer :

There are following features of Presto:

• It is simple to use.
• It provides pluggable connectors.
• It provides pipelined executions.
• It provides user define functions.

Question 3. What Are The Presto Applications?

Answer :

There are various Presto applications:

• Facebook
• Teradata
• Airbnb

Question 4. Why Should We Use Presto?

Answer :

We should use Presto because of its features:

• It supports standard ANSI SQL.
• It is built in Java.
• It has connector architecture that is Hadoop.
• It runs on multiple Hadoop distributions.

Question 5. What Are The Components Of Presto Architecture?

Answer :

Presto architecture components are given below:

• Client : Clint submits SQL statements to a coordinator to get the result.
• Coordinator: It parses the SQL queries.
• Connector : Storage plugin is called as connectors.
• Worker : It assigns task to worker nodes.

Question 6. What Are The Log Files Of The Presto Server?

Answer :

The logs files of the Presto server are given below:

• Launcher.log
• Server.log
• http-request.log

Question 7. What Is Presto Verifier?

Answer :

Presto verifier is used to test Presto against another database (such as MySQL).

Question 8. What Is The Default Port Of Presto?

Answer :

The default port of Presto is 8080.

Question 9. What Are The Config Properties Of Presto?

Answer :

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.

Question 10. What Are The Various Data Types In Presto?

Answer :

In Presto, there are various data types in Presto.

• Varchar
• Bigint
• Double
• Decimal
• Json etc.

Question 11. What Are The Functions Of Presto?

Answer :

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.

Question 12. What Is The Use Of Mysql Connector?

Answer :

MYSQL Connector is used to query an external MySQL database.

Question 13. How Can We Create Table By Using Command?

Answer :

We can create table by using command:

presto:tutorials> create table mysql.tutorials.sample as   

select * from mysql.tutorials.author;  

Question 14. What Is Jmx Connector?

Answer :

JMX stands for Java Management Extension. It gives information about the java virtual machine and software running inside JVM.