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