hive报错，高手帮看看

zhaopingzi

-bash-3.2$ hive
13/12/10 17:28:23 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.

1. 
   
2. ....
   
3. <property>
   
4.   <name>hive.metastore.uris</name>
   
5.   <value></value>
   
6.   <description>Thrift uri for the remote metastore. Used by metastore client to connect to remote metastore.</description>
   
7. </property>
   
8. 
   
9. <property>
   
10.   <name>javax.jdo.option.ConnectionURL</name>
    
11.   <value>jdbc:mysql://192.168.7.81:3306/hive?createDatabaseIfNotExist=true</value>
    
12.   <description>JDBC connect string for a JDBC metastore</description>
    
13. </property>
    
14. 
    
15. <property>
    
16.   <name>javax.jdo.option.ConnectionDriverName</name>
    
17.   <value>com.mysql.jdbc.Driver</value>
    
18. 
    
19. 
    
20. 
    
21. 
    
22. <property>
    
23.   <name>javax.jdo.option.ConnectionUserName</name>
    
24.   <value>hadoop</value>
    
25.   <description>username to use against metastore database</description>
    
26. </property>
    
27. 
    
28. 
    
29. 
    
30. 
    
31. <property>
    
32.   <name>javax.jdo.option.ConnectionPassword</name>
    
33.   <value>hadoop</value>
    
34.   <description>password to use against metastore database</description>
    
35. </property>
    
36. ....
    
37. <property>
    
38.   <name>hive.metastore.local</name>
    
39.   <value>true</value>
    
40. </property>
    
41. 
    
42. ...
    

复制代码

mysql已经装好，mysql-connector-java-5.1.27-bin.jar也已经装好

-bash-3.2$ mysql -uhadoop -phadoop
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 60
Server version: 5.5.34 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

send_linux

zhaopingzi 发表于 2013-12-10 17:31
-bash-3.2$ hive
13/12/10 17:28:23 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metas ...

兄弟，这个问题，发到nosql版面稍微好点吧？

这里都是linux的人啊

zhaopingzi

回复 2# send_linux


    恩知道了。不过搞hadoop的都是搞linux的，这个问题解决了：

通过修改

1. 
   
2. <property>
   
3.   <name>hive.metastore.schema.verification</name>
   
4.   <value>false</value>
   
5.    <description>
   
6. </property>
   

复制代码