PageRenderTime 25ms CodeModel.GetById 17ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/binarysortable_1.q.out

#
text | 93 lines | 91 code | 2 blank | 0 comment | 0 complexity | 689975107c5f8da2b4ed801f11594744 MD5 | raw file
  1PREHOOK: query: CREATE TABLE mytable(key STRING, value STRING)
  2ROW FORMAT DELIMITED
  3FIELDS TERMINATED BY '9'
  4STORED AS TEXTFILE
  5PREHOOK: type: CREATETABLE
  6POSTHOOK: query: CREATE TABLE mytable(key STRING, value STRING)
  7ROW FORMAT DELIMITED
  8FIELDS TERMINATED BY '9'
  9STORED AS TEXTFILE
 10POSTHOOK: type: CREATETABLE
 11POSTHOOK: Output: default@mytable
 12PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE mytable
 13PREHOOK: type: LOAD
 14POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE mytable
 15POSTHOOK: type: LOAD
 16POSTHOOK: Output: default@mytable
 17PREHOOK: query: EXPLAIN
 18SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
 19FROM (
 20        SELECT key, sum(value) as value
 21        FROM mytable
 22        GROUP BY key
 23) a
 24PREHOOK: type: QUERY
 25POSTHOOK: query: EXPLAIN
 26SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
 27FROM (
 28        SELECT key, sum(value) as value
 29        FROM mytable
 30        GROUP BY key
 31) a
 32POSTHOOK: type: QUERY
 33ABSTRACT SYNTAX TREE:
 34  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME mytable))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_TABLE_OR_COL value)) value)) (TOK_GROUPBY (TOK_TABLE_OR_COL key)))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION REGEXP_REPLACE (TOK_FUNCTION REGEXP_REPLACE (TOK_FUNCTION REGEXP_REPLACE (TOK_TABLE_OR_COL key) '\001' '^A') '\0' '^@') '\002' '^B')) (TOK_SELEXPR (TOK_TABLE_OR_COL value)))))
 35
 36STAGE DEPENDENCIES:
 37  Stage-1 is a root stage
 38  Stage-0 is a root stage
 39
 40STAGE PLANS:
 41  Stage: Stage-1
 42    Map Reduce
 43      Alias -> Map Operator Tree:
 44        a:mytable 
 45          TableScan
 46            alias: mytable
 47            Select Operator
 48              expressions:
 49                    expr: key
 50                    type: string
 51                    expr: value
 52                    type: string
 53              outputColumnNames: key, value
 54              Group By Operator
 55                aggregations:
 56                      expr: sum(value)
 57                bucketGroup: false
 58                keys:
 59                      expr: key
 60                      type: string
 61                mode: hash
 62                outputColumnNames: _col0, _col1
 63                Reduce Output Operator
 64                  key expressions:
 65                        expr: _col0
 66                        type: string
 67                  sort order: +
 68                  Map-reduce partition columns:
 69                        expr: _col0
 70                        type: string
 71                  tag: -1
 72                  value expressions:
 73                        expr: _col1
 74                        type: double
 75      Reduce Operator Tree:
 76        Group By Operator
 77          aggregations:
 78                expr: sum(VALUE._col0)
 79          bucketGroup: false
 80          keys:
 81                expr: KEY._col0
 82                type: string
 83          mode: mergepartial
 84          outputColumnNames: _col0, _col1
 85          Select Operator
 86            expressions:
 87                  expr: _col0
 88                  type: string
 89                  expr: _col1
 90                  type: double
 91            outputColumnNames: _col0, _col1
 92            Select Operator
 93              expressions:
 94                    expr: regexp_replace(regexp_replace(regexp_replace(_col0, '', '^A'), '', '^@'), '', '^B')
 95                    type: string
 96                    expr: _col1
 97                    type: double
 98              outputColumnNames: _col0, _col1
 99              File Output Operator
100                compressed: false
101                GlobalTableId: 0
102                table:
103                    input format: org.apache.hadoop.mapred.TextInputFormat
104                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
105
106  Stage: Stage-0
107    Fetch Operator
108      limit: -1
109
110
111PREHOOK: query: SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
112FROM (
113        SELECT key, sum(value) as value
114        FROM mytable
115        GROUP BY key
116) a
117PREHOOK: type: QUERY
118PREHOOK: Input: default@mytable
119PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-30-28_845_3405263601759137587/-mr-10000
120POSTHOOK: query: SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
121FROM (
122        SELECT key, sum(value) as value
123        FROM mytable
124        GROUP BY key
125) a
126POSTHOOK: type: QUERY
127POSTHOOK: Input: default@mytable
128POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-30-28_845_3405263601759137587/-mr-10000
129^@^@^@	7.0
130^@^A^@	9.0
131^@test^@	2.0
132^A^@^A	10.0
133^A^A^A	8.0
134^Atest^A	3.0
135a^@bc^A^B^A^@	1.0
136test^@^@^A^Atest	6.0
137test^@test	4.0
138test^Atest	5.0