hive

1.导入数据从mysql to hive(python)

http://www.cnblogs.com/duking1991/p/6123047.html

2.hive处理日志

http://blog.youkuaiyun.com/wulantian/article/details/46341169

3.hive+kafka+flume日志处理

http://www.icoolxue.com/play/9668

4. 

CDH Mysql数据库 JDBC driver cannot be found.

http://blog.youkuaiyun.com/levy_cui/article/details/51142843

5.hive在oozie中执行

http://blog.youkuaiyun.com/fighting_one_piece/article/details/37738979

6.hive pg安装

http://blog.youkuaiyun.com/xgjianstart/article/details/52192879

7.hive相关命令

后台服务启动

nohup hive --service hiveserver2 &

释放pg连接的用户session

SELECT pg_terminate_backend(pg_stat_activity.pid)  
FROM pg_stat_activity  
WHERE datname='template1' AND pid<>pg_backend_pid();

8.hive sql设计

http://blog.youkuaiyun.com/longshenlmj/article/details/45339575

存储

http://lxw1234.com/archives/2015/09/487.htm?replytocom=1315

导出pg表结构

http://blog.youkuaiyun.com/shiqining888/article/details/46917859

传入外部表量

http://www.crazyant.net/1451.html

9.hive抽取数字

http://blog.youkuaiyun.com/u010035907/article/details/73770830

10.实现相似度计算-向量夹角余弦值

http://blog.sina.com.cn/s/blog_4a6b27a30102vbr0.html

11.hive执行权限

修改

 hadoop fs -chmod-R 777 /tmp/hadoop-yarn/staging/hive

hadoop fs -chown -R hive:hive /tmp/hadoop-yarn/staging/hive

12.hive 行转列

http://blog.youkuaiyun.com/jthink_/article/details/38853573

udf

http://blog.youkuaiyun.com/scgaliguodong123_/article/details/46993005