Performance Tuning Introduction drill 性能调优

翻译不好!勿喷！  

You can apply performance tuning measures to improve how efficiently Drill queries data. 

你可以使用性能调优的方法来提升drill查询数据的效率

To significantly improve performance in Drill, you must have knowledge about the underlying data and data sources, as well as familiarity with how Drill executes queries.

在更深入的提升drill性能方面，你需要和熟悉drill怎样执行查询一样，同样精通底层数据存储和数据源知识。

You can analyze query plans and profiles to identify the source of performance issues in Drill. Once you have isolated the source of an issue, you can apply the following tuning techniques to improve query performance:

你可以分析执行计划和profiles来甄别性能问题的根源。一旦通过控制变量的方法，梳理出问题的症结，就可以使用下面的调优技巧来提高查询性能。

• Modify query planning options
• 修改查询计划参数
• Modify broadcast join options
• 修改广播（？）连接的参数
• Switch between 1 or 2 phase aggregation
• 在1到2之间的相位聚合切换 ？？？？
• Enable/disable hash-based memory-constrained operators
• 使生效/失效 基于哈希的内存约束 操作？
• Enable query queuing
• 使用查询队列
• Control parallelization
• 并行计算控制
• Organize data for partition pruning
• 有效的组织切割数据分区
• Change storage formats
• 改变存储格式
• Disable Logging (See Logging and Debugging)
• 不输出日志