PageRenderTime 15ms CodeModel.GetById 12ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 130 lines | 125 code | 5 blank | 0 comment | 0 complexity | d1062a74a49959a5615ce54f067566b0 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(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
 17       LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
 18       ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
 19       LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
 20       POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
 21       POWER(-1, 0.5), POWER(-1, 2) FROM dest1
 22PREHOOK: type: QUERY
 23POSTHOOK: query: EXPLAIN
 24SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
 25       LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
 26       ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
 27       LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
 28       POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
 29       POWER(-1, 0.5), POWER(-1, 2) FROM dest1
 30POSTHOOK: type: QUERY
 31POSTHOOK: Lineage: dest1.c1 SIMPLE []
 32ABSTRACT SYNTAX TREE:
 33  (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 (TOK_FUNCTION LN 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LN 0.0)) (TOK_SELEXPR (TOK_FUNCTION LN (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG2 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG10 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG10 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG10 (- 1))) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION LOG 2 3.0) 12)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.0)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 (- 1))) (TOK_SELEXPR (TOK_FUNCTION LOG 0.5 2)) (TOK_SELEXPR (TOK_FUNCTION LOG 2 0.5)) (TOK_SELEXPR (TOK_FUNCTION ROUND (TOK_FUNCTION EXP 2.0) 12)) (TOK_SELEXPR (TOK_FUNCTION POW 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 3)) (TOK_SELEXPR (TOK_FUNCTION POWER 2 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 0.5 (- 3))) (TOK_SELEXPR (TOK_FUNCTION POWER 4 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 0.5)) (TOK_SELEXPR (TOK_FUNCTION POWER (- 1) 2)))))
 34
 35STAGE DEPENDENCIES:
 36  Stage-1 is a root stage
 37  Stage-0 is a root stage
 38
 39STAGE PLANS:
 40  Stage: Stage-1
 41    Map Reduce
 42      Alias -> Map Operator Tree:
 43        dest1 
 44          TableScan
 45            alias: dest1
 46            Select Operator
 47              expressions:
 48                    expr: round(ln(3.0), 12)
 49                    type: double
 50                    expr: ln(0.0)
 51                    type: double
 52                    expr: ln((- 1))
 53                    type: double
 54                    expr: round(log(3.0), 12)
 55                    type: double
 56                    expr: log(0.0)
 57                    type: double
 58                    expr: log((- 1))
 59                    type: double
 60                    expr: round(log2(3.0), 12)
 61                    type: double
 62                    expr: log2(0.0)
 63                    type: double
 64                    expr: log2((- 1))
 65                    type: double
 66                    expr: round(log10(3.0), 12)
 67                    type: double
 68                    expr: log10(0.0)
 69                    type: double
 70                    expr: log10((- 1))
 71                    type: double
 72                    expr: round(log(2, 3.0), 12)
 73                    type: double
 74                    expr: log(2, 0.0)
 75                    type: double
 76                    expr: log(2, (- 1))
 77                    type: double
 78                    expr: log(0.5, 2)
 79                    type: double
 80                    expr: log(2, 0.5)
 81                    type: double
 82                    expr: round(exp(2.0), 12)
 83                    type: double
 84                    expr: pow(2, 3)
 85                    type: double
 86                    expr: power(2, 3)
 87                    type: double
 88                    expr: power(2, (- 3))
 89                    type: double
 90                    expr: power(0.5, (- 3))
 91                    type: double
 92                    expr: power(4, 0.5)
 93                    type: double
 94                    expr: power((- 1), 0.5)
 95                    type: double
 96                    expr: power((- 1), 2)
 97                    type: double
 98              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24
 99              File Output Operator
100                compressed: false
101                GlobalTableId: 0
102                table:
103                    input format: org.apache.hadoop.mapred.TextInputFormat
104                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
105
106  Stage: Stage-0
107    Fetch Operator
108      limit: -1
109
110
111PREHOOK: query: SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
112       LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
113       ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
114       LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
115       POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
116       POWER(-1, 0.5), POWER(-1, 2) FROM dest1
117PREHOOK: type: QUERY
118PREHOOK: Input: default@dest1
119PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-10_985_284171380044338731/-mr-10000
120POSTHOOK: query: SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0),
121       LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1),
122       ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12),
123       LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12),
124       POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5),
125       POWER(-1, 0.5), POWER(-1, 2) FROM dest1
126POSTHOOK: type: QUERY
127POSTHOOK: Input: default@dest1
128POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-10_985_284171380044338731/-mr-10000
129POSTHOOK: Lineage: dest1.c1 SIMPLE []
1301.098612288668	NULL	NULL	1.098612288668	NULL	NULL	1.584962500721	NULL	NULL	0.47712125472	NULL	NULL	1.584962500721	NULL	NULL	NULL	-1.0	7.389056098931	8.0	8.0	0.125	8.0	2.0	NaN	1.0