hive mysql config

cphive-default.xml.template hive-site.xml

hive.metastore.local true

javax.jdo.option.ConnectionURL jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true

javax.jdo.option.ConnectionUserName hadoop

javax.jdo.option.ConnectionPassword hadoop

pt@iQuny:~/hadoop/hive-0.9.0-bin/conf$ hive
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/pt/hadoop/hive-0.9.0-bin/lib/hive-common-0.9.0.jar!/hive-log4j.properties
Hive history file=/tmp/pt/hive_job_log_pt_201208151502_733826926.txt
hive> show tables;

OK
Time taken: 6.132 seconds

hive> create table peter_test(user_id int,username string);

OK
Time taken: 0.454 seconds
hive> show tables;
OK
peter_test

Time taken: 0.247 seconds

show the tables created in db hive

mysql> show tables;
+-----------------+
| Tables_in_hive |
+-----------------+
| BUCKETING_COLS |
| CDS |
| COLUMNS_V2 |
| DATABASE_PARAMS |
| DBS |
| PARTITION_KEYS |
| SDS |
| SD_PARAMS |
| SEQUENCE_TABLE |
| SERDES |
| SERDE_PARAMS |
| SORT_COLS |
| TABLE_PARAMS |
| TBLS |
+-----------------+
14 rows in set (0.00 sec)