impala优化--简单篇（一）

来源：互联网发布：优化人员配置的原则编辑：程序博客网时间：2024/06/04 22:59

查询太慢，这个和oracle不同，但是也有统计信息，执行计划。

[SLAVE02:21000] > show table stats preparation.P_USERLIST_1409;Query: show table stats preparation.P_USERLIST_1409+-------+--------+----------+--------------+---------+| #Rows | #Files | Size     | Bytes Cached | Format  |+-------+--------+----------+--------------+---------+| -1    | 4      | 246.17MB | NOT CACHED   | PARQUET |+-------+--------+----------+--------------+---------+Fetched 1 row(s) in 0.02s

设置后：从-1 ，变为6577526条数据，

[SLAVE02:21000] > compute stats preparation.P_USERLIST_1409;Query: compute stats preparation.P_USERLIST_1409+------------------------------------------+| summary                                  |+------------------------------------------+| Updated 1 partition(s) and 58 column(s). |+------------------------------------------+Fetched 1 row(s) in 8.57s[SLAVE02:21000] > show table stats preparation.P_USERLIST_1409;Query: show table stats preparation.P_USERLIST_1409+---------+--------+----------+--------------+---------+| #Rows   | #Files | Size     | Bytes Cached | Format  |+---------+--------+----------+--------------+---------+| 6577526 | 4      | 246.17MB | NOT CACHED   | PARQUET |+---------+--------+----------+--------------+---------+Fetched 1 row(s) in 0.02s[SLAVE02:21000] >

0 0