PageRenderTime 28ms CodeModel.GetById 19ms app.highlight 3ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 122 lines | 112 code | 10 blank | 0 comment | 0 complexity | e65b60fdda443020312146d458311436 MD5 | raw file
  1PREHOOK: query: explain 
  2select PI() FROM src LIMIT 1
  3PREHOOK: type: QUERY
  4POSTHOOK: query: explain 
  5select PI() 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 PI))) (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: pi()
 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 PI() FROM src LIMIT 1
 40PREHOOK: type: QUERY
 41PREHOOK: Input: default@src
 42PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-44_724_7288260865826499939/-mr-10000
 43POSTHOOK: query: select PI() FROM src LIMIT 1
 44POSTHOOK: type: QUERY
 45POSTHOOK: Input: default@src
 46POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-44_724_7288260865826499939/-mr-10000
 473.141592653589793
 48PREHOOK: query: DESCRIBE FUNCTION PI
 49PREHOOK: type: DESCFUNCTION
 50POSTHOOK: query: DESCRIBE FUNCTION PI
 51POSTHOOK: type: DESCFUNCTION
 52PI() - returns pi 
 53PREHOOK: query: DESCRIBE FUNCTION EXTENDED PI
 54PREHOOK: type: DESCFUNCTION
 55POSTHOOK: query: DESCRIBE FUNCTION EXTENDED PI
 56POSTHOOK: type: DESCFUNCTION
 57PI() - returns pi 
 58Synonyms: pi
 59Example:
 60 > SELECT PI() FROM src LIMIT 1;
 61 3.14159...
 62PREHOOK: query: explain 
 63select PI() FROM src LIMIT 1
 64PREHOOK: type: QUERY
 65POSTHOOK: query: explain 
 66select PI() 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 PI))) (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: pi()
 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 PI() FROM src LIMIT 1
101PREHOOK: type: QUERY
102PREHOOK: Input: default@src
103PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-48_229_8295935551668319481/-mr-10000
104POSTHOOK: query: select PI() FROM src LIMIT 1
105POSTHOOK: type: QUERY
106POSTHOOK: Input: default@src
107POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-29-48_229_8295935551668319481/-mr-10000
1083.141592653589793
109PREHOOK: query: DESCRIBE FUNCTION PI
110PREHOOK: type: DESCFUNCTION
111POSTHOOK: query: DESCRIBE FUNCTION PI
112POSTHOOK: type: DESCFUNCTION
113PI() - returns pi 
114PREHOOK: query: DESCRIBE FUNCTION EXTENDED PI
115PREHOOK: type: DESCFUNCTION
116POSTHOOK: query: DESCRIBE FUNCTION EXTENDED PI
117POSTHOOK: type: DESCFUNCTION
118PI() - returns pi 
119Synonyms: pi
120Example:
121 > SELECT PI() FROM src LIMIT 1;
122 3.14159...