每日日报--Hive的学习(4)
完成内容:
1.hive的操作
查询
SELECT [ALL | DISTINCT] select_expr, select_expr, ...
FROM table_reference
[WHERE where_condition]
[GROUP BY col_list]
[ORDER BY col_list]
[CLUSTER BY col_list
| [DISTRIBUTE BY col_list] [SORT BY col_list]
]
[LIMIT number]
where
hive (default)> select * from emp where sal >1000;
2.连接mysql至navicat
遇到问题:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '000000';
1130 - Host XXX is not allowed to connect to this MySQL server。
解决
目标:继续学习hadoop