PREHOOK: query: DESCRIBE src_thrift PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE src_thrift POSTHOOK: type: DESCTABLE aint int from deserializer astring string from deserializer lint array from deserializer lstring array from deserializer lintstring array from deserializer mstringstring map from deserializer PREHOOK: query: EXPLAIN SELECT s1.aint, s2.lintstring FROM src_thrift s1 JOIN src_thrift s2 ON s1.aint = s2.aint PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT s1.aint, s2.lintstring FROM src_thrift s1 JOIN src_thrift s2 ON s1.aint = s2.aint POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src_thrift) s1) (TOK_TABREF (TOK_TABNAME src_thrift) s2) (= (. (TOK_TABLE_OR_COL s1) aint) (. (TOK_TABLE_OR_COL s2) aint)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) aint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) lintstring))))) 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: s1 TableScan alias: s1 Reduce Output Operator key expressions: expr: aint type: int sort order: + Map-reduce partition columns: expr: aint type: int tag: 0 value expressions: expr: aint type: int s2 TableScan alias: s2 Reduce Output Operator key expressions: expr: aint type: int sort order: + Map-reduce partition columns: expr: aint type: int tag: 1 value expressions: expr: lintstring type: array> Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {VALUE._col0} 1 {VALUE._col4} handleSkewJoin: false outputColumnNames: _col0, _col12 Select Operator expressions: expr: _col0 type: int expr: _col12 type: array> 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 s1.aint, s2.lintstring FROM src_thrift s1 JOIN src_thrift s2 ON s1.aint = s2.aint PREHOOK: type: QUERY PREHOOK: Input: default@src_thrift PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-53_268_1542402563118957350/-mr-10000 POSTHOOK: query: SELECT s1.aint, s2.lintstring FROM src_thrift s1 JOIN src_thrift s2 ON s1.aint = s2.aint POSTHOOK: type: QUERY POSTHOOK: Input: default@src_thrift POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-28-53_268_1542402563118957350/-mr-10000 -1952710710 [{"myint":25,"mystring":"125","underscore_int":5}] -1461153973 [{"myint":49,"mystring":"343","underscore_int":7}] -751827638 [{"myint":4,"mystring":"8","underscore_int":2}] -734328909 [{"myint":16,"mystring":"64","underscore_int":4}] 0 null 336964413 [{"myint":81,"mystring":"729","underscore_int":9}] 465985200 [{"myint":1,"mystring":"1","underscore_int":1}] 477111222 [{"myint":9,"mystring":"27","underscore_int":3}] 1244525190 [{"myint":36,"mystring":"216","underscore_int":6}] 1638581578 [{"myint":64,"mystring":"512","underscore_int":8}] 1712634731 [{"myint":0,"mystring":"0","underscore_int":0}]