hive
wangxizhen123
热爱技术
展开
-
hive安装
下载Hive安装包http://hive.apache.org/downloads.html2、将hive文件上传到HADOOP集群,并解压 将文件上传到:/export/softwaretar -zxvf apache-hive-1.2.1-bin.tar.gz -C /export/servers/cd /export/servers/ln -s ap原创 2017-10-06 21:06:16 · 495 阅读 · 0 评论 -
使用hive报 return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask解决方法
当我使用hive进行如下查询时 select * from t_t inner join t_te on t_t.id=t_te.id;出现如下错误:Query ID = root_20180410193117_e9d36b57-54ce-4ad5-a48c-df876f449de1Total jobs = 118/04/10 19:31:20 WARN conf.Configuration:...原创 2018-04-10 17:07:57 · 14729 阅读 · 0 评论 -
常用的hive语句
创建分区表create table one(id int comment 'the id',name string comment 'the name',age int comment 'the age') partitioned by(part string)row format delimited fields terminated by ','stored as textfile;往...原创 2018-05-05 19:32:37 · 709 阅读 · 0 评论