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

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

#
text | 98 lines | 93 code | 5 blank | 0 comment | 0 complexity | 1baf682cc1a4c2a6ad10e20f6884b6f3 MD5 | raw file
 1PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
 2PREHOOK: type: CREATETABLE
 3POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
 4POSTHOOK: type: CREATETABLE
 5POSTHOOK: Output: default@dest1
 6PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
 7PREHOOK: type: QUERY
 8PREHOOK: Input: default@src
 9PREHOOK: Output: default@dest1
10POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
11POSTHOOK: type: QUERY
12POSTHOOK: Input: default@src
13POSTHOOK: Output: default@dest1
14POSTHOOK: Lineage: dest1.c1 SIMPLE []
15PREHOOK: query: EXPLAIN
16SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
17PREHOOK: type: QUERY
18POSTHOOK: query: EXPLAIN
19SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
20POSTHOOK: type: QUERY
21POSTHOOK: Lineage: dest1.c1 SIMPLE []
22ABSTRACT SYNTAX TREE:
23  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME dest1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION round 1.0)) (TOK_SELEXPR (TOK_FUNCTION round 1.5)) (TOK_SELEXPR (TOK_FUNCTION round (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION floor 1.0)) (TOK_SELEXPR (TOK_FUNCTION floor 1.5)) (TOK_SELEXPR (TOK_FUNCTION floor (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION sqrt 1.0)) (TOK_SELEXPR (TOK_FUNCTION sqrt (- 1.0))) (TOK_SELEXPR (TOK_FUNCTION sqrt 0.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.5)) (TOK_SELEXPR (TOK_FUNCTION ceil (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceiling 1.0)) (TOK_SELEXPR (TOK_FUNCTION rand 3)) (TOK_SELEXPR (+ 3)) (TOK_SELEXPR (- 3)) (TOK_SELEXPR (+ 1 (+ 2))) (TOK_SELEXPR (+ 1 (- 2))) (TOK_SELEXPR (~ 1)))))
24
25STAGE DEPENDENCIES:
26  Stage-1 is a root stage
27  Stage-0 is a root stage
28
29STAGE PLANS:
30  Stage: Stage-1
31    Map Reduce
32      Alias -> Map Operator Tree:
33        dest1 
34          TableScan
35            alias: dest1
36            Select Operator
37              expressions:
38                    expr: round(1.0)
39                    type: bigint
40                    expr: round(1.5)
41                    type: bigint
42                    expr: round((- 1.5))
43                    type: bigint
44                    expr: floor(1.0)
45                    type: bigint
46                    expr: floor(1.5)
47                    type: bigint
48                    expr: floor((- 1.5))
49                    type: bigint
50                    expr: sqrt(1.0)
51                    type: double
52                    expr: sqrt((- 1.0))
53                    type: double
54                    expr: sqrt(0.0)
55                    type: double
56                    expr: ceil(1.0)
57                    type: bigint
58                    expr: ceil(1.5)
59                    type: bigint
60                    expr: ceil((- 1.5))
61                    type: bigint
62                    expr: ceiling(1.0)
63                    type: bigint
64                    expr: rand(3)
65                    type: double
66                    expr: 3
67                    type: int
68                    expr: (- 3)
69                    type: int
70                    expr: (1 + 2)
71                    type: int
72                    expr: (1 + (- 2))
73                    type: int
74                    expr: (~ 1)
75                    type: int
76              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18
77              File Output Operator
78                compressed: false
79                GlobalTableId: 0
80                table:
81                    input format: org.apache.hadoop.mapred.TextInputFormat
82                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
83
84  Stage: Stage-0
85    Fetch Operator
86      limit: -1
87
88
89PREHOOK: query: SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
90PREHOOK: type: QUERY
91PREHOOK: Input: default@dest1
92PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-37_861_8652505512736578305/-mr-10000
93POSTHOOK: query: SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1 FROM dest1
94POSTHOOK: type: QUERY
95POSTHOOK: Input: default@dest1
96POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-28-37_861_8652505512736578305/-mr-10000
97POSTHOOK: Lineage: dest1.c1 SIMPLE []
981	2	-2	1	1	-2	1.0	NULL	0.0	1	2	-1	1	0.731057369148862	3	-3	3	-1	-2