hive中日志存放位置_hive日志默认存放在哪里

默认情况下，hive出错的日志会存放在/tmp/root/hive.log下面，其中root为使用hive的用户名称。如在hive中执行创建表语句的时候报错如下：

hive> create table t_searchword(

    >   search_time string,

    >   search_text string

    > )

    > row format delimited fields terminated by '|' stored as textfile;

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: java.net.ConnectException Call From node113/192.168.28.113 to node113:9000 failed on connection exception: java.net.ConnectException: Connection refused; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused)

hive> quit;

去查找/tmp/root/hive.log文件，发现里面记录了出错的详细信息，可以帮助你排查问题：

Caused by: MetaException(message:Got exception: java.net.ConnectException Call From node113/192.168.28.113 to node113:9000 failed on connection exception: java.net.ConnectException: Connectio

n refused; For more details see:  http://wiki.apache.org/hadoop/ConnectionRefused)

        at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:1213)

        at org.apache.hadoop.hive.metastore.Warehouse.isDir(Warehouse.java:476)

        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1392)

        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1449)

        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.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107)

        at com.sun.proxy.$Proxy7.create_table_with_environment_context(Unknown Source)

        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.create_table_with_environment_context(HiveMetaStoreClient.java:2051)

        at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.create_table_with_environment_context(SessionHiveMetaStoreClient.java:97)

        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:670)

        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:658)

        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.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:156)

        at com.sun.proxy.$Proxy8.createTable(Unknown Source)

        at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:714)

        ... 21 more