/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: CREATE TABLE mytable(key STRING, value STRING)
- ROW FORMAT DELIMITED
- FIELDS TERMINATED BY '9'
- STORED AS TEXTFILE
- PREHOOK: type: CREATETABLE
- POSTHOOK: query: CREATE TABLE mytable(key STRING, value STRING)
- ROW FORMAT DELIMITED
- FIELDS TERMINATED BY '9'
- STORED AS TEXTFILE
- POSTHOOK: type: CREATETABLE
- POSTHOOK: Output: default@mytable
- PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE mytable
- PREHOOK: type: LOAD
- POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/string.txt' INTO TABLE mytable
- POSTHOOK: type: LOAD
- POSTHOOK: Output: default@mytable
- PREHOOK: query: EXPLAIN
- SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
- FROM (
- SELECT key, sum(value) as value
- FROM mytable
- GROUP BY key
- ) a
- PREHOOK: type: QUERY
- POSTHOOK: query: EXPLAIN
- SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
- FROM (
- SELECT key, sum(value) as value
- FROM mytable
- GROUP BY key
- ) a
- POSTHOOK: type: QUERY
- ABSTRACT SYNTAX TREE:
- (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)))))
- 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:
- a:mytable
- TableScan
- alias: mytable
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- outputColumnNames: key, value
- Group By Operator
- aggregations:
- expr: sum(value)
- bucketGroup: false
- keys:
- expr: key
- 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: double
- Reduce Operator Tree:
- Group By Operator
- aggregations:
- expr: sum(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: double
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: regexp_replace(regexp_replace(regexp_replace(_col0, '', '^A'), '�', '^@'), '', '^B')
- type: string
- expr: _col1
- type: double
- 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 REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
- FROM (
- SELECT key, sum(value) as value
- FROM mytable
- GROUP BY key
- ) a
- PREHOOK: type: QUERY
- PREHOOK: Input: default@mytable
- PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-30-28_845_3405263601759137587/-mr-10000
- POSTHOOK: query: SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(key, '\001', '^A'), '\0', '^@'), '\002', '^B'), value
- FROM (
- SELECT key, sum(value) as value
- FROM mytable
- GROUP BY key
- ) a
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@mytable
- POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-30-28_845_3405263601759137587/-mr-10000
- ^@^@^@ 7.0
- ^@^A^@ 9.0
- ^@test^@ 2.0
- ^A^@^A 10.0
- ^A^A^A 8.0
- ^Atest^A 3.0
- a^@bc^A^B^A^@ 1.0
- test^@^@^A^Atest 6.0
- test^@test 4.0
- test^Atest 5.0