在mac os中在配置单元中创建表时失败，错误为LocalHost:9000连接失败

Question

hive>CREATE SCHEMA（如果不存在）inconv_seql；失败：执行错误，从org.apache.hadoop.hive.ql.exec.ddltask返回代码1。MetaException（消息：Got Exception:java.net.ConnectionException从user-macbook-air.local/127.0.0.1到localhost:9000的调用在连接异常：java.net.ConnectionException：connection Delection；有关详细信息，请参阅：http://wiki.apache.org/hadoop/ConnectionDelection）

Answer 1

localhost:9000 failed on connection exception: java.net.ConnectException: Connection refused;

以上错误是由于具有9000端口的hadoop恶魔没有在本地计算机上运行，

请按照以下步骤启动hadoop，然后启动hive。

1.检查hadoop正在运行，

hduser@ubuntu:~$ jps

hduser@ubuntu:~$ $HADOOP_HOME/sbin/start-all.sh

<property> 
<name>hive.metastore.db.type</name> 
<value>DERBY</value> 
<description> Expects one of [derby, oracle, mysql, mssql, postgres]. Type of database used by the metastore. Information schema &amp; JDBCStorageHandler depend on it. </description> 
</property> 
<property> 
<name>hive.metastore.warehouse.dir</name> 
<value>hdfs://localhost:8020/user/hive/warehouse</value> 
<description>location of default database for the warehouse</description> </property>

<configuration> 
<property> 
<name>hadoop.tmp.dir</name> 
<value>/usr/local/Cellar/hadoop/hdfs/tmp</value> 
<description>A base for other temporary directories</description> 
</property> 
<property> 
<name>fs.default.name</name> 
<value>hdfs://localhost:8020</value> 
</property> 
</configuration>