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

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

#
text | 74 lines | 69 code | 5 blank | 0 comment | 0 complexity | 967e28ff882b9c9a6a7c0451caa1a1e6 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              Select Operator
44                expressions:
45                      expr: minute('2009-08-07 13:14:15')
46                      type: int
47                      expr: minute('13:14:15')
48                      type: int
49                      expr: minute('2009-08-07')
50                      type: int
51                outputColumnNames: _col0, _col1, _col2
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 minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
65FROM src WHERE key = 86
66PREHOOK: type: QUERY
67PREHOOK: Input: default@src
68PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-38-23_869_5383802616701222398/-mr-10000
69POSTHOOK: query: SELECT minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07')
70FROM src WHERE key = 86
71POSTHOOK: type: QUERY
72POSTHOOK: Input: default@src
73POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-38-23_869_5383802616701222398/-mr-10000
7414	14	NULL