Index: ql/src/test/results/clientpositive/join23.q.out =================================================================== --- ql/src/test/results/clientpositive/join23.q.out (revision 768676) +++ ql/src/test/results/clientpositive/join23.q.out (working copy) @@ -1,8 +1,9 @@ ABSTRACT SYNTAX TREE: - (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (< (. (TOK_TABLE_OR_COL src1) key) 10) (< (. (TOK_TABLE_OR_COL src2) key) 10))))) + (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF src src1) (TOK_TABREF src src2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (< (. (TOK_TABLE_OR_COL src1) key) 10) (< (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value))))) STAGE DEPENDENCIES: Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 Stage-0 is a root stage STAGE PLANS: @@ -52,111 +53,146 @@ compressed: false GlobalTableId: 0 table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + name: binary_table + Stage: Stage-2 + Map Reduce + Alias -> Map Operator Tree: + /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/197273567/372508188.10002 + Reduce Output Operator + key expressions: + expr: 0 + type: string + expr: 1 + type: string + expr: 2 + type: string + expr: 3 + type: string + sort order: ++++ + tag: -1 + value expressions: + expr: 0 + type: string + expr: 1 + type: string + expr: 2 + type: string + expr: 3 + type: string + Reduce Operator Tree: + Extract + 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 -5 val_5 2 val_2 -5 val_5 5 val_5 -5 val_5 9 val_9 -5 val_5 4 val_4 -5 val_5 8 val_8 -5 val_5 0 val_0 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 0 val_0 -5 val_5 0 val_0 -0 val_0 2 val_2 -0 val_0 5 val_5 -0 val_0 9 val_9 -0 val_0 4 val_4 -0 val_0 8 val_8 0 val_0 0 val_0 -0 val_0 5 val_5 -0 val_0 5 val_5 0 val_0 0 val_0 0 val_0 0 val_0 -8 val_8 2 val_2 -8 val_8 5 val_5 -8 val_8 9 val_9 -8 val_8 4 val_4 -8 val_8 8 val_8 -8 val_8 0 val_0 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 0 val_0 -8 val_8 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 +0 val_0 0 val_0 0 val_0 2 val_2 -0 val_0 5 val_5 -0 val_0 9 val_9 +0 val_0 2 val_2 +0 val_0 2 val_2 0 val_0 4 val_4 -0 val_0 8 val_8 -0 val_0 0 val_0 +0 val_0 4 val_4 +0 val_0 4 val_4 0 val_0 5 val_5 0 val_0 5 val_5 -0 val_0 0 val_0 -0 val_0 0 val_0 +0 val_0 5 val_5 +0 val_0 5 val_5 +0 val_0 5 val_5 +0 val_0 5 val_5 +0 val_0 5 val_5 +0 val_0 5 val_5 +0 val_0 5 val_5 +0 val_0 8 val_8 +0 val_0 8 val_8 +0 val_0 8 val_8 +0 val_0 9 val_9 +0 val_0 9 val_9 +0 val_0 9 val_9 +2 val_2 0 val_0 +2 val_2 0 val_0 +2 val_2 0 val_0 2 val_2 2 val_2 -2 val_2 5 val_5 -2 val_2 9 val_9 2 val_2 4 val_4 -2 val_2 8 val_8 -2 val_2 0 val_0 2 val_2 5 val_5 2 val_2 5 val_5 -2 val_2 0 val_0 -2 val_2 0 val_0 -5 val_5 2 val_2 -5 val_5 5 val_5 -5 val_5 9 val_9 -5 val_5 4 val_4 -5 val_5 8 val_8 +2 val_2 5 val_5 +2 val_2 8 val_8 +2 val_2 9 val_9 +4 val_4 0 val_0 +4 val_4 0 val_0 +4 val_4 0 val_0 +4 val_4 2 val_2 +4 val_4 4 val_4 +4 val_4 5 val_5 +4 val_4 5 val_5 +4 val_4 5 val_5 +4 val_4 8 val_8 +4 val_4 9 val_9 5 val_5 0 val_0 -5 val_5 5 val_5 -5 val_5 5 val_5 5 val_5 0 val_0 5 val_5 0 val_0 +5 val_5 0 val_0 +5 val_5 0 val_0 +5 val_5 0 val_0 +5 val_5 0 val_0 +5 val_5 0 val_0 +5 val_5 0 val_0 5 val_5 2 val_2 -5 val_5 5 val_5 -5 val_5 9 val_9 +5 val_5 2 val_2 +5 val_5 2 val_2 5 val_5 4 val_4 -5 val_5 8 val_8 -5 val_5 0 val_0 +5 val_5 4 val_4 +5 val_5 4 val_4 5 val_5 5 val_5 5 val_5 5 val_5 -5 val_5 0 val_0 -5 val_5 0 val_0 -0 val_0 2 val_2 -0 val_0 5 val_5 -0 val_0 9 val_9 -0 val_0 4 val_4 -0 val_0 8 val_8 -0 val_0 0 val_0 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 0 val_0 -0 val_0 0 val_0 +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 5 val_5 +5 val_5 8 val_8 +5 val_5 8 val_8 +5 val_5 8 val_8 +5 val_5 9 val_9 +5 val_5 9 val_9 +5 val_5 9 val_9 +8 val_8 0 val_0 +8 val_8 0 val_0 +8 val_8 0 val_0 +8 val_8 2 val_2 +8 val_8 4 val_4 +8 val_8 5 val_5 +8 val_8 5 val_5 +8 val_8 5 val_5 +8 val_8 8 val_8 +8 val_8 9 val_9 +9 val_9 0 val_0 +9 val_9 0 val_0 +9 val_9 0 val_0 9 val_9 2 val_2 -9 val_9 5 val_5 -9 val_9 9 val_9 9 val_9 4 val_4 -9 val_9 8 val_8 -9 val_9 0 val_0 9 val_9 5 val_5 9 val_9 5 val_5 -9 val_9 0 val_0 -9 val_9 0 val_0 -4 val_4 2 val_2 -4 val_4 5 val_5 -4 val_4 9 val_9 -4 val_4 4 val_4 -4 val_4 8 val_8 -4 val_4 0 val_0 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 0 val_0 -4 val_4 0 val_0 +9 val_9 5 val_5 +9 val_9 8 val_8 +9 val_9 9 val_9 Index: ql/src/test/queries/clientpositive/join23.q =================================================================== --- ql/src/test/queries/clientpositive/join23.q (revision 768676) +++ ql/src/test/queries/clientpositive/join23.q (working copy) @@ -1,4 +1,4 @@ EXPLAIN -SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10; +SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value; -SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10; +SELECT * FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value;