PREHOOK: query: EXPLAIN CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX POSTHOOK: query: EXPLAIN CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX ABSTRACT SYNTAX TREE: (TOK_CREATEINDEX src_index 'COMPACT' (TOK_TABNAME src) (TOK_TABCOLNAME key) TOK_DEFERRED_REBUILDINDEX) STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 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: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@default__src_src_index__ POSTHOOK: query: ALTER INDEX src_index ON src REBUILD POSTHOOK: type: QUERY 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 x.* FROM default__src_src_index__ x ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@default__src_src_index__ PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-57-16_800_1708995700609026322/-mr-10000 POSTHOOK: query: SELECT x.* FROM default__src_src_index__ x ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@default__src_src_index__ POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-57-16_800_1708995700609026322/-mr-10000 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), ] 0 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [968,2632,2088] 10 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2846] 100 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5374,2156] 103 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3614,1484] 104 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4628,4114] 105 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4196] 11 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3170] 111 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1186] 113 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [920,3638] 114 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4280] 116 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3746] 118 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2780,2686] 119 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2064,4674,3332] 12 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4362,1720] 120 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2284,4830] 125 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4468,1344] 126 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5732] 128 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3896,988,208] 129 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2040,1094] 131 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2296] 133 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5164] 134 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2698,5294] 136 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5080] 137 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2552,1650] 138 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2734,1848,1472,3470] 143 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3226] 145 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [304] 146 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [232,5430] 149 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3422,1058] 15 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [386,2770] 150 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [150] 152 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [280,5648] 153 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [502] 155 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [932] 156 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2352] 157 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1140] 158 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2052] 160 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3274] 162 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [754] 163 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4650] 164 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4492,4408] 165 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2236,44] 166 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [418] 167 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5502,874,3686] 168 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3180] 169 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5754,1308,2588,4854] 17 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [910] 170 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1106] 172 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2018,5104] 174 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [682,598] 175 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5176,4150] 176 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1428,1556] 177 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3036] 178 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4938] 179 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2674,2006] 18 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5514,5340] 180 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1696] 181 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1742] 183 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5536] 186 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5466] 187 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2492,1416,4516] 189 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5188] 19 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2824] 190 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4244] 191 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3852,2192] 192 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1392] 193 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [514,126,4078] 194 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5684] 195 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3286,886] 196 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2410] 197 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2480,2108] 199 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [646,2180,4806] 2 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4004] 20 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1118] 200 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4698,5790] 201 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4384] 202 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3932] 203 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4314,944] 205 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1046,2272] 207 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5022,634] 208 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [670,1948,1272] 209 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3504,374] 213 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [220,1508] 214 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5116] 216 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1520,3650] 217 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4396,1860] 218 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3446] 219 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [478,3710] 221 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1580,1164] 222 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5720] 223 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3398,3758] 224 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [174,2892] 226 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3048] 228 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3458] 229 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3202,3956] 230 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1730,1936,4914,2260,3580] 233 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5140,3214] 235 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4046] 237 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4722,574] 238 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [0,2746] 239 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1496,3722] 24 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1972,4594] 241 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1662] 242 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2940,3012] 244 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3872] 247 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [718] 248 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4758] 249 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5034] 252 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [454] 255 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [68,4616] 256 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5272,3770] 257 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4208] 258 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4292] 26 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5284,2226] 260 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1764] 262 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4326] 263 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3782] 265 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [114,5046] 266 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [814] 27 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [34] 272 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1836,2976] 273 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2868,5524,162] 274 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3698] 275 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1638] 277 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4902,1260,2856,362] 278 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1544,80] 28 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5616] 280 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3992,1226] 281 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [350,5548] 282 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2468,2722] 283 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4022] 284 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1708] 285 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5478] 286 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1404] 287 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [490] 288 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2422,3840] 289 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1568] 291 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4582] 292 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [466] 296 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3626] 298 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5386,4456,2168] 30 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3494] 302 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1034] 305 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4782] 306 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2880] 307 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2812,5672] 308 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2388] 309 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [790,2904] 310 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4962] 311 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1000,1626,22] 315 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5594] 316 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3944,2576,1012] 317 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3104,4974] 318 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2504,1602,2516] 321 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4090,3308] 322 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3250,2096] 323 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4878] 325 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4890,862] 327 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2928,338,2248] 33 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3592] 331 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2988,4034] 332 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1614] 333 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1684,4986] 335 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4102] 336 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3148] 338 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [526] 339 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [956] 34 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3192] 341 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5406] 342 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3558,838] 344 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3674,5560] 345 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1082] 348 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5660,1882,1960,4338,5490] 35 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1238,4012,3138] 351 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4604] 353 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1812,5092] 356 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1284] 360 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4746] 362 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5454] 364 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2662] 365 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [802] 366 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4138] 367 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [850,3662] 368 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3602] 369 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [186,2564,2952] 37 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [328,5626] 373 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1824] 374 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [268] 375 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5212] 377 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [766] 378 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1152] 379 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5328] 382 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1320,4528] 384 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5316,5260,1788] 386 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1356] 389 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2916] 392 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2964] 393 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2132] 394 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [562] 395 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3116,2710] 396 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4372,706,3092] 397 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4558,778] 399 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [694,1296] 4 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1218] 400 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5778] 401 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [138,3000,3828,4268,5224] 402 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3080] 403 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5766,4162,406] 404 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1776,2318] 406 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [244,4220,4256,5152] 407 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5248] 409 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4232,56,2528] 41 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3388] 411 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1924] 413 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [610,2600] 414 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5696,4686] 417 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [730,4794,430] 418 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2204] 419 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2758] 42 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3298,2030] 421 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5236] 424 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4350,4504] 427 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1248] 429 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4842,256] 43 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2330] 430 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [442,1532,3320] 431 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4420,1994,4480] 432 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3920] 435 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2834] 436 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2340] 437 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1368] 438 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3884,4662,1070] 439 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4734,826] 44 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4068] 443 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4866] 444 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4818] 446 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [538] 448 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5636] 449 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3434] 452 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3024] 453 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3482] 454 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2144,4432,5200] 455 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [976] 457 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2446] 458 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3356,5442] 459 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [550,1450] 460 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5010] 462 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5350,5128] 463 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1982,3980] 466 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [658,1894,4126] 467 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3908] 468 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3526,4950,2120,2376] 469 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [292,3968,1380,5582,2364] 47 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1198] 470 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2540] 472 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3238] 475 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [898] 477 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5708] 478 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4444,4926] 479 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4770] 480 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4570,5058,3816] 481 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2434] 482 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [586] 483 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4174] 484 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [102] 485 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3734] 487 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3804] 489 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1128,1800,3344,742] 490 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2640] 491 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4710] 492 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5362,3410] 493 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4998] 494 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [622] 495 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [316] 496 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2076] 497 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3068] 498 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5418,3262,1332] 5 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4540,3864,3060] 51 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1462,2308] 53 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4186] 54 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1440] 57 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1024] 58 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3128,1906] 64 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3516] 65 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1592] 66 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [198] 67 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5306,1754] 69 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3570] 70 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3794,4640,4548] 72 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2792,1208] 74 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3548] 76 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3538,3378] 77 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2622] 78 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [3368] 8 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1916] 80 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [4058] 82 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [396] 83 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5070,1674] 84 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5606,1872] 85 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2612] 86 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [12] 87 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2652] 9 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5398] 90 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2802,5744,4304] 92 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [1176] 95 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2400,3160] 96 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2216] 97 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [5572,5802] 98 pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src/kv1.txt [2458,92] PREHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key=100 PREHOOK: type: QUERY PREHOOK: Input: default@default__src_src_index__ PREHOOK: Output: /tmp/index_result POSTHOOK: query: INSERT OVERWRITE DIRECTORY "/tmp/index_result" SELECT `_bucketname` , `_offsets` FROM default__src_src_index__ WHERE key=100 POSTHOOK: type: QUERY POSTHOOK: Input: default@default__src_src_index__ POSTHOOK: Output: /tmp/index_result 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 key, value FROM src WHERE key=100 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-57-23_391_6349847711419392472/-mr-10000 POSTHOOK: query: SELECT key, value FROM src WHERE key=100 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-57-23_391_6349847711419392472/-mr-10000 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), ] 100 val_100 100 val_100 PREHOOK: query: SELECT key, value FROM src WHERE key=100 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-57-26_783_2300938330753925321/-mr-10000 POSTHOOK: query: SELECT key, value FROM src WHERE key=100 ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-57-26_783_2300938330753925321/-mr-10000 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), ] 100 val_100 100 val_100 PREHOOK: query: DROP INDEX src_index on src PREHOOK: type: DROPINDEX POSTHOOK: query: DROP INDEX src_index on src POSTHOOK: type: DROPINDEX 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), ]