PREHOOK: query: create table exim_department ( dep_id int) stored as textfile PREHOOK: type: CREATETABLE POSTHOOK: query: create table exim_department ( dep_id int) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@exim_department PREHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department PREHOOK: type: LOAD PREHOOK: Output: default@exim_department POSTHOOK: query: load data local inpath "../data/files/test.dat" into table exim_department POSTHOOK: type: LOAD POSTHOOK: Output: default@exim_department PREHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department' PREHOOK: type: EXPORT PREHOOK: Input: default@exim_department PREHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department POSTHOOK: query: export table exim_department to 'ql/test/data/exports/exim_department' POSTHOOK: type: EXPORT POSTHOOK: Input: default@exim_department POSTHOOK: Output: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/test/data/exports/exim_department PREHOOK: query: drop table exim_department PREHOOK: type: DROPTABLE PREHOOK: Input: default@exim_department PREHOOK: Output: default@exim_department POSTHOOK: query: drop table exim_department POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@exim_department POSTHOOK: Output: default@exim_department PREHOOK: query: create database importer PREHOOK: type: CREATEDATABASE POSTHOOK: query: create database importer POSTHOOK: type: CREATEDATABASE PREHOOK: query: use importer PREHOOK: type: SWITCHDATABASE POSTHOOK: query: use importer POSTHOOK: type: SWITCHDATABASE PREHOOK: query: grant Create on database importer to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE POSTHOOK: query: grant Create on database importer to user hive_test_user POSTHOOK: type: GRANT_PRIVILEGE PREHOOK: query: import from 'ql/test/data/exports/exim_department' PREHOOK: type: IMPORT POSTHOOK: query: import from 'ql/test/data/exports/exim_department' POSTHOOK: type: IMPORT POSTHOOK: Output: importer@exim_department PREHOOK: query: select * from exim_department PREHOOK: type: QUERY PREHOOK: Input: importer@exim_department PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-33_608_3825518513638087885/-mr-10000 POSTHOOK: query: select * from exim_department POSTHOOK: type: QUERY POSTHOOK: Input: importer@exim_department POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-06-33_608_3825518513638087885/-mr-10000 1 2 3 4 5 6 PREHOOK: query: drop table exim_department PREHOOK: type: DROPTABLE PREHOOK: Input: importer@exim_department PREHOOK: Output: importer@exim_department POSTHOOK: query: drop table exim_department POSTHOOK: type: DROPTABLE POSTHOOK: Input: importer@exim_department POSTHOOK: Output: importer@exim_department PREHOOK: query: drop database importer PREHOOK: type: DROPDATABASE POSTHOOK: query: drop database importer POSTHOOK: type: DROPDATABASE