使用MySQL作为Hive的Metastore
使用MySQL作为Hive的Metastore
前提是成功安装了HIVE和MYSQL
在hive-site.xml中添加如下内容,指定METASTORE的地址以及连接方式
[gpadmin1@hadoop5 hive-0.6.0]$ bin/hiveHive history file=/tmp/gpadmin1/hive_job_log_gpadmin1_201106081130_544334815.txthive> show table; FAILED: Parse Error: line 0:-1 mismatched input '<EOF>' expecting EXTENDED in show statementhive> show tables;OKTime taken: 5.173 secondshive> CREATE TABLE u_tmp1 (id1 INT, > id2 int > ) > ROW FORMAT DELIMITED > FIELDS TERMINATED BY ',';OKTime taken: 0.266 secondshive> show tables; OKu_tmp1Time taken: 0.197 secondshive>