PREHOOK: query: CREATE DATABASE db1
PREHOOK: type: CREATEDATABASE
POSTHOOK: query: CREATE DATABASE db1
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: DESCRIBE DATABASE EXTENDED db1
PREHOOK: type: DESCDATABASE
POSTHOOK: query: DESCRIBE DATABASE EXTENDED db1
POSTHOOK: type: DESCDATABASE
db1		pfile:/Users/carl/Work/repos/hive3/build/ql/test/data/warehouse/db1.db
PREHOOK: query: USE db1
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: USE db1
POSTHOOK: type: SWITCHDATABASE
PREHOOK: query: CREATE TABLE table_db1 (name STRING, value INT)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE table_db1 (name STRING, value INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: db1@table_db1
PREHOOK: query: DESCRIBE FORMATTED table_db1
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED table_db1
POSTHOOK: type: DESCTABLE
# col_name            	data_type           	comment             
	 	 
name                	string              	None                
value               	int                 	None                
	 	 
# Detailed Table Information	 	 
Database:           	db1                 	 
Owner:              	carl
CreateTime:         	Tue Jul 19 16:34:59 PDT 2011
LastAccessTime:     	UNKNOWN             	 
Protect Mode:       	None                	 
Retention:          	0                   	 
Location:           	pfile:/Users/carl/Work/repos/hive3/build/ql/test/data/warehouse/db1.db/table_db1
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
	transient_lastDdlTime	1311118499
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
table_db1
PREHOOK: query: CREATE DATABASE db2
COMMENT 'database 2'
LOCATION 'pfile:///Users/carl/Work/repos/hive3/build/ql/test/data/warehouse/db2'
PREHOOK: type: CREATEDATABASE
POSTHOOK: query: CREATE DATABASE db2
COMMENT 'database 2'
LOCATION 'pfile:///Users/carl/Work/repos/hive3/build/ql/test/data/warehouse/db2'
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: DESCRIBE DATABASE EXTENDED db2
PREHOOK: type: DESCDATABASE
POSTHOOK: query: DESCRIBE DATABASE EXTENDED db2
POSTHOOK: type: DESCDATABASE
db2	database 2	pfile:/Users/carl/Work/repos/hive3/build/ql/test/data/warehouse/db2
PREHOOK: query: USE db2
PREHOOK: type: SWITCHDATABASE
POSTHOOK: query: USE db2
POSTHOOK: type: SWITCHDATABASE
PREHOOK: query: CREATE TABLE table_db2 (name STRING, value INT)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE table_db2 (name STRING, value INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: db2@table_db2
PREHOOK: query: DESCRIBE FORMATTED table_db2
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE FORMATTED table_db2
POSTHOOK: type: DESCTABLE
# col_name            	data_type           	comment             
	 	 
name                	string              	None                
value               	int                 	None                
	 	 
# Detailed Table Information	 	 
Database:           	db2                 	 
Owner:              	carl
CreateTime:         	Tue Jul 19 16:35:00 PDT 2011
LastAccessTime:     	UNKNOWN             	 
Protect Mode:       	None                	 
Retention:          	0                   	 
Location:           	pfile:/Users/carl/Work/repos/hive3/build/ql/test/data/warehouse/db2/table_db2
Table Type:         	MANAGED_TABLE       	 
Table Parameters:	 	 
	transient_lastDdlTime	1311118500
	 	 
# Storage Information	 	 
SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe	 
InputFormat:        	org.apache.hadoop.mapred.TextInputFormat	 
OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat	 
Compressed:         	No                  	 
Num Buckets:        	-1                  	 
Bucket Columns:     	[]                  	 
Sort Columns:       	[]                  	 
Storage Desc Params:	 	 
	serialization.format	1                   
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
POSTHOOK: query: SHOW TABLES
POSTHOOK: type: SHOWTABLES
table_db2