PageRenderTime 24ms CodeModel.GetById 16ms app.highlight 2ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 78 lines | 73 code | 5 blank | 0 comment | 0 complexity | 2923ad2a280697c562b85cd03eca91fd MD5 | raw file
 1PREHOOK: query: DESCRIBE FUNCTION minute
 2PREHOOK: type: DESCFUNCTION
 3POSTHOOK: query: DESCRIBE FUNCTION minute
 4POSTHOOK: type: DESCFUNCTION
 5minute(date) - Returns the minute of date
 6PREHOOK: query: DESCRIBE FUNCTION EXTENDED minute
 7PREHOOK: type: DESCFUNCTION
 8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED minute
 9POSTHOOK: type: DESCFUNCTION
10minute(date) - Returns the minute of date
11date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
12Example:
13   > SELECT minute('2009-07-30 12:58:59') FROM src LIMIT 1;
14  58
15  > SELECT minute('12:58:59') FROM src LIMIT 1;
16  58
17PREHOOK: query: EXPLAIN
18SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
19FROM src WHERE key = 86
20PREHOOK: type: QUERY
21POSTHOOK: query: EXPLAIN
22SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
23FROM src WHERE key = 86
24POSTHOOK: type: QUERY
25ABSTRACT SYNTAX TREE:
26  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
27
28STAGE DEPENDENCIES:
29  Stage-1 is a root stage
30  Stage-0 is a root stage
31
32STAGE PLANS:
33  Stage: Stage-1
34    Map Reduce
35      Alias -> Map Operator Tree:
36        src 
37          TableScan
38            alias: src
39            Filter Operator
40              predicate:
41                  expr: (key = 86)
42                  type: boolean
43              Filter Operator
44                predicate:
45                    expr: (key = 86)
46                    type: boolean
47                Select Operator
48                  expressions:
49                        expr: minute('2009-08-07 13:14:15')
50                        type: int
51                        expr: minute('13:14:15')
52                        type: int
53                        expr: minute('2009-08-07')
54                        type: int
55                  outputColumnNames: _col0, _col1, _col2
56                  File Output Operator
57                    compressed: false
58                    GlobalTableId: 0
59                    table:
60                        input format: org.apache.hadoop.mapred.TextInputFormat
61                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
62
63  Stage: Stage-0
64    Fetch Operator
65      limit: -1
66
67
68PREHOOK: query: SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
69FROM src WHERE key = 86
70PREHOOK: type: QUERY
71PREHOOK: Input: default@src
72PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-38-23_869_5383802616701222398/-mr-10000
73POSTHOOK: query: SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
74FROM src WHERE key = 86
75POSTHOOK: type: QUERY
76POSTHOOK: Input: default@src
77POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-38-23_869_5383802616701222398/-mr-10000
7814	14	NULL