PREHOOK: query: CREATE TEMPORARY FUNCTION example_group_concat AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleGroupConcat' PREHOOK: type: CREATEFUNCTION POSTHOOK: query: CREATE TEMPORARY FUNCTION example_group_concat AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleGroupConcat' POSTHOOK: type: CREATEFUNCTION PREHOOK: query: EXPLAIN SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")") FROM src GROUP BY substr(value,5,1) PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")") FROM src GROUP BY substr(value,5,1) POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5 1)) (TOK_SELEXPR (TOK_FUNCTION example_group_concat "(" (TOK_TABLE_OR_COL key) ":" (TOK_TABLE_OR_COL value) ")"))) (TOK_GROUPBY (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5 1)))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: src TableScan alias: src Select Operator expressions: expr: key type: string expr: value type: string outputColumnNames: key, value Group By Operator aggregations: expr: example_group_concat('(', key, ':', value, ')') bucketGroup: false keys: expr: substr(value, 5, 1) type: string mode: hash outputColumnNames: _col0, _col1 Reduce Output Operator key expressions: expr: _col0 type: string sort order: + Map-reduce partition columns: expr: _col0 type: string tag: -1 value expressions: expr: _col1 type: array Reduce Operator Tree: Group By Operator aggregations: expr: example_group_concat(VALUE._col0) bucketGroup: false keys: expr: KEY._col0 type: string mode: mergepartial outputColumnNames: _col0, _col1 Select Operator expressions: expr: _col0 type: string expr: _col1 type: string outputColumnNames: _col0, _col1 File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")") FROM src GROUP BY substr(value,5,1) PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/409446441/10000 POSTHOOK: query: SELECT substr(value,5,1), example_group_concat("(", key, ":", value, ")") FROM src GROUP BY substr(value,5,1) POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/409446441/10000 0 (0:val_0)(0:val_0)(0:val_0) 1 (100:val_100)(100:val_100)(103:val_103)(103:val_103)(104:val_104)(104:val_104)(105:val_105)(10:val_10)(111:val_111)(113:val_113)(113:val_113)(114:val_114)(116:val_116)(118:val_118)(118:val_118)(119:val_119)(119:val_119)(119:val_119)(11:val_11)(120:val_120)(120:val_120)(125:val_125)(125:val_125)(126:val_126)(128:val_128)(128:val_128)(128:val_128)(129:val_129)(129:val_129)(12:val_12)(12:val_12)(131:val_131)(133:val_133)(134:val_134)(134:val_134)(136:val_136)(137:val_137)(137:val_137)(138:val_138)(138:val_138)(138:val_138)(138:val_138)(143:val_143)(145:val_145)(146:val_146)(146:val_146)(149:val_149)(149:val_149)(150:val_150)(152:val_152)(152:val_152)(153:val_153)(155:val_155)(156:val_156)(157:val_157)(158:val_158)(15:val_15)(15:val_15)(160:val_160)(162:val_162)(163:val_163)(164:val_164)(164:val_164)(165:val_165)(165:val_165)(166:val_166)(167:val_167)(167:val_167)(167:val_167)(168:val_168)(169:val_169)(169:val_169)(169:val_169)(169:val_169)(170:val_170)(172:val_172)(172:val_172)(174:val_174)(174:val_174)(175:val_175)(175:val_175)(176:val_176)(176:val_176)(177:val_177)(178:val_178)(179:val_179)(179:val_179)(17:val_17)(180:val_180)(181:val_181)(183:val_183)(186:val_186)(187:val_187)(187:val_187)(187:val_187)(189:val_189)(18:val_18)(18:val_18)(190:val_190)(191:val_191)(191:val_191)(192:val_192)(193:val_193)(193:val_193)(193:val_193)(194:val_194)(195:val_195)(195:val_195)(196:val_196)(197:val_197)(197:val_197)(199:val_199)(199:val_199)(199:val_199)(19:val_19) 2 (200:val_200)(200:val_200)(201:val_201)(202:val_202)(203:val_203)(203:val_203)(205:val_205)(205:val_205)(207:val_207)(207:val_207)(208:val_208)(208:val_208)(208:val_208)(209:val_209)(209:val_209)(20:val_20)(213:val_213)(213:val_213)(214:val_214)(216:val_216)(216:val_216)(217:val_217)(217:val_217)(218:val_218)(219:val_219)(219:val_219)(221:val_221)(221:val_221)(222:val_222)(223:val_223)(223:val_223)(224:val_224)(224:val_224)(226:val_226)(228:val_228)(229:val_229)(229:val_229)(230:val_230)(230:val_230)(230:val_230)(230:val_230)(230:val_230)(233:val_233)(233:val_233)(235:val_235)(237:val_237)(237:val_237)(238:val_238)(238:val_238)(239:val_239)(239:val_239)(241:val_241)(242:val_242)(242:val_242)(244:val_244)(247:val_247)(248:val_248)(249:val_249)(24:val_24)(24:val_24)(252:val_252)(255:val_255)(255:val_255)(256:val_256)(256:val_256)(257:val_257)(258:val_258)(260:val_260)(262:val_262)(263:val_263)(265:val_265)(265:val_265)(266:val_266)(26:val_26)(26:val_26)(272:val_272)(272:val_272)(273:val_273)(273:val_273)(273:val_273)(274:val_274)(275:val_275)(277:val_277)(277:val_277)(277:val_277)(277:val_277)(278:val_278)(278:val_278)(27:val_27)(280:val_280)(280:val_280)(281:val_281)(281:val_281)(282:val_282)(282:val_282)(283:val_283)(284:val_284)(285:val_285)(286:val_286)(287:val_287)(288:val_288)(288:val_288)(289:val_289)(28:val_28)(291:val_291)(292:val_292)(296:val_296)(298:val_298)(298:val_298)(298:val_298)(2:val_2) 3 (302:val_302)(305:val_305)(306:val_306)(307:val_307)(307:val_307)(308:val_308)(309:val_309)(309:val_309)(30:val_30)(310:val_310)(311:val_311)(311:val_311)(311:val_311)(315:val_315)(316:val_316)(316:val_316)(316:val_316)(317:val_317)(317:val_317)(318:val_318)(318:val_318)(318:val_318)(321:val_321)(321:val_321)(322:val_322)(322:val_322)(323:val_323)(325:val_325)(325:val_325)(327:val_327)(327:val_327)(327:val_327)(331:val_331)(331:val_331)(332:val_332)(333:val_333)(333:val_333)(335:val_335)(336:val_336)(338:val_338)(339:val_339)(33:val_33)(341:val_341)(342:val_342)(342:val_342)(344:val_344)(344:val_344)(345:val_345)(348:val_348)(348:val_348)(348:val_348)(348:val_348)(348:val_348)(34:val_34)(351:val_351)(353:val_353)(353:val_353)(356:val_356)(35:val_35)(35:val_35)(35:val_35)(360:val_360)(362:val_362)(364:val_364)(365:val_365)(366:val_366)(367:val_367)(367:val_367)(368:val_368)(369:val_369)(369:val_369)(369:val_369)(373:val_373)(374:val_374)(375:val_375)(377:val_377)(378:val_378)(379:val_379)(37:val_37)(37:val_37)(382:val_382)(382:val_382)(384:val_384)(384:val_384)(384:val_384)(386:val_386)(389:val_389)(392:val_392)(393:val_393)(394:val_394)(395:val_395)(395:val_395)(396:val_396)(396:val_396)(396:val_396)(397:val_397)(397:val_397)(399:val_399)(399:val_399) 4 (400:val_400)(401:val_401)(401:val_401)(401:val_401)(401:val_401)(401:val_401)(402:val_402)(403:val_403)(403:val_403)(403:val_403)(404:val_404)(404:val_404)(406:val_406)(406:val_406)(406:val_406)(406:val_406)(407:val_407)(409:val_409)(409:val_409)(409:val_409)(411:val_411)(413:val_413)(413:val_413)(414:val_414)(414:val_414)(417:val_417)(417:val_417)(417:val_417)(418:val_418)(419:val_419)(41:val_41)(421:val_421)(424:val_424)(424:val_424)(427:val_427)(429:val_429)(429:val_429)(42:val_42)(42:val_42)(430:val_430)(430:val_430)(430:val_430)(431:val_431)(431:val_431)(431:val_431)(432:val_432)(435:val_435)(436:val_436)(437:val_437)(438:val_438)(438:val_438)(438:val_438)(439:val_439)(439:val_439)(43:val_43)(443:val_443)(444:val_444)(446:val_446)(448:val_448)(449:val_449)(44:val_44)(452:val_452)(453:val_453)(454:val_454)(454:val_454)(454:val_454)(455:val_455)(457:val_457)(458:val_458)(458:val_458)(459:val_459)(459:val_459)(460:val_460)(462:val_462)(462:val_462)(463:val_463)(463:val_463)(466:val_466)(466:val_466)(466:val_466)(467:val_467)(468:val_468)(468:val_468)(468:val_468)(468:val_468)(469:val_469)(469:val_469)(469:val_469)(469:val_469)(469:val_469)(470:val_470)(472:val_472)(475:val_475)(477:val_477)(478:val_478)(478:val_478)(479:val_479)(47:val_47)(480:val_480)(480:val_480)(480:val_480)(481:val_481)(482:val_482)(483:val_483)(484:val_484)(485:val_485)(487:val_487)(489:val_489)(489:val_489)(489:val_489)(489:val_489)(490:val_490)(491:val_491)(492:val_492)(492:val_492)(493:val_493)(494:val_494)(495:val_495)(496:val_496)(497:val_497)(498:val_498)(498:val_498)(498:val_498)(4:val_4) 5 (51:val_51)(51:val_51)(53:val_53)(54:val_54)(57:val_57)(58:val_58)(58:val_58)(5:val_5)(5:val_5)(5:val_5) 6 (64:val_64)(65:val_65)(66:val_66)(67:val_67)(67:val_67)(69:val_69) 7 (70:val_70)(70:val_70)(70:val_70)(72:val_72)(72:val_72)(74:val_74)(76:val_76)(76:val_76)(77:val_77)(78:val_78) 8 (80:val_80)(82:val_82)(83:val_83)(83:val_83)(84:val_84)(84:val_84)(85:val_85)(86:val_86)(87:val_87)(8:val_8) 9 (90:val_90)(90:val_90)(90:val_90)(92:val_92)(95:val_95)(95:val_95)(96:val_96)(97:val_97)(97:val_97)(98:val_98)(98:val_98)(9:val_9) PREHOOK: query: DROP TEMPORARY FUNCTION example_group_concat PREHOOK: type: DROPFUNCTION POSTHOOK: query: DROP TEMPORARY FUNCTION example_group_concat POSTHOOK: type: DROPFUNCTION