PageRenderTime 17ms CodeModel.GetById 14ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_rpad.q.out

#
text | 80 lines | 75 code | 5 blank | 0 comment | 0 complexity | 78b3791197f08ca094255e5ba630cb59 MD5 | raw file
 1PREHOOK: query: DESCRIBE FUNCTION rpad
 2PREHOOK: type: DESCFUNCTION
 3POSTHOOK: query: DESCRIBE FUNCTION rpad
 4POSTHOOK: type: DESCFUNCTION
 5rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
 6PREHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
 7PREHOOK: type: DESCFUNCTION
 8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
 9POSTHOOK: type: DESCFUNCTION
10rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
11If str is longer than len, the return value is shortened to len characters.
12Example:
13  > SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
14  'hi???'  > SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
15  'h'
16PREHOOK: query: EXPLAIN SELECT
17  rpad('hi', 1, '?'),
18  rpad('hi', 5, '.'),
19  rpad('hi', 6, '123')
20FROM src LIMIT 1
21PREHOOK: type: QUERY
22POSTHOOK: query: EXPLAIN SELECT
23  rpad('hi', 1, '?'),
24  rpad('hi', 5, '.'),
25  rpad('hi', 6, '123')
26FROM src LIMIT 1
27POSTHOOK: type: QUERY
28ABSTRACT SYNTAX TREE:
29  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 6 '123'))) (TOK_LIMIT 1)))
30
31STAGE DEPENDENCIES:
32  Stage-1 is a root stage
33  Stage-0 is a root stage
34
35STAGE PLANS:
36  Stage: Stage-1
37    Map Reduce
38      Alias -> Map Operator Tree:
39        src 
40          TableScan
41            alias: src
42            Select Operator
43              expressions:
44                    expr: rpad('hi', 1, '?')
45                    type: string
46                    expr: rpad('hi', 5, '.')
47                    type: string
48                    expr: rpad('hi', 6, '123')
49                    type: string
50              outputColumnNames: _col0, _col1, _col2
51              Limit
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: SELECT
65  rpad('hi', 1, '?'),
66  rpad('hi', 5, '.'),
67  rpad('hi', 6, '123')
68FROM src LIMIT 1
69PREHOOK: type: QUERY
70PREHOOK: Input: default@src
71PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-40-39_701_3392999608689301227/-mr-10000
72POSTHOOK: query: SELECT
73  rpad('hi', 1, '?'),
74  rpad('hi', 5, '.'),
75  rpad('hi', 6, '123')
76FROM src LIMIT 1
77POSTHOOK: type: QUERY
78POSTHOOK: Input: default@src
79POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-40-39_701_3392999608689301227/-mr-10000
80h	hi...	hi1231