hive启动后相关操作

   hadoop@ubuntu118:~$ $HIVE_HOME/bin/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/hadoop/hive-0.8.1-bin/lib/hive-common-0.8.1.jar!/hive-log4j.properties  
   Hive history file=/tmp/hadoop/hive_job_log_hadoop_201208291807_723168203.txt  
   hive> show tables;  
   OK  
   Time taken: 4.076 seconds  
   hive> create table tt(id int, name string) row format delimited fields terminated by '\t';  
   OK  
   Time taken: 0.193 seconds  
   hive> show tables;  
   OK  
   tt  
   Time taken: 0.082 seconds  
   hive> select name from tt;  
   Total MapReduce jobs = 1  
   Launching Job 1 out of 1  
   Number of reduce tasks is set to 0 since there's no reduce operator  
   Starting Job = job_201208291803_0001, Tracking URL = http://ubuntu118:50030/jobdetails.jsp?jobid=job_201208291803_0001  
   Kill Command = /home/hadoop/hadoop-1.0.2/libexec/../bin/hadoop job  -Dmapred.job.tracker=192.168.0.118:9001 -kill job_201208291803_0001  
   Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0  
   2012-08-29 18:31:00,383 Stage-1 map = 0%,  reduce = 0%  
   2012-08-29 18:31:06,404 Stage-1 map = 100%,  reduce = 100%  
   Ended Job = job_201208291803_0001  
   MapReduce Jobs Launched:   
   Job 0:  HDFS Read: 0 HDFS Write: 0 SUCESS  
   Total MapReduce CPU Time Spent: 0 msec  
   OK  
   Time taken: 18.233 seconds  
   hive> dfs -ls /user/hive/warehouse/;  
   Found 1 items  
   drwxr-xr-x   - hadoop supergroup          0 2012-08-29 18:30 /user/hive/warehouse/tt  
   hive> dfs -ls /user/hive/warehouse/;  
   Found 1 items  
   drwxr-xr-x   - hadoop supergroup          0 2012-08-29 18:30 /user/hive/warehouse/tt  
   hive> exit;  
   hadoop@ubuntu118:~$ mysql -uroot -p  
   Enter password:   
   Welcome to the MySQL monitor.  Commands end with ; or \g.  
   Your MySQL connection id is 38  
   Server version: 5.5.24-0ubuntu0.12.04.1 (Ubuntu)  
   Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.  
   Oracle is a registered trademark of Oracle Corporation and/or its  
   affiliates. Other names may be trademarks of their respective  
   owners.  
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.  
   mysql> use hive;  
   Reading table information for completion of table and column names  
   You can turn off this feature to get a quicker startup with -A  
   Database changed  
   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            |  
   | t               |  
   +-----------------+  
   15 rows in set (0.00 sec)  
   mysql> select * from TBLS;  
   +--------+-------------+-------+------------------+--------+-----------+-------+----------+---------------+--------------------+--------------------+  
   | TBL_ID | CREATE_TIME | DB_ID | LAST_ACCESS_TIME | OWNER  | RETENTION | SD_ID | TBL_NAME | TBL_TYPE      | VIEW_EXPANDED_TEXT | VIEW_ORIGINAL_TEXT |  
   +--------+-------------+-------+------------------+--------+-----------+-------+----------+---------------+--------------------+--------------------+  
   |      1 |  1346290224 |     1 |                0 | hadoop |         0 |     1 | tt       | MANAGED_TABLE | NULL               | NULL               |  
   +--------+-------------+-------+------------------+--------+-----------+-------+----------+---------------+--------------------+--------------------+  
   1 row in set (0.00 sec)