Home > OS >  Solution: why start the hive, such mistakes??
Solution: why start the hive, such mistakes??

Time:09-17

Hadoop @ Master:/usr/local/hive $./bin/hive [Fatal Error] hive - site. XML: 1:56: Invalid encoding name "utf-8" 19/04/27 19:36:47 Fatal conf. Configuration: Error parsing the conf file:/usr/local/hive/conf/hive - site. Xmlorg XML, sax. SAXParseException; SystemId: file:/usr/local/hive/conf/hive - site. XML; LineNumber: 1; ColumnNumber: 56. Invalid encoding name "UTF-8 ". at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:150) at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2480) at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2468) at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2536) at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2502) at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2405) at org.apache.hadoop.conf.Configuration.get(Configuration.java:1232) at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:2605) at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:2626) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:2696) at org.apache.hadoop.hive.conf.HiveConf. (HiveConf.java:2641) 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:637) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136)Exception in thread "main" java.lang.RuntimeException: org.xml.sax.SAXParseException; SystemId: file:/usr/local/hive/conf/hive - site. XML; LineNumber: 1; ColumnNumber: 56. Invalid encoding name "UTF-8 ". at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2645) at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2502) at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2405) at org.apache.hadoop.conf.Configuration.get(Configuration.java:1232) at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:2605) at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:2626) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:2696) at org.apache.hadoop.hive.conf.HiveConf. (HiveConf.java:2641) 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:637) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136)Caused by: org.xml.sax.SAXParseException; SystemId: file:/usr/local/hive/conf/hive - site. XML; LineNumber: 1; ColumnNumber: 56. Invalid encoding name "utf-8". At org.. Apache xerces. Parsers. The DOMParser. Parse (Unknown Source) at org.. Apache xerces. Jaxp. DocumentBuilderImpl. Parse (Unknown Source) at javax.mail.. XML parsers. DocumentBuilder. Parse (DocumentBuilder. Java: 150) at org.. Apache hadoop. Conf. Configuration. The parse (Configuration. Java: 2480) at org.. Apache hadoop. Conf. Configuration. The parse (Configuration. Java: 2468) at org.. Apache hadoop. Conf. Configuration. The loadResource (Configuration. Java: 2536)... 17 more

CodePudding user response:

Search on the net, but try to find the solution, is to/usr/local/hive/conf/hive - site. The XML configuration files of the first line & lt; ? The XML version="1.0" encoding="utf-8" standalone="no"?> The encoding="utf-8" in the standalone="no" delete will not be an error, use this configuration file I upload here, you to modify the test
<? The XML version="1.0" encoding="utf-8" standalone="no"?>
<? XML - stylesheet type="text/XSL" href="https://bbs.csdn.net/topics/configuration.xsl"?>


Javax.mail. Jdo. Option. ConnectionURL
JDBC: mysql://localhost: 3306/hive? CreateDatabaseIfNotExist=true
The JDBC connect string for a JDBC metastore


Javax.mail. Jdo. Option. ConnectionDriverName
Com. Mysql. JDBC. Driver
JDBC Driver class name for a metastore
  • Related