hive问题汇总

hive 启动问题记录 及解决方法

http://blog.csdn.net/jim110/article/details/44907745

Hive metastore三种配置方式

http://blog.csdn.net/reesun/article/details/8556078

问题：

WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect.  Use hive.hmshandler.retry.* instead

原因：value 设置空值

<property>
  <name>hive.metastore.uris</name>
  <value>thrift://Master:9083</value>
  <description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
</property>

16/08/17 17:28:17 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.16/08/17 17:28:17 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect.  Use hive.hmshandler.retry.* instead

<span style="font-family: Arial, Helvetica, sans-serif;">hive> show databases;</span>

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out)hive> 

解决

<property>
  <name>hive.metastore.uris</name>
  <value></value>
  <description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
</property>