{"id":1083,"date":"2016-05-03T10:36:33","date_gmt":"2016-05-03T18:36:33","guid":{"rendered":"http:\/\/www.developerscloset.com\/?page_id=1083"},"modified":"2018-05-04T11:56:45","modified_gmt":"2018-05-04T19:56:45","slug":"drill","status":"publish","type":"page","link":"https:\/\/www.developerscloset.com\/?page_id=1083","title":{"rendered":"Drill"},"content":{"rendered":"

\"\"<\/a><\/p>\n

Apache Drill is an open-source software framework that supports data-intensive distributed applications for interactive analysis of large-scale datasets. Drill is the open source version of Google’s Dremel system which is available as an infrastructure service called Google BigQuery. One explicitly stated design goal is that Drill is able to scale to 10,000 servers or more and to be able to process petabytes of data and trillions of records in seconds. Drill is an Apache top-level project.<\/p>\n

Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. Using jdbc Drill is able to query SQL, Oracle, etc. A single query can join data from multiple datastores. For example, you can join a user profile collection in MongoDB with a directory of event logs in HDFS.<\/p>\n

\n

Table of Contents<\/p>\n