PageRenderTime 14ms CodeModel.GetById 8ms app.highlight 2ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 80 lines | 75 code | 5 blank | 0 comment | 0 complexity | b3e8336b7c48de732d8236c45273e74b MD5 | raw file
 1PREHOOK: query: DESCRIBE FUNCTION lpad
 2PREHOOK: type: DESCFUNCTION
 3POSTHOOK: query: DESCRIBE FUNCTION lpad
 4POSTHOOK: type: DESCFUNCTION
 5lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
 6PREHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
 7PREHOOK: type: DESCFUNCTION
 8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
 9POSTHOOK: type: DESCFUNCTION
10lpad(str, len, pad) - Returns str, left-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 lpad('hi', 5, '??') FROM src LIMIT 1;
14  '???hi'  > SELECT lpad('hi', 1, '??') FROM src LIMIT 1;
15  'h'
16PREHOOK: query: EXPLAIN SELECT
17  lpad('hi', 1, '?'),
18  lpad('hi', 5, '.'),
19  lpad('hi', 6, '123')
20FROM src LIMIT 1
21PREHOOK: type: QUERY
22POSTHOOK: query: EXPLAIN SELECT
23  lpad('hi', 1, '?'),
24  lpad('hi', 5, '.'),
25  lpad('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 lpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION lpad '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: lpad('hi', 1, '?')
45                    type: string
46                    expr: lpad('hi', 5, '.')
47                    type: string
48                    expr: lpad('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  lpad('hi', 1, '?'),
66  lpad('hi', 5, '.'),
67  lpad('hi', 6, '123')
68FROM src LIMIT 1
69PREHOOK: type: QUERY
70PREHOOK: Input: default@src
71PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-37-40_883_8397950012459934370/-mr-10000
72POSTHOOK: query: SELECT
73  lpad('hi', 1, '?'),
74  lpad('hi', 5, '.'),
75  lpad('hi', 6, '123')
76FROM src LIMIT 1
77POSTHOOK: type: QUERY
78POSTHOOK: Input: default@src
79POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-37-40_883_8397950012459934370/-mr-10000
80h	...hi	1231hi