Interview Questions

AJAX Interview Questions Android Interview Questions Angular 2 Interview Questions AngularJs Interview Questions Apache Presto Interview Questions Apache Tapestry Interview Questions Arduino Interview Questions ASP.NET MVC Interview Questions Aurelia Interview Questions AWS Interview Questions Blockchain Interview Questions Bootstrap Interview Questions C Interview Questions C Programming Coding Interview Questions C# Interview Questions Cakephp Interview Questions Cassandra Interview Questions CherryPy Interview Questions Clojure Interview Questions Cobol Interview Questions CodeIgniter interview Questions CoffeeScript Interview Questions Cordova Interview Questions CouchDB interview questions CSS Buttons Interview Questions CSS Interview Questions D Programming Language Interview Questions Dart Programming Language Interview Questions Data structure & Algorithm Interview Questions DB2 Interview Questions DBMS Interview Questions Django Interview Questions Docker Interview Questions DOJO Interview Questions Drupal Interview Questions Electron Interview Questions Elixir Interview Questions Erlang Interview Questions ES6 Interview Questions and Answers Euphoria Interview Questions ExpressJS Interview Questions Ext Js Interview Questions Firebase Interview Questions Flask Interview Questions Flex Interview Questions Fortran Interview Questions Foundation Interview Questions Framework7 Interview Questions FuelPHP Framework Interview Questions Go Programming Language Interview Questions Google Maps Interview Questions Groovy interview Questions GWT Interview Questions Hadoop Interview Questions Haskell Interview Questions Highcharts Interview Questions HTML Interview Questions HTTP Interview Questions Ionic Interview Questions iOS Interview Questions IoT Interview Questions Java BeanUtils Interview Questions Java Collections Interview Questions Java Interview Questions Java JDBC Interview Questions Java Multithreading Interview Questions Java OOPS Interview Questions Java Programming Coding Interview Questions Java Swing Interview Questions JavaFX Interview Questions JavaScript Interview Questions JCL (Job Control Language) Interview Questions Joomla Interview Questions jQuery Interview Questions js Interview Questions JSF Interview Questions JSP Interview Questions KnockoutJS Interview Questions Koa Interview Questions Laravel Interview Questions Less Interview Questions LISP Interview Questions Magento Interview Questions MariaDB Interview Questions Material Design Lite Interview Questions Materialize CSS Framework Interview Questions MathML Interview Questions MATLAB Interview Questions Meteor Interview Questions MongoDB interview Questions Moo Tools Interview Questions MySQL Interview Questions NodeJS Interview Questions OpenStack Interview Questions Oracle DBA Interview Questions Pascal Interview Questions Perl interview questions Phalcon Framework Interview Questions PhantomJS Interview Questions PhoneGap Interview Questions Php Interview Questions PL/SQL Interview Questions PostgreSQL Interview Questions PouchDB Interview Questions Prototype Interview Questions Pure CSS Interview Questions Python Interview Questions R programming Language Interview Questions React Native Interview Questions ReactJS Interview Questions RequireJs Interview Questions RESTful Web Services Interview Questions RPA Interview Questions Ruby on Rails Interview Questions SAS Interview Questions SASS Interview Questions Scala Interview Questions Sencha Touch Interview Questions SEO Interview Questions Servlet Interview Questions SQL Interview Questions SQL Server Interview Questions SQLite Interview Questions Struts Interview Questions SVG Interview Questions Swift Interview Questions Symfony PHP Framework Interview Questions T-SQL(Transact-SQL) Interview Questions TurboGears Framework Interview Questions TypeScript Interview Questions UiPath Interview Questions VB Script Interview Questions VBA Interview Questions WCF Interview Questions Web icon Interview Questions Web Service Interview Questions Web2py Framework Interview Questions WebGL Interview Questions Website Development Interview Questions WordPress Interview Questions Xamarin Interview Questions XHTML Interview Questions XML Interview Questions XSL Interview Questions Yii PHP Framework Interview Questions Zend Framework Interview Questions Network Architect Interview Questions

Top 14 Apache Presto Interview Questions for 2022

1) What is Presto?

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

2) What are the features of Presto?

There are following features of Presto:
  • It is simple to use.
  • It provides pluggable connectors.
  • It provides pipelined executions.
  • It provides user define functions.

3) What are the Presto applications?

There are various Presto applications:
  • Facebook
  • Teradata
  • Airbnb

4) Why should we use Presto?

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.

5) What are the components of Presto architecture?

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.

6) What are the log files of the Presto server?

The logs files of the Presto server are given below:
  • Launcher.log
  • Server.log
  • http-request.log

7) What is Presto verifier?

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

8) What is the default port of Presto?

The default port of Presto is 8080.

9) What are the Config properties of Presto?

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.

10) What are the various data types in Presto?

In Presto, there are various data types in Presto.
  • Varchar
  • Bigint
  • Double
  • Decimal
  • Json etc.

11) What are the functions of 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.

12) What is the use of MySQL Connector?

MYSQL Connector is used to query an external MySQL database.

13) How can we create table by using command?

We can create table by using command:
presto:tutorials> create table mysql.tutorials.sample as   
select * from mysql.tutorials.author;

14) What is JMX Connector?

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