PREHOOK: query: DESCRIBE FUNCTION reflect2 PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION reflect2 POSTHOOK: type: DESCFUNCTION reflect2(arg0,method[,arg1[,arg2..]]) calls method of arg0 with reflection PREHOOK: query: DESCRIBE FUNCTION EXTENDED reflect2 PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED reflect2 POSTHOOK: type: DESCFUNCTION reflect2(arg0,method[,arg1[,arg2..]]) calls method of arg0 with reflection Use this UDF to call Java methods by matching the argument signature PREHOOK: query: EXPLAIN EXTENDED SELECT key, reflect2(key, "byteValue"), reflect2(key, "shortValue"), reflect2(key, "intValue"), reflect2(key, "longValue"), reflect2(key, "floatValue"), reflect2(key, "doubleValue"), reflect2(key, "toString"), value, reflect2(value, "concat", "_concat"), reflect2(value, "contains", "86"), reflect2(value, "startsWith", "v"), reflect2(value, "endsWith", "6"), reflect2(value, "equals", "val_86"), reflect2(value, "equalsIgnoreCase", "VAL_86"), reflect2(value, "getBytes"), reflect2(value, "indexOf", "1"), reflect2(value, "lastIndexOf", "1"), reflect2(value, "replace", "val", "VALUE"), reflect2(value, "substring", 1), reflect2(value, "substring", 1, 5), reflect2(value, "toUpperCase"), reflect2(value, "trim"), ts, reflect2(ts, "getYear"), reflect2(ts, "getMonth"), reflect2(ts, "getDay"), reflect2(ts, "getHours"), reflect2(ts, "getMinutes"), reflect2(ts, "getSeconds"), reflect2(ts, "getTime") FROM (select cast(key as int) key, value, cast('2013-02-15 19:41:20' as timestamp) ts from src) a LIMIT 5 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT key, reflect2(key, "byteValue"), reflect2(key, "shortValue"), reflect2(key, "intValue"), reflect2(key, "longValue"), reflect2(key, "floatValue"), reflect2(key, "doubleValue"), reflect2(key, "toString"), value, reflect2(value, "concat", "_concat"), reflect2(value, "contains", "86"), reflect2(value, "startsWith", "v"), reflect2(value, "endsWith", "6"), reflect2(value, "equals", "val_86"), reflect2(value, "equalsIgnoreCase", "VAL_86"), reflect2(value, "getBytes"), reflect2(value, "indexOf", "1"), reflect2(value, "lastIndexOf", "1"), reflect2(value, "replace", "val", "VALUE"), reflect2(value, "substring", 1), reflect2(value, "substring", 1, 5), reflect2(value, "toUpperCase"), reflect2(value, "trim"), ts, reflect2(ts, "getYear"), reflect2(ts, "getMonth"), reflect2(ts, "getDay"), reflect2(ts, "getHours"), reflect2(ts, "getMinutes"), reflect2(ts, "getSeconds"), reflect2(ts, "getTime") FROM (select cast(key as int) key, value, cast('2013-02-15 19:41:20' as timestamp) ts from src) a LIMIT 5 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: TOK_QUERY TOK_FROM TOK_SUBQUERY TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME src TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_FUNCTION TOK_INT TOK_TABLE_OR_COL key key TOK_SELEXPR TOK_TABLE_OR_COL value TOK_SELEXPR TOK_FUNCTION TOK_TIMESTAMP '2013-02-15 19:41:20' ts a TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_TABLE_OR_COL key TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "byteValue" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "shortValue" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "intValue" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "longValue" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "floatValue" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "doubleValue" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL key "toString" TOK_SELEXPR TOK_TABLE_OR_COL value TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "concat" "_concat" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "contains" "86" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "startsWith" "v" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "endsWith" "6" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "equals" "val_86" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "equalsIgnoreCase" "VAL_86" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "getBytes" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "indexOf" "1" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "lastIndexOf" "1" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "replace" "val" "VALUE" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "substring" 1 TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "substring" 1 5 TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "toUpperCase" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL value "trim" TOK_SELEXPR TOK_TABLE_OR_COL ts TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getYear" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getMonth" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getDay" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getHours" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getMinutes" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getSeconds" TOK_SELEXPR TOK_FUNCTION reflect2 TOK_TABLE_OR_COL ts "getTime" TOK_LIMIT 5 STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Fetch Operator limit: 5 Processor Tree: TableScan alias: src Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Select Operator expressions: UDFToInteger(key) (type: int), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), reflect2(_col0,'byteValue') (type: tinyint), reflect2(_col0,'shortValue') (type: smallint), reflect2(_col0,'intValue') (type: int), reflect2(_col0,'longValue') (type: bigint), reflect2(_col0,'floatValue') (type: float), reflect2(_col0,'doubleValue') (type: double), reflect2(_col0,'toString') (type: string), _col1 (type: string), reflect2(_col1,'concat','_concat') (type: string), reflect2(_col1,'contains','86') (type: boolean), reflect2(_col1,'startsWith','v') (type: boolean), reflect2(_col1,'endsWith','6') (type: boolean), reflect2(_col1,'equals','val_86') (type: boolean), reflect2(_col1,'equalsIgnoreCase','VAL_86') (type: boolean), reflect2(_col1,'getBytes') (type: binary), reflect2(_col1,'indexOf','1') (type: int), reflect2(_col1,'lastIndexOf','1') (type: int), reflect2(_col1,'replace','val','VALUE') (type: string), reflect2(_col1,'substring',1) (type: string), reflect2(_col1,'substring',1,5) (type: string), reflect2(_col1,'toUpperCase') (type: string), reflect2(_col1,'trim') (type: string), 2013-02-15 19:41:20.0 (type: timestamp), 113 (type: int), 1 (type: int), 5 (type: int), 19 (type: int), 41 (type: int), 20 (type: int), 1360986080000 (type: bigint) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 5 Statistics: Num rows: 5 Data size: 50 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key, reflect2(key, "byteValue"), reflect2(key, "shortValue"), reflect2(key, "intValue"), reflect2(key, "longValue"), reflect2(key, "floatValue"), reflect2(key, "doubleValue"), reflect2(key, "toString"), value, reflect2(value, "concat", "_concat"), reflect2(value, "contains", "86"), reflect2(value, "startsWith", "v"), reflect2(value, "endsWith", "6"), reflect2(value, "equals", "val_86"), reflect2(value, "equalsIgnoreCase", "VAL_86"), reflect2(value, "getBytes"), reflect2(value, "indexOf", "1"), reflect2(value, "lastIndexOf", "1"), reflect2(value, "replace", "val", "VALUE"), reflect2(value, "substring", 1), reflect2(value, "substring", 1, 5), reflect2(value, "toUpperCase"), reflect2(value, "trim"), ts, reflect2(ts, "getYear"), reflect2(ts, "getMonth"), reflect2(ts, "getDay"), reflect2(ts, "getHours"), reflect2(ts, "getMinutes"), reflect2(ts, "getSeconds"), reflect2(ts, "getTime") FROM (select cast(key as int) key, value, cast('2013-02-15 19:41:20' as timestamp) ts from src) a LIMIT 5 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT key, reflect2(key, "byteValue"), reflect2(key, "shortValue"), reflect2(key, "intValue"), reflect2(key, "longValue"), reflect2(key, "floatValue"), reflect2(key, "doubleValue"), reflect2(key, "toString"), value, reflect2(value, "concat", "_concat"), reflect2(value, "contains", "86"), reflect2(value, "startsWith", "v"), reflect2(value, "endsWith", "6"), reflect2(value, "equals", "val_86"), reflect2(value, "equalsIgnoreCase", "VAL_86"), reflect2(value, "getBytes"), reflect2(value, "indexOf", "1"), reflect2(value, "lastIndexOf", "1"), reflect2(value, "replace", "val", "VALUE"), reflect2(value, "substring", 1), reflect2(value, "substring", 1, 5), reflect2(value, "toUpperCase"), reflect2(value, "trim"), ts, reflect2(ts, "getYear"), reflect2(ts, "getMonth"), reflect2(ts, "getDay"), reflect2(ts, "getHours"), reflect2(ts, "getMinutes"), reflect2(ts, "getSeconds"), reflect2(ts, "getTime") FROM (select cast(key as int) key, value, cast('2013-02-15 19:41:20' as timestamp) ts from src) a LIMIT 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 238 -18 238 238 238 238.0 238.0 238 val_238 val_238_concat false true false false false val_238 -1 -1 VALUE_238 al_238 al_2 VAL_238 val_238 2013-02-15 19:41:20 113 1 5 19 41 20 1360986080000 86 86 86 86 86 86.0 86.0 86 val_86 val_86_concat true true true true true val_86 -1 -1 VALUE_86 al_86 al_8 VAL_86 val_86 2013-02-15 19:41:20 113 1 5 19 41 20 1360986080000 311 55 311 311 311 311.0 311.0 311 val_311 val_311_concat false true false false false val_311 5 6 VALUE_311 al_311 al_3 VAL_311 val_311 2013-02-15 19:41:20 113 1 5 19 41 20 1360986080000 27 27 27 27 27 27.0 27.0 27 val_27 val_27_concat false true false false false val_27 -1 -1 VALUE_27 al_27 al_2 VAL_27 val_27 2013-02-15 19:41:20 113 1 5 19 41 20 1360986080000 165 -91 165 165 165 165.0 165.0 165 val_165 val_165_concat false true false false false val_165 4 4 VALUE_165 al_165 al_1 VAL_165 val_165 2013-02-15 19:41:20 113 1 5 19 41 20 1360986080000