1.

What Does A Drill Query Look Like?

Answer»

Drill uses a decentralized metadata MODEL and RELIES on its storage plugins to provide metadata. There is a storage PLUGIN associated with each data SOURCE that is supported by Drill.

The name of the table in a query tells Drill where to get the data:

SELECT * FROM dfs1.root.`/my/log/files/`;

SELECT * FROM dfs2.root.`/home/john/log.json`;

SELECT * FROM mongodb1.website.users;

SELECT * FROM hive1.logs.frontend;

SELECT * FROM hbase1.events.clicks;

Drill uses a decentralized metadata model and relies on its storage plugins to provide metadata. There is a storage plugin associated with each data source that is supported by Drill.

The name of the table in a query tells Drill where to get the data:

SELECT * FROM dfs1.root.`/my/log/files/`;

SELECT * FROM dfs2.root.`/home/john/log.json`;

SELECT * FROM mongodb1.website.users;

SELECT * FROM hive1.logs.frontend;

SELECT * FROM hbase1.events.clicks;


Discussion

No Comment Found

Related InterviewSolutions