欢迎投稿

今日深度:

hive,

hive,


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

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


2.hive处理日志

http://blog.csdn.net/wulantian/article/details/46341169


3.hive+kafka+flume日志处理

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


4. 

CDH Mysql数据库 JDBC driver cannot be found.

http://blog.csdn.net/levy_cui/article/details/51142843


5.hive在oozie中执行

http://blog.csdn.net/fighting_one_piece/article/details/37738979


6.hive pg安装

http://blog.csdn.net/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.csdn.net/longshenlmj/article/details/45339575

存储

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

导出pg表结构

http://blog.csdn.net/shiqining888/article/details/46917859

传入外部表量

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


9.hive抽取数字

http://blog.csdn.net/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.csdn.net/jthink_/article/details/38853573

udf

http://blog.csdn.net/scgaliguodong123_/article/details/46993005



www.htsjk.Com true http://www.htsjk.com/hive/27801.html NewsArticle hive, 1.导入数据从mysql to hive(python) http://www.cnblogs.com/duking1991/p/6123047.html 2.hive处理日志 http://blog.csdn.net/wulantian/article/details/46341169 3.hive+kafka+flume日志处理 http://www.icoolxue.com/play/9668 4.  ...
相关文章
    暂无相关文章
评论暂时关闭