PREHOOK: query: create table exim_employee ( 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 POSTHOOK: query: create table exim_employee ( 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 PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="in", emp_state="tn") PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@exim_employee POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="in", emp_state="tn") POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@exim_employee POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=tn PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="in", emp_state="ka") PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@exim_employee POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="in", emp_state="ka") POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@exim_employee POSTHOOK: Output: default@exim_employee@emp_country=in/emp_state=ka PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="us", emp_state="tn") PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@exim_employee POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="us", emp_state="tn") POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@exim_employee POSTHOOK: Output: default@exim_employee@emp_country=us/emp_state=tn PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="us", emp_state="ka") PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@exim_employee POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_employee partition (emp_country="us", emp_state="ka") POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@exim_employee POSTHOOK: Output: default@exim_employee@emp_country=us/emp_state=ka #### A masked pattern was here #### PREHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee' PREHOOK: type: EXPORT PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka PREHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka PREHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn #### A masked pattern was here #### POSTHOOK: query: export table exim_employee to 'ql/test/data/exports/exim_employee' POSTHOOK: type: EXPORT POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=ka POSTHOOK: Input: default@exim_employee@emp_country=in/emp_state=tn POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=ka POSTHOOK: Input: default@exim_employee@emp_country=us/emp_state=tn #### A masked pattern was here #### PREHOOK: query: drop table exim_employee PREHOOK: type: DROPTABLE PREHOOK: Input: default@exim_employee PREHOOK: Output: default@exim_employee POSTHOOK: query: drop table exim_employee POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@exim_employee POSTHOOK: Output: default@exim_employee 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 #### A masked pattern was here #### PREHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") from 'ql/test/data/exports/exim_employee' location 'ql/test/data/tablestore/exim_employee' PREHOOK: type: IMPORT #### A masked pattern was here #### POSTHOOK: query: import table exim_employee partition (emp_country="us", emp_state="tn") from 'ql/test/data/exports/exim_employee' location 'ql/test/data/tablestore/exim_employee' POSTHOOK: type: IMPORT #### A masked pattern was here #### POSTHOOK: Output: importer@exim_employee POSTHOOK: Output: importer@exim_employee@emp_country=us/emp_state=tn PREHOOK: query: describe extended exim_employee PREHOOK: type: DESCTABLE PREHOOK: Input: importer@exim_employee POSTHOOK: query: describe extended exim_employee POSTHOOK: type: DESCTABLE POSTHOOK: Input: importer@exim_employee 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 PREHOOK: type: SHOW_TABLESTATUS POSTHOOK: query: show table extended like exim_employee POSTHOOK: type: SHOW_TABLESTATUS tableName:exim_employee #### 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} totalNumberFiles:1 totalFileSize:11 maxFileSize:11 minFileSize:11 #### A masked pattern was here #### PREHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn") PREHOOK: type: SHOW_TABLESTATUS POSTHOOK: query: show table extended like exim_employee partition (emp_country="us", emp_state="tn") POSTHOOK: type: SHOW_TABLESTATUS tableName:exim_employee #### 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} totalNumberFiles:1 totalFileSize:11 maxFileSize:11 minFileSize:11 #### A masked pattern was here #### #### A masked pattern was here #### PREHOOK: query: select * from exim_employee PREHOOK: type: QUERY PREHOOK: Input: importer@exim_employee PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn #### A masked pattern was here #### POSTHOOK: query: select * from exim_employee POSTHOOK: type: QUERY POSTHOOK: Input: importer@exim_employee POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn #### A masked pattern was here #### 1 us tn 2 us tn 3 us tn 4 us tn 5 us tn 6 us tn #### A masked pattern was here #### PREHOOK: query: select * from exim_employee PREHOOK: type: QUERY PREHOOK: Input: importer@exim_employee PREHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn #### A masked pattern was here #### POSTHOOK: query: select * from exim_employee POSTHOOK: type: QUERY POSTHOOK: Input: importer@exim_employee POSTHOOK: Input: importer@exim_employee@emp_country=us/emp_state=tn #### A masked pattern was here #### PREHOOK: query: drop table exim_employee PREHOOK: type: DROPTABLE PREHOOK: Input: importer@exim_employee PREHOOK: Output: importer@exim_employee POSTHOOK: query: drop table exim_employee POSTHOOK: type: DROPTABLE POSTHOOK: Input: importer@exim_employee POSTHOOK: Output: importer@exim_employee 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