PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
POSTHOOK: query: ALTER INDEX src_index ON src REBUILD
POSTHOOK: type: ALTERINDEX_REBUILD
POSTHOOK: Input: default@src
POSTHOOK: Output: default@default__src_src_index__
POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT * FROM src WHERE key = '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-16_162_4530544379793726356/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key < '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-24_910_8422770577218536886/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key <= '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-33_506_4731041870462994974/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key > '8'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-42_116_5213638754635953384/-mr-10000
86	val_86
98	val_98
82	val_82
92	val_92
83	val_83
84	val_84
96	val_96
95	val_95
98	val_98
85	val_85
87	val_87
90	val_90
95	val_95
80	val_80
90	val_90
83	val_83
9	val_9
97	val_97
84	val_84
90	val_90
97	val_97
PREHOOK: query: SELECT * FROM src WHERE key >= '9'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-50_540_3532759530680718240/-mr-10000
98	val_98
92	val_92
96	val_96
95	val_95
98	val_98
90	val_90
95	val_95
90	val_90
9	val_9
97	val_97
90	val_90
97	val_97
PREHOOK: query: DROP INDEX src_index ON src
PREHOOK: type: DROPINDEX
PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
PREHOOK: query: SELECT * FROM src WHERE key = '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-07_718_5321452601706822472/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key < '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-16_481_5807706878522087187/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key <= '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-24_683_6289978315989311017/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key > '8'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-33_397_8866306423858815160/-mr-10000
86	val_86
98	val_98
82	val_82
92	val_92
83	val_83
84	val_84
96	val_96
95	val_95
98	val_98
85	val_85
87	val_87
90	val_90
95	val_95
80	val_80
90	val_90
83	val_83
9	val_9
97	val_97
84	val_84
90	val_90
97	val_97
PREHOOK: query: SELECT * FROM src WHERE key >= '9'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-42_150_3909923166888031983/-mr-10000
98	val_98
92	val_92
96	val_96
95	val_95
98	val_98
90	val_90
95	val_95
90	val_90
9	val_9
97	val_97
90	val_90
97	val_97
PREHOOK: query: DROP INDEX src_index ON src
PREHOOK: type: DROPINDEX
PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
PREHOOK: query: SELECT * FROM src WHERE key = '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-58_166_3678265151794926604/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key < '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-06_723_4428955348995805938/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key <= '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-15_252_6268745784357839984/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key > '8'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-23_915_5724065339829448949/-mr-10000
86	val_86
98	val_98
82	val_82
92	val_92
83	val_83
84	val_84
96	val_96
95	val_95
98	val_98
85	val_85
87	val_87
90	val_90
95	val_95
80	val_80
90	val_90
83	val_83
9	val_9
97	val_97
84	val_84
90	val_90
97	val_97
PREHOOK: query: SELECT * FROM src WHERE key >= '9'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-32_371_334426532692286168/-mr-10000
98	val_98
92	val_92
96	val_96
95	val_95
98	val_98
90	val_90
95	val_95
90	val_90
9	val_9
97	val_97
90	val_90
97	val_97
PREHOOK: query: DROP INDEX src_index ON src
PREHOOK: type: DROPINDEX
PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
PREHOOK: query: SELECT * FROM src WHERE key = '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-47_153_9199966558974802063/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key < '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-55_387_6708123102148378807/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key <= '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-03_712_8643764022963931262/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key > '8'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-12_217_4545846333420817182/-mr-10000
86	val_86
98	val_98
82	val_82
92	val_92
83	val_83
84	val_84
96	val_96
95	val_95
98	val_98
85	val_85
87	val_87
90	val_90
95	val_95
80	val_80
90	val_90
83	val_83
9	val_9
97	val_97
84	val_84
90	val_90
97	val_97
PREHOOK: query: SELECT * FROM src WHERE key >= '9'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-20_405_7128617548959801569/-mr-10000
98	val_98
92	val_92
96	val_96
95	val_95
98	val_98
90	val_90
95	val_95
90	val_90
9	val_9
97	val_97
90	val_90
97	val_97
PREHOOK: query: DROP INDEX src_index ON src
PREHOOK: type: DROPINDEX
PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
PREHOOK: query: SELECT * FROM src WHERE key = '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-35_592_7263189839927522587/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key < '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-44_027_7622604667919537891/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key <= '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-52_682_8498170072495224496/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key > '8'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-01_171_3483974250307194429/-mr-10000
86	val_86
98	val_98
82	val_82
92	val_92
83	val_83
84	val_84
96	val_96
95	val_95
98	val_98
85	val_85
87	val_87
90	val_90
95	val_95
80	val_80
90	val_90
83	val_83
9	val_9
97	val_97
84	val_84
90	val_90
97	val_97
PREHOOK: query: SELECT * FROM src WHERE key >= '9'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-09_626_7969856304834644252/-mr-10000
98	val_98
92	val_92
96	val_96
95	val_95
98	val_98
90	val_90
95	val_95
90	val_90
9	val_9
97	val_97
90	val_90
97	val_97
PREHOOK: query: DROP INDEX src_index ON src
PREHOOK: type: DROPINDEX
PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
PREHOOK: query: ALTER INDEX src_index ON src REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
PREHOOK: Input: default@src
PREHOOK: Output: default@default__src_src_index__
PREHOOK: query: SELECT * FROM src WHERE key = '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-24_952_7986831589488854044/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key < '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-33_434_6857699378136194430/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key <= '0'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-41_908_1172462155728735633/-mr-10000
0	val_0
0	val_0
0	val_0
PREHOOK: query: SELECT * FROM src WHERE key > '8'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-52_719_4367930844159597815/-mr-10000
86	val_86
98	val_98
82	val_82
92	val_92
83	val_83
84	val_84
96	val_96
95	val_95
98	val_98
85	val_85
87	val_87
90	val_90
95	val_95
80	val_80
90	val_90
83	val_83
9	val_9
97	val_97
84	val_84
90	val_90
97	val_97
PREHOOK: query: SELECT * FROM src WHERE key >= '9'
PREHOOK: type: QUERY
PREHOOK: Input: default@default__src_src_index__
PREHOOK: Input: default@src
PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-33-01_910_3573322999685212570/-mr-10000
98	val_98
92	val_92
96	val_96
95	val_95
98	val_98
90	val_90
95	val_95
90	val_90
9	val_9
97	val_97
90	val_90
97	val_97
PREHOOK: query: DROP INDEX src_index ON src
PREHOOK: type: DROPINDEX