PageRenderTime 21ms CodeModel.GetById 13ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 122 lines | 112 code | 10 blank | 0 comment | 0 complexity | 74e7626eb4f89f9ce1bda537590d5d2a MD5 | raw file
  1PREHOOK: query: explain 
  2select E() FROM src LIMIT 1
  3PREHOOK: type: QUERY
  4POSTHOOK: query: explain 
  5select E() 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 E))) (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: e()
 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 E() FROM src LIMIT 1
 40PREHOOK: type: QUERY
 41PREHOOK: Input: default@src
 42PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-37_447_8042489940271027133/-mr-10000
 43POSTHOOK: query: select E() FROM src LIMIT 1
 44POSTHOOK: type: QUERY
 45POSTHOOK: Input: default@src
 46POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-37_447_8042489940271027133/-mr-10000
 472.718281828459045
 48PREHOOK: query: DESCRIBE FUNCTION E
 49PREHOOK: type: DESCFUNCTION
 50POSTHOOK: query: DESCRIBE FUNCTION E
 51POSTHOOK: type: DESCFUNCTION
 52E() - returns E 
 53PREHOOK: query: DESCRIBE FUNCTION EXTENDED E
 54PREHOOK: type: DESCFUNCTION
 55POSTHOOK: query: DESCRIBE FUNCTION EXTENDED E
 56POSTHOOK: type: DESCFUNCTION
 57E() - returns E 
 58Synonyms: e
 59Example:
 60 > SELECT E() FROM src LIMIT 1;
 61 2.718281828459045
 62PREHOOK: query: explain 
 63select E() FROM src LIMIT 1
 64PREHOOK: type: QUERY
 65POSTHOOK: query: explain 
 66select E() FROM src LIMIT 1
 67POSTHOOK: type: QUERY
 68ABSTRACT SYNTAX TREE:
 69  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION E))) (TOK_LIMIT 1)))
 70
 71STAGE DEPENDENCIES:
 72  Stage-1 is a root stage
 73  Stage-0 is a root stage
 74
 75STAGE PLANS:
 76  Stage: Stage-1
 77    Map Reduce
 78      Alias -> Map Operator Tree:
 79        src 
 80          TableScan
 81            alias: src
 82            Select Operator
 83              expressions:
 84                    expr: e()
 85                    type: double
 86              outputColumnNames: _col0
 87              Limit
 88                File Output Operator
 89                  compressed: false
 90                  GlobalTableId: 0
 91                  table:
 92                      input format: org.apache.hadoop.mapred.TextInputFormat
 93                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 94
 95  Stage: Stage-0
 96    Fetch Operator
 97      limit: 1
 98
 99
100PREHOOK: query: select E() FROM src LIMIT 1
101PREHOOK: type: QUERY
102PREHOOK: Input: default@src
103PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-40_986_4023064895654770963/-mr-10000
104POSTHOOK: query: select E() FROM src LIMIT 1
105POSTHOOK: type: QUERY
106POSTHOOK: Input: default@src
107POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-40_986_4023064895654770963/-mr-10000
1082.718281828459045
109PREHOOK: query: DESCRIBE FUNCTION E
110PREHOOK: type: DESCFUNCTION
111POSTHOOK: query: DESCRIBE FUNCTION E
112POSTHOOK: type: DESCFUNCTION
113E() - returns E 
114PREHOOK: query: DESCRIBE FUNCTION EXTENDED E
115PREHOOK: type: DESCFUNCTION
116POSTHOOK: query: DESCRIBE FUNCTION EXTENDED E
117POSTHOOK: type: DESCFUNCTION
118E() - returns E 
119Synonyms: e
120Example:
121 > SELECT E() FROM src LIMIT 1;
122 2.718281828459045