hive安装mysql安装_Hive与MySQL安装配置

四，修改配置hive-site.xml

主要修改点：

Javax.jdo.option.ConnectionURL

jdbc:MySQL://localhost:3306/hive?createDatabaseIfNotExist=true

JDBC connect string for a JDBC metastore

javax.jdo.option.ConnectionDriverName

com.mysql.jdbc.Driver

Driver class name for a JDBC metastore

javax.jdo.option.ConnectionUserName

hive

username to use against metastore database

javax.jdo.option.ConnectionPassword

111111

password to use against metastore database

好了推出hive，在起启动hive

创建表：

hive> create table hivetest(id int,name string);

OK

Time taken: 0.25 seconds

hive> show tables;

OK

hivetest

Time taken: 0.139 seconds

hive>

进入mysql:

mysql> SELECT *FROM TBLS\G;

*************************** 1. row ***************************

TBL_ID: 1

CREATE_TIME: 1357308618

DB_ID: 1

LAST_ACCESS_TIME: 0

OWNER: sina

RETENTION: 0

SD_ID: 1

TBL_NAME: hivetest

TBL_TYPE: MANAGED_TABLE

VIEW_EXPANDED_TEXT: NULL

VIEW_ORIGINAL_TEXT: NULL

*************************** 2. row ***************************

TBL_ID: 6

CREATE_TIME: 1357309812

DB_ID: 1

LAST_ACCESS_TIME: 0

OWNER: sina

RETENTION: 0

SD_ID: 6

TBL_NAME: zjz

TBL_TYPE: MANAGED_TABLE

VIEW_EXPANDED_TEXT: NULL

VIEW_ORIGINAL_TEXT: NULL

*************************** 3. row ***************************

TBL_ID: 7

CREATE_TIME: 1357311283

DB_ID: 1

LAST_ACCESS_TIME: 0

OWNER: sina

RETENTION: 0

SD_ID: 7

TBL_NAME: mytest

TBL_TYPE: EXTERNAL_TABLE

VIEW_EXPANDED_TEXT: NULL

VIEW_ORIGINAL_TEXT: NULL

3 rows in set (0.00 sec)

ERROR:

No query specified

在此之前建立了几个表：

hive> CREATE EXTERNAL TABLE MYTEST(num INT, name STRING)

> ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' //分隔符 ‘\t’

> ;

OK

Time taken: 0.142 seconds

hive> load data local inpath '/tmp/hive.txt' overwrite into table MYTEST;

Copying data from file:/tmp/hive.txt

Copying file: file:/tmp/hive.txt

Loading data to table default.mytest

Deleted hdfs://localhost:9000/user/hive/warehouse/mytest

OK

Time taken: 0.402 seconds

hive> SELECT * FROM MYTEST;

OK

NULL NULL

22 world

33 hive

Time taken: 0.089 seconds

hive>

再来看看hive.txt

sina@Ubuntu:~/hive/conf$ cat /tmp/hive.txt

11,hello

22 world

33 hive

sina@ubuntu:~/hive/conf$