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