PageRenderTime 19ms CodeModel.GetById 16ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 140 lines | 128 code | 12 blank | 0 comment | 0 complexity | 622f49aa7955e8e8f333bda3a6b010a6 MD5 | raw file
  1PREHOOK: query: explain 
  2select radians(57.2958) FROM src LIMIT 1
  3PREHOOK: type: QUERY
  4POSTHOOK: query: explain 
  5select radians(57.2958) FROM src LIMIT 1
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION radians 57.2958))) (TOK_LIMIT 1)))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-0 is a root stage
 13
 14STAGE PLANS:
 15  Stage: Stage-1
 16    Map Reduce
 17      Alias -> Map Operator Tree:
 18        src 
 19          TableScan
 20            alias: src
 21            Select Operator
 22              expressions:
 23                    expr: radians(57.2958)
 24                    type: double
 25              outputColumnNames: _col0
 26              Limit
 27                File Output Operator
 28                  compressed: false
 29                  GlobalTableId: 0
 30                  table:
 31                      input format: org.apache.hadoop.mapred.TextInputFormat
 32                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 33
 34  Stage: Stage-0
 35    Fetch Operator
 36      limit: 1
 37
 38
 39PREHOOK: query: select radians(57.2958) FROM src LIMIT 1
 40PREHOOK: type: QUERY
 41PREHOOK: Input: default@src
 42PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-44_078_9109783333773553444/-mr-10000
 43POSTHOOK: query: select radians(57.2958) FROM src LIMIT 1
 44POSTHOOK: type: QUERY
 45POSTHOOK: Input: default@src
 46POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-44_078_9109783333773553444/-mr-10000
 471.000000357564167
 48PREHOOK: query: select radians(143.2394) FROM src LIMIT 1
 49PREHOOK: type: QUERY
 50PREHOOK: Input: default@src
 51PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-47_306_1941990909459019781/-mr-10000
 52POSTHOOK: query: select radians(143.2394) FROM src LIMIT 1
 53POSTHOOK: type: QUERY
 54POSTHOOK: Input: default@src
 55POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-47_306_1941990909459019781/-mr-10000
 562.4999991485811655
 57PREHOOK: query: DESCRIBE FUNCTION radians
 58PREHOOK: type: DESCFUNCTION
 59POSTHOOK: query: DESCRIBE FUNCTION radians
 60POSTHOOK: type: DESCFUNCTION
 61radians(x) - Converts degrees to radians
 62PREHOOK: query: DESCRIBE FUNCTION EXTENDED radians
 63PREHOOK: type: DESCFUNCTION
 64POSTHOOK: query: DESCRIBE FUNCTION EXTENDED radians
 65POSTHOOK: type: DESCFUNCTION
 66radians(x) - Converts degrees to radians
 67Example:
 68  > SELECT radians(90) FROM src LIMIT 1;
 69  1.5707963267949mo
 70
 71PREHOOK: query: explain 
 72select radians(57.2958) FROM src LIMIT 1
 73PREHOOK: type: QUERY
 74POSTHOOK: query: explain 
 75select radians(57.2958) FROM src LIMIT 1
 76POSTHOOK: type: QUERY
 77ABSTRACT SYNTAX TREE:
 78  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION radians 57.2958))) (TOK_LIMIT 1)))
 79
 80STAGE DEPENDENCIES:
 81  Stage-1 is a root stage
 82  Stage-0 is a root stage
 83
 84STAGE PLANS:
 85  Stage: Stage-1
 86    Map Reduce
 87      Alias -> Map Operator Tree:
 88        src 
 89          TableScan
 90            alias: src
 91            Select Operator
 92              expressions:
 93                    expr: radians(57.2958)
 94                    type: double
 95              outputColumnNames: _col0
 96              Limit
 97                File Output Operator
 98                  compressed: false
 99                  GlobalTableId: 0
100                  table:
101                      input format: org.apache.hadoop.mapred.TextInputFormat
102                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
103
104  Stage: Stage-0
105    Fetch Operator
106      limit: 1
107
108
109PREHOOK: query: select radians(57.2958) FROM src LIMIT 1
110PREHOOK: type: QUERY
111PREHOOK: Input: default@src
112PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-50_816_7653095422070360785/-mr-10000
113POSTHOOK: query: select radians(57.2958) FROM src LIMIT 1
114POSTHOOK: type: QUERY
115POSTHOOK: Input: default@src
116POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-50_816_7653095422070360785/-mr-10000
1171.000000357564167
118PREHOOK: query: select radians(143.2394) FROM src LIMIT 1
119PREHOOK: type: QUERY
120PREHOOK: Input: default@src
121PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-54_090_7082105358146623132/-mr-10000
122POSTHOOK: query: select radians(143.2394) FROM src LIMIT 1
123POSTHOOK: type: QUERY
124POSTHOOK: Input: default@src
125POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-54_090_7082105358146623132/-mr-10000
1262.4999991485811655
127PREHOOK: query: DESCRIBE FUNCTION radians
128PREHOOK: type: DESCFUNCTION
129POSTHOOK: query: DESCRIBE FUNCTION radians
130POSTHOOK: type: DESCFUNCTION
131radians(x) - Converts degrees to radians
132PREHOOK: query: DESCRIBE FUNCTION EXTENDED radians
133PREHOOK: type: DESCFUNCTION
134POSTHOOK: query: DESCRIBE FUNCTION EXTENDED radians
135POSTHOOK: type: DESCFUNCTION
136radians(x) - Converts degrees to radians
137Example:
138  > SELECT radians(90) FROM src LIMIT 1;
139  1.5707963267949mo
140