blob: 23caa4ac828201a859b3a4750b48782e0c6d50db [file] [log] [blame]
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