| 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 |
| FAILED: SemanticException [Error 10006]: Partition not found - Specified partition not found in import directory |