PageRenderTime 21ms CodeModel.GetById 12ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 144 lines | 134 code | 10 blank | 0 comment | 0 complexity | 2c2c3d6aef9891e52a8d1bba9c27373c MD5 | raw file
  1PREHOOK: query: -- Tests exception in ScriptOperator.close() by passing to the operator a small amount of data
  2EXPLAIN SELECT TRANSFORM(*) USING 'true' AS a, b, c FROM (SELECT * FROM src LIMIT 1) tmp
  3PREHOOK: type: QUERY
  4POSTHOOK: query: -- Tests exception in ScriptOperator.close() by passing to the operator a small amount of data
  5EXPLAIN SELECT TRANSFORM(*) USING 'true' AS a, b, c FROM (SELECT * FROM src LIMIT 1) tmp
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (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_ALLCOLREF)) (TOK_LIMIT 1))) tmp)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST TOK_ALLCOLREF) TOK_SERDE TOK_RECORDWRITER 'true' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST a b c))))))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-0 is a root stage
 13
 14STAGE PLANS:
 15  Stage: Stage-1
 16    Map Reduce
 17      Alias -> Map Operator Tree:
 18        tmp:src 
 19          TableScan
 20            alias: src
 21            Select Operator
 22              expressions:
 23                    expr: key
 24                    type: string
 25                    expr: value
 26                    type: string
 27              outputColumnNames: _col0, _col1
 28              Limit
 29                Reduce Output Operator
 30                  sort order: 
 31                  tag: -1
 32                  value expressions:
 33                        expr: _col0
 34                        type: string
 35                        expr: _col1
 36                        type: string
 37      Reduce Operator Tree:
 38        Extract
 39          Limit
 40            Select Operator
 41              expressions:
 42                    expr: _col0
 43                    type: string
 44                    expr: _col1
 45                    type: string
 46              outputColumnNames: _col0, _col1
 47              Transform Operator
 48                command: true
 49                output info:
 50                    input format: org.apache.hadoop.mapred.TextInputFormat
 51                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 52                File Output Operator
 53                  compressed: false
 54                  GlobalTableId: 0
 55                  table:
 56                      input format: org.apache.hadoop.mapred.TextInputFormat
 57                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 58
 59  Stage: Stage-0
 60    Fetch Operator
 61      limit: -1
 62
 63
 64PREHOOK: query: -- Tests exception in ScriptOperator.processOp() by passing extra data needed to fill pipe buffer
 65EXPLAIN SELECT TRANSFORM(key, value, key, value, key, value, key, value, key, value, key, value) USING 'head -n 1' as a,b,c,d FROM src
 66PREHOOK: type: QUERY
 67POSTHOOK: query: -- Tests exception in ScriptOperator.processOp() by passing extra data needed to fill pipe buffer
 68EXPLAIN SELECT TRANSFORM(key, value, key, value, key, value, key, value, key, value, key, value) USING 'head -n 1' as a,b,c,d FROM src
 69POSTHOOK: type: QUERY
 70ABSTRACT SYNTAX TREE:
 71  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value) (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value) (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value) (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value) (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value) (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value)) TOK_SERDE TOK_RECORDWRITER 'head -n 1' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST a b c d))))))
 72
 73STAGE DEPENDENCIES:
 74  Stage-1 is a root stage
 75  Stage-0 is a root stage
 76
 77STAGE PLANS:
 78  Stage: Stage-1
 79    Map Reduce
 80      Alias -> Map Operator Tree:
 81        src 
 82          TableScan
 83            alias: src
 84            Select Operator
 85              expressions:
 86                    expr: key
 87                    type: string
 88                    expr: value
 89                    type: string
 90                    expr: key
 91                    type: string
 92                    expr: value
 93                    type: string
 94                    expr: key
 95                    type: string
 96                    expr: value
 97                    type: string
 98                    expr: key
 99                    type: string
100                    expr: value
101                    type: string
102                    expr: key
103                    type: string
104                    expr: value
105                    type: string
106                    expr: key
107                    type: string
108                    expr: value
109                    type: string
110              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
111              Transform Operator
112                command: head -n 1
113                output info:
114                    input format: org.apache.hadoop.mapred.TextInputFormat
115                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
116                File Output Operator
117                  compressed: false
118                  GlobalTableId: 0
119                  table:
120                      input format: org.apache.hadoop.mapred.TextInputFormat
121                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
122
123  Stage: Stage-0
124    Fetch Operator
125      limit: -1
126
127
128PREHOOK: query: SELECT TRANSFORM(*) USING 'true' AS a, b, c FROM (SELECT * FROM src LIMIT 1) tmp
129PREHOOK: type: QUERY
130PREHOOK: Input: default@src
131PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-04-24_464_8912984348360732907/-mr-10000
132POSTHOOK: query: SELECT TRANSFORM(*) USING 'true' AS a, b, c FROM (SELECT * FROM src LIMIT 1) tmp
133POSTHOOK: type: QUERY
134POSTHOOK: Input: default@src
135POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-04-24_464_8912984348360732907/-mr-10000
136PREHOOK: query: SELECT TRANSFORM(key, value, key, value, key, value, key, value, key, value, key, value) USING 'head -n 1' as a,b,c,d FROM src
137PREHOOK: type: QUERY
138PREHOOK: Input: default@src
139PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-04-27_817_7785884157237702561/-mr-10000
140POSTHOOK: query: SELECT TRANSFORM(key, value, key, value, key, value, key, value, key, value, key, value) USING 'head -n 1' as a,b,c,d FROM src
141POSTHOOK: type: QUERY
142POSTHOOK: Input: default@src
143POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-04-27_817_7785884157237702561/-mr-10000
144238	val_238	238	val_238