Interview Questions.

Q1. Is Spark Sql Similar To Drill?

No

Q2. How Does Drill Support Queries On Self-describing Data?

JSON data version

On-the-fly schema discovery

Q3. How Does Drill Achieve Performance?

Distributed question optimization and execution

Columnar Execution

Optimistic Execution

Pipelined Execution

Runtime compilation and code era

Vectorization

Q4. What Sql Functionality Does Drill Support?

Drill helps popular SQL (aka ANSI SQL). In addition, it capabilities numerous extensions that assist with complex facts, such as the KVGEN and FLATTEN features. For greater information, confer with the SQL Reference.

Q5. Do I Need To Load Data Into Drill To Start Querying It?

No, The Drill can query information in-situ.

Q6. What Is Apache Drill?

Apache Drill is a Schema-loose SQL Query Engine for Hadoop, NoSQL and Cloud Storage and it permits us to explore, visualize and question one-of-a-kind datasets without having to restoration to a schema using ETL and so on.

Apache Drill is likewise Analyse the multi-established and nested facts in non-relational data shops without delay with out limiting any facts.

Apache Drill is the primary dispensed SQL query engine and it includes the schema free JSON model and its looks like -

Elastic Search

MongoDB

NoSQL database

And SO on

The Apache Drill is very beneficial for the ones professionals that already running with SQL databases and BI tools like Pentaho, Tableau, and Qlikview.

Also Apache Drill supports to -

RESTful,

ANSI SQL and

JDBC/ODBC drivers

Q7. What Datastores Does Drill Support?

Drill’s fundamental centered on non-relational information stores, together with Hadoop, NoSQL and cloud garage.

The following datastores are -

NoSQL - HBase and MongoDB

Cloud Storage - Amazon S3, Google Cloud Storage, Azure Blog Storage and Swift

Hadoop - MapR, CDH and Amazon EMR

Q8. Does Drill Replace Hive?

Hive is a batch processing framework most suitable for lengthy-going for walks jobs. For facts exploration and BI, Drill gives a much better experience than Hive.

In addition, Drill isn't always restricted to Hadoop. For instance, it is able to question NoSQL databases (eg, MongoDB, HBase) and cloud storage (eg, Amazon S3, Google Cloud Storage, Azure Blob Storage, Swift).

Q9. What Does A Drill Query Look Like?

Drill uses a decentralized metadata model and relies on its storage plugins to provide metadata. There is a storage plugin associated with every information source this is supported by using Drill.

The call of the desk in a question tells Drill where to get the facts:

SELECT * FROM dfs1.Root.`/my/log/documents/`;

SELECT * FROM dfs2.Root.`/home/john/log.Json`;

SELECT * FROM mongodb1.Website.Customers;

SELECT * FROM hive1.Logs.Frontend;

SELECT * FROM hbase1.Occasions.Clicks;

Q10. What Are The Main Differences Between Spark Sql And Apache Drill?

The Spark SQL handiest supports a subset of SQL but Apache Drill supports ANSI SQL.

Querying data in Spark SQL with assist of languages like Java, Scala or Python however Apache Drill querying records with helps of MySQL or Oracle.

Q11. What Clients Are Supported?

BI gear through the ODBC and JDBC drivers (eg, Tableau, Excel, MicroStrategy, Spotfire, QlikView, Business Objects)

Custom programs through the REST API

Java and C applications via the devoted Java and C libraries Comparisons