Performance Tuning for large queries on Apache Drill

Asked Jan 16 '17 at 10:06

Active Jan 17 '17 at 11:28

Viewed 647 times

Am trying to execute large queries on apache drill and its taking more than 1 hour to run, even though CPUs, memory and I/O are all under utilized.

Size of underlying data in parquet format: 30 GB

Cluster Size: Single node

RAM: 512 GB, 300GB assigned to drill.

CPU: 48

File System: MapR

What are the possible tuning parameters that one can check to improve the performance of apache drill?

edited Jan 17 '17 at 11:28

asked Jan 16 '17 at 10:06

Srihari Karanth

Where does your data reside? HDFS, S3 or local file system? – Uwe L. Korn Jan 16 '17 at 16:14
Data is on MapR file system – Srihari Karanth Jan 16 '17 at 16:44
Possible duplicate of [apache drill bad performance](https://stackoverflow.com/questions/39583012/apache-drill-bad-performance) – Muhammad Gelbana Aug 14 '17 at 11:49
Please provide an example of your sql command. – ilooner Jan 26 '18 at 23:42

0 Answers0