impala优化--简单篇（一）

查询太慢，这个和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] >