blob: 12dc067f645da1dc02cd6610db40e1efb66f8b96 [file]
PREHOOK: query: create table exim_department ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@exim_department
POSTHOOK: query: create table exim_department ( dep_id int comment "department id")
stored as textfile
tblproperties("creator"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@exim_department
PREHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@exim_department
POSTHOOK: query: load data local inpath "../../data/files/test.dat" into table exim_department
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@exim_department
#### A masked pattern was here ####
PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
PREHOOK: type: EXPORT
PREHOOK: Input: default@exim_department
#### A masked pattern was here ####
POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department'
POSTHOOK: type: EXPORT
POSTHOOK: Input: default@exim_department
#### A masked pattern was here ####
PREHOOK: query: drop table exim_department
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@exim_department
PREHOOK: Output: database:default
PREHOOK: Output: default@exim_department
POSTHOOK: query: drop table exim_department
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@exim_department
POSTHOOK: Output: database:default
POSTHOOK: Output: default@exim_department
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: create table exim_department ( dep_id int comment "department id")
stored by "org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler"
tblproperties("creator"="krishna")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:importer
PREHOOK: Output: importer@exim_department
POSTHOOK: query: create table exim_department ( dep_id int comment "department id")
stored by "org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler"
tblproperties("creator"="krishna")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:importer
POSTHOOK: Output: importer@exim_department
FAILED: SemanticException [Error 10121]: Export/Import cannot be done for a non-native table.