大数据 - Hive
yamaxifeng_132
努力、奋斗
展开
-
hive 插入数据的时候,不能直接运行,报错FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.
ive 插入数据的时候,不能直接运行,报错错误原因:namenode内存空间不够,JVM剩余内存空间不够新job运行所致错误提示Starting Job = job_1594085668614_0006, Tracking URL = http://kudu:8088/proxy/application_1594085668614_0006/Kill Command = /root/soft/hadoop-3.2.1/bin/mapred job -kill job_1594085668转载 2021-08-23 15:25:40 · 525 阅读 · 0 评论 -
HIVE设置连接用户名和密码
Hive设置连接用户名和密码,操作相关步骤如下:Hive-site.xml,缺省为NONE。此处改为CUSTOM<property> <name>hive.server2.authentication</name> <value>CUSTOM</value> <description> Expects one of [nosasl, none, ldap, kerberos, pam, cus转载 2021-08-23 14:51:14 · 11748 阅读 · 0 评论 -
hiveserver2启动:javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS""
查看metastore的日志,报错信息如下:... 47 more2016-11-14 16:10:00,881 ERROR [main]: metastore.MetaStoreDirectSql (MetaStoreDirectSql.java:<init>(135)) - Self-test query [select "DB_ID" from "DBS"] failed...转载 2019-10-18 23:17:09 · 2749 阅读 · 0 评论 -
windows10部署hive-3.1.2
部署Hive之前,需要先搭建Hadoop和MySQL,mysql数据库用于存放元数据(默认数据库为Derby)。1 环境版本OS: Windows 10java:jdk1.8.0_111Hadoop: hadoop-3.1.2Hive: Hive-3.1.22 部署准备1. 下载hive部署包并解压。注意:同时下载apache-hive-1.0.0-src.tar....原创 2019-10-18 23:35:54 · 4049 阅读 · 0 评论 -
在Hadoop 中用 hive 命令启动时报错:expansion character (code 0x8 at [row,col,system-id]: [3213,96,
Exception in thread "main" java.lang.RuntimeException: com.ctc.wstx.exc.WstxParsingException: Illegal character entity: expansion character (code 0x8 at [row,col,system-id]: [3213,96,"file:/opt/hive...转载 2019-10-18 18:33:08 · 1374 阅读 · 3 评论 -
Ubuntu下Hive-2.3.0安装
Ubuntu下Hive-2.3.0安装转载 2017-12-16 20:54:51 · 584 阅读 · 0 评论 -
Hive2:Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient原创 2017-12-16 20:50:41 · 5664 阅读 · 2 评论 -
Hive提示警告SSL
Hive提示警告SSL转载 2017-12-16 20:33:58 · 969 阅读 · 0 评论 -
Hive启动时,报错Relative path in absolute URI: ${system:java.io.tmpdir}
Hive启动时,报错Relative path in absolute URI: ${system:java.io.tmpdir}原创 2017-02-09 15:36:33 · 6238 阅读 · 0 评论 -
Hive启动出现权限错误 /tmp/hive on HDFS should be writable.
Hive启动出现权限错误 /tmp/hive on HDFS should be writable.原创 2017-02-09 15:25:55 · 1993 阅读 · 0 评论