配置hive的坑 hive-site.xml:2787:3: The element type "configuration" must be terminated by the matching

最新推荐文章于 2022-06-06 14:12:00 发布
最新推荐文章于 2022-06-06 14:12:00 发布
阅读量1.4w 收藏 1
点赞数
CC 4.0 BY-SA版权
分类专栏： 大数据
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/titer1/article/details/68947138
本文解决了一个关于Hive配置文件hive-site.xml中出现的XML格式错误问题，该错误阻止了Hive的正常启动。具体表现为配置文件中的configuration元素没有正确的结束标签。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

问题

配置完hive,运行遇到以下问题

hive-site.xml:2787:3: The element type "configuration" must be terminated by the matching end-tag "</configuration>

现象

详细的输出是

“`xml
[Fatal Error] hive-site.xml:2787:3: The element type “configuration” must be terminated by the matching end-tag “”.
17/04/01 18:03:12 FATAL conf.Configuration: error parsing conf file:/usr/local/hive/conf/hive-site.xml
org.xml.sax.SAXParseException; systemId: file:/usr/local/hive/conf/hive-site.xml; lineNumber: 2787; columnNumber: 3; The element type “configuration” must be terminated by the matching end-tag “”.
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:257)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:347)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:150)
at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2325)
at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2313)
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2381)
at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2347)
at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2254)
at org.apache.hadoop.conf.Configuration.get(Configuration.java:1081)
at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1526)
at org.apache.hadoop.hive.conf.HiveConf.(HiveConf.java:1471)
at org.apache.hadoop.hive.common.LogUtils.initHiveLog4jCommon(LogUtils.java:74)
at org.apache.hadoop.hive.common.LogUtils.initHiveLog4j(LogUtils.java:58)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:649)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
Exception in thread “main” java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/usr/local/hive/conf/hive-site.xml; lineNumber: 2787; columnNumber: 3; The element type “configuration” must be terminated by the matching end-tag “”.
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2490)
at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2347)
at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2254)
at org.apache.hadoop.conf.Configuration.get(Configuration.java:1081)
at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:1526)
at org.apache.hadoop.hive.conf.HiveConf.(HiveConf.java:1471)
at org.apache.hadoop.hive.common.LogUtils.initHiveLog4jCommon(LogUtils.java:74)
at org.apache.hadoop.hive.common.LogUtils.initHiveLog4j(LogUtils.java:58)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:649)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
Caused by: org.xml.sax.SAXParseException; systemId: file:/usr/local/hive/conf/hive-site.xml; lineNumber: 2787; columnNumber: 3; The element type “configuration” must be terminated by the matching end-tag “”.
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:257)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:347)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:150)
at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2325)
at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2313)
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2381)
… 14 more
““

解决方案

line 2783后面，官方模板缺少一个 

<property>
使用Sqoop将SQL Server视图中数据导入Hive
光于前裕于后的博客
10-30 2090
环境版本： ·HDP-2.5.3 ·Hive 1.2.1 ·Sqoop 1.4.6 ·SQL Server 2012 文章目录1.下载sqljdbc4.jar放在$SQOOP_HOME/lib下2.测试sql server连接2.1 List available databases on a server2.2 List available tables in a database2.3 ...
解决：Invalid prop:Expected String with value “30“, got Number with value 30.的问题
狮子座的男孩
10-02 4469
中文翻译：无效的道具：道具“标签”的类型检查失败。预期值为“30”的字符串，得到值为 30 的数字。看到提示，肯定是设置的。(即：设置的字符类型为。
The element type "xxx" must be terminated by the matching end-tag 解决
热门推荐
wobfei的博客
08-06 2万+
查看系统日志时，发现读取xml 流时抛出了“The element type "description" must be terminated by the matching end-tag "&lt;/description&gt;". Nested exception”错误。   查看对应url的流内容，如下 &lt;?xml version="1.0" encoding="gb231...
Hive中字段和表注释中文乱码
hejianjun1989的博客
11-08 788
Hive中字段和表注释中文乱码hive中乱码修改方法1.hive的元数据库字符集修改2.hive-site.xml配置修改3.修改表注释和字段注释总结 hive中乱码 建表如下： CREATE EXTERNAL TABLE ods_user ( user_num STRING COMMENT '用户编号', mobile STRING COMMENT '手机号码', reg_date STRING COMMENT '注册日期') COMMENT '用户资料表' PARTITI..
启动hive服务报错
leezsj的博客
07-19 707
hive-site.xml:17:78: The reference to entity "useSSL" must end with the ';' delimiter. 21/07/19 14:30:18 FATAL conf.Configuration: error parsing conf file:/usr/local/hive/conf/hive-site.xml org.xml.sax.SAXParseException; systemId: file:/usr/local/hive/conf
安装hive阶段，Exception in thread "main" java.lang.RuntimeException: org.xml.sax.SAXParseException;
乔治大哥的博客
10-30 6352
Exception in thread "main" java.lang.RuntimeException: org.xml.sax.SAXParseException; sys temId: file:/opt/hive/conf/hive-site.xml; lineNumber: 2; columnNumber: 6; The processing instruction target ma...
IDEA运行tomcat时报错:The element type “Host“ must be terminated by the matching end-tag “＜/Host＞“.
小渣渣的博客
09-20 5260
IDEA运行tomcat时报错:Error running ‘Tomcat 7’: Cannot load C:\Users\22068\.IntelliJIdea2018.2\system\tomcat\Tomcat_7_0_109_JavaWeb\conf\server.xml: Error on line 134: The element type “Host” must be terminated by the matching end-tag “</Host>”. 一、报错提示如下：
List of plugins was not loaded: The element type "hr" must be terminated by the matching end-tag "</hr>".
最新发布
03-08
嗯，用户遇到了XML或HTML中的错误：“The element type &#39;hr&#39; must be terminated by the matching end-tag &#39;</hr>&#39;”，导致插件列表无法加载。首先，我需要确定这个问题的根本原因。根据引用中的例子，像[^3]提到...
hadoop2.7.2集群hive-1.2.1整合hbase-1.2.1
gao634209276的博客
05-12 6258
本文操作基于官方文档说明,以及其他相关资料,若有错误,希望大家指正 根据hive官方说明整合hbase链接如下https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration 文中指出hive0.9.0匹配的Hbase版本至少要0.92,比这更早的hive版本要匹配Hbase0.89或者0.90 自Hive1.x后,hive能
hive导入HDFS数据
z363115269的专栏
09-04 2万+
HDFS文件路径：/user/test/qar_test.txt
hadoop生态之hive
运维Linux和python
02-18 830
序言大数据的生态包含各种各样的组件，hive是其中之一，hive主要是作为数据仓库的工具，简化相关人员的代码工作，只要编写简单的SQL就可以实现mapreduce效果。...
Hive 使用tez 多表查询时 Caused by: org.xml.sax.SAXParseException
蒯厅博客
11-23 563
报错信息： Caused by: java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/opt/module/hadoop-2.7.2/etc/hadoop/tez-site.xml; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. at org.apache.hadoop.conf.Configuration.
hive-exception-SemanticException [Error 10044]：Table insclause-0 has 3 columns, but query has
DCHAO的博客
06-06 1763
hive报错
Caused by: org.xml.sax.SAXParseException; systemId: file:/home/hadoop/hive-0.12.0/conf/hive-site.xml...
HiterCoder
12-12 4006
Caused by: org.xml.sax.SAXParseException; systemId: file:/home/hadoop/hive-0.12.0/conf/hive-site.xml; lineNumber: 5; columnNumber: 2; The markup in the document following the root element mus...
印象笔记无法同步：error: “The element type “li“ must be terminated by the matching end-tag “＜/li＞“. (ENML_VAL
二次蓝的博客
10-15 3204
版本：6.21.10.2263 (602263) Public (CE Build 74.0.9407, ME Build V1.0.28, Mind Build V1.0.54) 日期：2020.10.15 笔记类型：MarkDown笔记 error: "The element type “li” must be terminated by the matching end-tag “. (ENML_VALIDATION)” 做的还有bug啊。。 经过不断筛选测试，最后总结出一句话： onClick="*
SpringBoot报错：Caused by: org.xml.sax.SAXParseException: 不允许有匹配 "[xX][mM][lL]" 的处理指令目标。
qq_42727102的博客
01-15 1097
1.今天再用SpringBoot时报错：Caused by: org.xml.sax.SAXParseException: 不允许有匹配 “[xX][mM][lL]” 的处理指令目标。 2.原因是xml文件中不能有头部必须置顶，即不能有任何空格，否则就会报上面的错！ ...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值