Rhive环境搭建问题

1. 安装好 R, hive 后测试 命令行输入 命令能进入控制台,且无错误

2. 在R控制台安装rJava, RHive(install.packages(''))

3. 在命令汉中启动hive thift server,  nohup hive --service hiveserver &

4. libary(RHive)引入包后适应 rhive.connect(host='IP', hiveserver2=FALSE) 不加红色这个这个老出错(和版本有问题我的版本是R 3.02 + hive 0.12 + hadoop2.2)

5. 列出所有hive表 rhive.list.tables()

6. 查看hive表结果 rhive.desc.table('table')

7. hive 查询 rhive.query('sql')

8. hive 查询hdfs目录, rhive.hdfs.ls()

9. hive查询文件 rhive.hdfs.cat('')

10. 关闭连接 rhive.close()

11. Rhive 函数库

rhive.aggregate        rhive.connect          rhive.hdfs.exists      rhive.mapapply
rhive.assign           rhive.desc.table       rhive.hdfs.get         rhive.mrapply
rhive.basic.by         rhive.drop.table       rhive.hdfs.info        rhive.napply
rhive.basic.cut        rhive.env              rhive.hdfs.ls          rhive.query
rhive.basic.cut2       rhive.exist.table      rhive.hdfs.mkdirs      rhive.reduceapply
rhive.basic.merge      rhive.export           rhive.hdfs.put         rhive.rm
rhive.basic.mode       rhive.exportAll        rhive.hdfs.rename      rhive.sapply
rhive.basic.range      rhive.hdfs.cat         rhive.hdfs.rm          rhive.save
rhive.basic.scale      rhive.hdfs.chgrp       rhive.hdfs.tail        rhive.script.export
rhive.basic.t.test     rhive.hdfs.chmod       rhive.init             rhive.script.unexport
rhive.basic.xtabs      rhive.hdfs.chown       rhive.list.tables      
rhive.size.table
rhive.big.query        rhive.hdfs.close       rhive.load             rhive.write.table
rhive.block.sample     rhive.hdfs.connect     rhive.load.table
rhive.close            rhive.hdfs.du          rhive.load.table2


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值