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