blob: f34f81b5a0c9537c9c849659269388dc21c0d551 [file] [log] [blame]
PREHOOK: query: create table exim_employee_n9 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@exim_employee_n9
POSTHOOK: query: create table exim_employee_n9 ( emp_id int comment "employee id")
comment "employee table"
partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
stored as textfile
tblproperties("creator"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@exim_employee_n9
#### A masked pattern was here ####
PREHOOK: query: export table exim_employee_n9 to 'ql/test/data/exports/exim_employee'
PREHOOK: type: EXPORT
#### A masked pattern was here ####
POSTHOOK: query: export table exim_employee_n9 to 'ql/test/data/exports/exim_employee'
POSTHOOK: type: EXPORT
#### A masked pattern was here ####
PREHOOK: query: drop table exim_employee_n9
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@exim_employee_n9
PREHOOK: Output: default@exim_employee_n9
POSTHOOK: query: drop table exim_employee_n9
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@exim_employee_n9
POSTHOOK: Output: default@exim_employee_n9
PREHOOK: query: create database importer
PREHOOK: type: CREATEDATABASE
PREHOOK: Output: database:importer
POSTHOOK: query: create database importer
POSTHOOK: type: CREATEDATABASE
POSTHOOK: Output: database:importer
PREHOOK: query: use importer
PREHOOK: type: SWITCHDATABASE
PREHOOK: Input: database:importer
POSTHOOK: query: use importer
POSTHOOK: type: SWITCHDATABASE
POSTHOOK: Input: database:importer
PREHOOK: query: import from 'ql/test/data/exports/exim_employee'
PREHOOK: type: IMPORT
#### A masked pattern was here ####
PREHOOK: Output: database:importer
POSTHOOK: query: import from 'ql/test/data/exports/exim_employee'
POSTHOOK: type: IMPORT
#### A masked pattern was here ####
POSTHOOK: Output: database:importer
POSTHOOK: Output: importer@exim_employee_n9
PREHOOK: query: describe extended exim_employee_n9
PREHOOK: type: DESCTABLE
PREHOOK: Input: importer@exim_employee_n9
POSTHOOK: query: describe extended exim_employee_n9
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: importer@exim_employee_n9
emp_id int employee id
emp_country string two char iso code
emp_state string free text
# Partition Information
# col_name data_type comment
emp_country string two char iso code
emp_state string free text
#### A masked pattern was here ####
PREHOOK: query: show table extended like exim_employee_n9
PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: show table extended like exim_employee_n9
POSTHOOK: type: SHOW_TABLESTATUS
tableName:exim_employee_n9
#### A masked pattern was here ####
inputformat:org.apache.hadoop.mapred.TextInputFormat
outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
columns:struct columns { i32 emp_id}
partitioned:true
partitionColumns:struct partition_columns { string emp_country, string emp_state}
#### A masked pattern was here ####
PREHOOK: query: select * from exim_employee_n9
PREHOOK: type: QUERY
PREHOOK: Input: importer@exim_employee_n9
#### A masked pattern was here ####
POSTHOOK: query: select * from exim_employee_n9
POSTHOOK: type: QUERY
POSTHOOK: Input: importer@exim_employee_n9
#### A masked pattern was here ####
PREHOOK: query: drop table exim_employee_n9
PREHOOK: type: DROPTABLE
PREHOOK: Input: importer@exim_employee_n9
PREHOOK: Output: importer@exim_employee_n9
POSTHOOK: query: drop table exim_employee_n9
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: importer@exim_employee_n9
POSTHOOK: Output: importer@exim_employee_n9
PREHOOK: query: drop database importer
PREHOOK: type: DROPDATABASE
PREHOOK: Input: database:importer
PREHOOK: Output: database:importer
POSTHOOK: query: drop database importer
POSTHOOK: type: DROPDATABASE
POSTHOOK: Input: database:importer
POSTHOOK: Output: database:importer