hive的嵌入模式报错

配置conf/hive-site.xml

原来的内容：

 

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
            <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
            <configuration>             
                    <property>
                    <name>javax.jdo.option.ConnectionURL</name>
                    <value>jdbc:derby:;databaseName=metastore_db;create=true</value>
                    </property>    

                    <property>
                    <name>javax.jdo.option.ConnectionDriverName</name>
                    <value>org.apache.derby.jdbc.EmbeddedDriver</value>
                    </property>    

                    <property>
                    <name>hive.metastore.local</name>
                    <value>true</value>
                    </property>    

                    <property>
                    <name>hive.metastore.warehouse.dir</name>
                    <value>file:///root/training/apache-hive-2.3.0-bin/warehouse</value>
                    </property>        
            </configuration>    

 

[Fatal Error] hive-site.xml:2:6: The processing instruction target matching "[xX][mM][lL]" is not allowed.
Exception in thread "main" java.lang.RuntimeException: org.xml.sax.SAXParseException; systemId: file:/root/training/apache-hive-2.3.0-bin/conf/hive-site.xml; lineNumber: 2; columnNumber: 6; The processing instruction target matching "[xX][mM][lL]" is not allowed.
        at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2348)
        at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2205)
        at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2112)
        at org.apache.hadoop.conf.Configuration.get(Configuration.java:1078)
        at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3901)
        at org.apache.hadoop.hive.conf.HiveConf.getVar(HiveConf.java:3970)
        at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:4057)
        at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:4005)
        at org.apache.hive.beeline.HiveSchemaTool.<init>(HiveSchemaTool.java:82)
        at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1117)
        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.main(RunJar.java:212)
Caused by: org.xml.sax.SAXParseException; systemId: file:/root/training/apache-hive-2.3.0-bin/conf/hive-site.xml; lineNumber: 2; columnNumber: 6; The processing instruction target matching "[xX][mM][lL]" is not allowed.
        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:2183)
        at org.apache.hadoop.conf.Configuration.parse(Configuration.java:2171)
        at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2239)
        ... 14 more
 

 

 

 

解决办法：修改conf/hive-site.xml为（即去掉头2行）：

<configuration>             
                    <property>
                    <name>javax.jdo.option.ConnectionURL</name>
                    <value>jdbc:derby:;databaseName=metastore_db;create=true</value>
                    </property>    

                    <property>
                    <name>javax.jdo.option.ConnectionDriverName</name>
                    <value>org.apache.derby.jdbc.EmbeddedDriver</value>
                    </property>    

                    <property>
                    <name>hive.metastore.local</name>
                    <value>true</value>
                    </property>    

                    <property>
                    <name>hive.metastore.warehouse.dir</name>
                    <value>file:///root/training/apache-hive-2.3.0-bin/warehouse</value>
                    </property>        
            </configuration>