PageRenderTime 13ms CodeModel.GetById 9ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 67 lines | 62 code | 5 blank | 0 comment | 0 complexity | c8dcf158b08588bfa49fe20f8bc046d7 MD5 | raw file
 1PREHOOK: query: EXPLAIN SELECT null + 7, 1.0 - null, null + null,
 2               CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
 3               CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
 4               9 % "3" FROM src LIMIT 1
 5PREHOOK: type: QUERY
 6POSTHOOK: query: EXPLAIN SELECT null + 7, 1.0 - null, null + null,
 7               CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
 8               CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
 9               9 % "3" FROM src LIMIT 1
10POSTHOOK: type: QUERY
11ABSTRACT SYNTAX TREE:
12  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (+ TOK_NULL 7)) (TOK_SELEXPR (- 1.0 TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)) (TOK_SELEXPR (% (TOK_FUNCTION TOK_BIGINT 21) (TOK_FUNCTION TOK_TINYINT 5))) (TOK_SELEXPR (% (TOK_FUNCTION TOK_BIGINT 21) (TOK_FUNCTION TOK_BIGINT 21))) (TOK_SELEXPR (% 9 "3"))) (TOK_LIMIT 1)))
13
14STAGE DEPENDENCIES:
15  Stage-1 is a root stage
16  Stage-0 is a root stage
17
18STAGE PLANS:
19  Stage: Stage-1
20    Map Reduce
21      Alias -> Map Operator Tree:
22        src 
23          TableScan
24            alias: src
25            Select Operator
26              expressions:
27                    expr: (null + 7)
28                    type: int
29                    expr: (1.0 - null)
30                    type: double
31                    expr: (null + null)
32                    type: tinyint
33                    expr: (UDFToLong(21) % UDFToByte(5))
34                    type: bigint
35                    expr: (UDFToLong(21) % UDFToLong(21))
36                    type: bigint
37                    expr: (9 % '3')
38                    type: double
39              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
40              Limit
41                File Output Operator
42                  compressed: false
43                  GlobalTableId: 0
44                  table:
45                      input format: org.apache.hadoop.mapred.TextInputFormat
46                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
47
48  Stage: Stage-0
49    Fetch Operator
50      limit: 1
51
52
53PREHOOK: query: SELECT null + 7, 1.0 - null, null + null,
54       CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
55       CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
56       9 % "3" FROM src LIMIT 1
57PREHOOK: type: QUERY
58PREHOOK: Input: default@src
59PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-55_797_7464570094193374274/-mr-10000
60POSTHOOK: query: SELECT null + 7, 1.0 - null, null + null,
61       CAST(21 AS BIGINT) % CAST(5 AS TINYINT),
62       CAST(21 AS BIGINT) % CAST(21 AS BIGINT),
63       9 % "3" FROM src LIMIT 1
64POSTHOOK: type: QUERY
65POSTHOOK: Input: default@src
66POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-48-55_797_7464570094193374274/-mr-10000
67NULL	NULL	NULL	1	0	0.0