Adamhuan's Data Center - 【逻辑驱动数据】
数据玩物、代码屋、1/0游戏：（零和博弈）/ 禅宗意志 / 规则战争 / 解放数据力量 / 技术的飞速发展并没有改变这个世界，因为，这个世界从没有变，它只是越来越趋近于它本来的模样。
Doug Cutting：Use of MapReduce engine for Big Data projects will decline, replaced by Apache Spark.
[……]
Adamhuan
概览
【HAWQ】是一个Hadoop原生的大规模并行SQL分析引擎（SQL on Hadoop），针对的是分析性应用，和其他的关系型数据库类似：接收SQL，返回结果集。
其中，【原生】主要体现在以下几个方面：
参考文档：
安装前
https://www.cloudera.com/documentation/enterprise/6/6.1/topics/installation_reqts.html
安装时
https://www.cloudera.com/documentation/en[……]
Adamhuan
命令行如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
[root@cdh2 ~]# impala-shell Starting Impala Shell without Kerberos authentication Connected to cdh2:21000 Server version: impalad version 2.7.0-cdh5.10.0 RELEASE (build 785a073cd07e2540d521ecebb8b38161ccbd2aa2) *********************************************************************************** Welcome to the Impala shell. (Impala Shell v2.7.0-cdh5.10.0 (785a073) built on Fri Jan 20 12:03:56 PST 2017) Want to know what version of Impala you're connected to? Run the VERSION command to find out! *********************************************************************************** [cdh2:21000] > connect cdh2; Connected to cdh2:21000 Server version: impalad version 2.7.0-cdh5.10.0 RELEASE (build 785a073cd07e2540d521ecebb8b38161ccbd2aa2) [cdh2:21000] > [cdh2:21000] > invalidate metadata; Query: invalidate metadata Query submitted at: 2018-08-31 23:28:25 (Coordinator: http://cdh2:25000) Query progress can be monitored at: http://cdh2:25000/query_plan?query_id=724a13ec400f3864:ceb32a4400000000 Fetched 0 row(s) in 6.92s [cdh2:21000] > [cdh2:21000] > show tables; Query: show tables +-------------+ | name | +-------------+ | movie | | movierating | +-------------+ Fetched 2 row(s) in 0.54s [cdh2:21000] > [cdh2:21000] > select count(*) from movie; Query: select count(*) from movie Query submitted at: 2018-08-31 23:29:33 (Coordinator: http://cdh2:25000) Query progress can be monitored at: http://cdh2:25000/query_plan?query_id=824a3ba5793a8adf:4cd33f1700000000 +----------+ | count(*) | +----------+ | 3881 | +----------+ Fetched 1 row(s) in 18.26s [cdh2:21000] > [cdh2:21000] > select count(*) from movierating; Query: select count(*) from movierating Query submitted at: 2018-08-31 23:30:03 (Coordinator: http://cdh2:25000) Query progress can be monitored at: http://cdh2:25000/query_plan?query_id=304df122f17f2a8a:8592d4b00000000 +----------+ | count(*) | +----------+ | 1000205 | +----------+ Fetched 1 row(s) in 4.25s [cdh2:21000] > [cdh2:21000] > quit; Goodbye root [root@cdh2 ~]# |
CM的图形界面中，可以看到上述命令的历史：
——————————————————
Done。[……]