PREHOOK: query: create table documents(contents string) stored as textfile PREHOOK: type: CREATETABLE POSTHOOK: query: create table documents(contents string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@documents PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/docurl.txt' INTO TABLE documents PREHOOK: type: LOAD PREHOOK: Output: default@documents POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/docurl.txt' INTO TABLE documents POSTHOOK: type: LOAD POSTHOOK: Output: default@documents PREHOOK: query: select url, count(1) FROM ( FROM documents MAP documents.contents USING 'java -cp ../build/ql/test/classes org.apache.hadoop.hive.scripts.extracturl' AS (url, count) ) subq group by url PREHOOK: type: QUERY PREHOOK: Input: default@documents PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-47-16_580_6937205098312645875/-mr-10000 POSTHOOK: query: select url, count(1) FROM ( FROM documents MAP documents.contents USING 'java -cp ../build/ql/test/classes org.apache.hadoop.hive.scripts.extracturl' AS (url, count) ) subq group by url POSTHOOK: type: QUERY POSTHOOK: Input: default@documents POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-47-16_580_6937205098312645875/-mr-10000 1uauniajqtunlsvadmxhlxvngxpqjuzbpzvdiwmzphmbaicduzkgxgtdeiunduosu.html 4 4uzsbtwvdypfitqfqdjosynqp.html 4