APACHE PRESTO INTERVIEW QUESTIONS

Most Important Frequently Asked Apache Presto Interview Questions

1. Question 1. What Is Presto?

   Answer :

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

2. 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.

Apache Tapestry Interview Questions

3. Question 3. What Are The Presto Applications?

   Answer :

   There are various Presto applications:

   • Facebook
   • Teradata
   • Airbnb

4. 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.

Apache Tapestry Tutorial

5. 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.

Apache Cassandra Interview Questions

6. 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

7. Question 7. What Is Presto Verifier?

   Answer :

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

Apache Cassandra Tutorial Apache Spark Interview Questions

8. Question 8. What Is The Default Port Of Presto?

   Answer :

   The default port of Presto is 8080.

9. 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.

Apache Solr Interview Questions

10. 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.

Apache Solr Tutorial

11. 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.

Apache Storm Interview Questions

12. Question 12. What Is The Use Of Mysql Connector?

    Answer :

    MYSQL Connector is used to query an external MySQL database.

Apache Tapestry Interview Questions

13. 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;  

Apache Storm Tutorial

14. 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.

Topic: Apache Presto Interview Questions