hive操作命令及碰到的问题

learn_step

已于 2024-02-22 11:32:06 修改

阅读量319

点赞数

分类专栏：大数据文章标签： hive 大数据 hadoop

于 2023-05-15 10:00:03 首次发布

本文链接：https://blog.youkuaiyun.com/jquery_learn/article/details/130677172

版权

大数据专栏收录该内容

3 篇文章

订阅专栏

命令：切换到hive的安装目录，输入：./bin/hive

参考：Hive安装使用 - 菜鸟学院

问题：

1、切换到hive的安装目录下，输入hive，报错java.io.CharConversionException: Invalid UTF-8 middle byte 0xe4 (at char #93, byte #20)

处理：hive-site不能有注释部分

2、hadoop fs -mkdir /hive/warehouse提示No such file or directory

直接在目录下创建好的也不行。

处理：切换到/目录，一级级创建

hadoop fs -mkdir /hive

cd /hive

hadoop fs -mkdir /hive/warehouse

授权

hdfs dfs -chmod 755 /hive/warehouse

3、hive客户端不能使用

mapred-site.xml

增加配置

<property>
<name>yarn.application.classpath</name>
<value>/usr/local/hadoop-3.3.6/etc/hadoop,
/usr/local/hadoop-3.3.6/share/hadoop/common/lib/*,
/usr/local/hadoop-3.3.6/share/hadoop/common/*,
/usr/local/hadoop-3.3.6/share/hadoop/hdfs,
/usr/local/hadoop-3.3.6/share/hadoop/hdfs/lib/*,
/usr/local/hadoop-3.3.6/share/hadoop/hdfs/*,
/usr/local/hadoop-3.3.6/share/hadoop/mapreduce/lib/*,
/usr/local/hadoop-3.3.6/share/hadoop/mapreduce/*,
/usr/local/hadoop-3.3.6/share/hadoop/yarn,
/usr/local/hadoop-3.3.6/share/hadoop/yarn/lib/*,
/usr/local/hadoop-3.3.6/share/hadoop/yarn/*
</value>
</property>