1.官网下载hive2.1,并解压
2.配置/etc/profile
3.配置hive-site.xml
将模版复制cp 一份,并配置连接oracle信息
.
4。执行命令 schematool -dbType oracle -initSchema
5.启动 ./bin/hive
创建wordcount表,用于存放随笔二的执行结果
语句:create table wordcount1(word string,count int) row format delimited fields terminated by ',';
加载数据,
语句:load data inpath 'hdfs://192.168.67.100:9000/output/part-r-00000' into table wordcount
查询