PageRenderTime 23ms CodeModel.GetById 14ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 156 lines | 146 code | 10 blank | 0 comment | 0 complexity | e24ba265e343927e26031e8e0463cb37 MD5 | raw file
  1PREHOOK: query: explain 
  2select sign(0) FROM src LIMIT 1
  3PREHOOK: type: QUERY
  4POSTHOOK: query: explain 
  5select sign(0) 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 sign 0))) (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: sign(0)
 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 sign(0) FROM src LIMIT 1
 40PREHOOK: type: QUERY
 41PREHOOK: Input: default@src
 42PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-17_227_1383191053945370419/-mr-10000
 43POSTHOOK: query: select sign(0) FROM src LIMIT 1
 44POSTHOOK: type: QUERY
 45POSTHOOK: Input: default@src
 46POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-17_227_1383191053945370419/-mr-10000
 470.0
 48PREHOOK: query: select sign(-45) FROM src LIMIT 1
 49PREHOOK: type: QUERY
 50PREHOOK: Input: default@src
 51PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-20_497_4344647994964610941/-mr-10000
 52POSTHOOK: query: select sign(-45) FROM src LIMIT 1
 53POSTHOOK: type: QUERY
 54POSTHOOK: Input: default@src
 55POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-20_497_4344647994964610941/-mr-10000
 56-1.0
 57PREHOOK: query: select sign(46)  FROM src LIMIT 1
 58PREHOOK: type: QUERY
 59PREHOOK: Input: default@src
 60PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-23_774_6548968224814030868/-mr-10000
 61POSTHOOK: query: select sign(46)  FROM src LIMIT 1
 62POSTHOOK: type: QUERY
 63POSTHOOK: Input: default@src
 64POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-23_774_6548968224814030868/-mr-10000
 651.0
 66PREHOOK: query: DESCRIBE FUNCTION sign
 67PREHOOK: type: DESCFUNCTION
 68POSTHOOK: query: DESCRIBE FUNCTION sign
 69POSTHOOK: type: DESCFUNCTION
 70sign(x) - returns the sign of x )
 71PREHOOK: query: DESCRIBE FUNCTION EXTENDED sign
 72PREHOOK: type: DESCFUNCTION
 73POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sign
 74POSTHOOK: type: DESCFUNCTION
 75sign(x) - returns the sign of x )
 76Example:
 77   > SELECT sign(40) FROM src LIMIT 1;
 78  1
 79PREHOOK: query: explain 
 80select sign(0) FROM src LIMIT 1
 81PREHOOK: type: QUERY
 82POSTHOOK: query: explain 
 83select sign(0) FROM src LIMIT 1
 84POSTHOOK: type: QUERY
 85ABSTRACT SYNTAX TREE:
 86  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION sign 0))) (TOK_LIMIT 1)))
 87
 88STAGE DEPENDENCIES:
 89  Stage-1 is a root stage
 90  Stage-0 is a root stage
 91
 92STAGE PLANS:
 93  Stage: Stage-1
 94    Map Reduce
 95      Alias -> Map Operator Tree:
 96        src 
 97          TableScan
 98            alias: src
 99            Select Operator
100              expressions:
101                    expr: sign(0)
102                    type: double
103              outputColumnNames: _col0
104              Limit
105                File Output Operator
106                  compressed: false
107                  GlobalTableId: 0
108                  table:
109                      input format: org.apache.hadoop.mapred.TextInputFormat
110                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
111
112  Stage: Stage-0
113    Fetch Operator
114      limit: 1
115
116
117PREHOOK: query: select sign(0) FROM src LIMIT 1
118PREHOOK: type: QUERY
119PREHOOK: Input: default@src
120PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-27_267_8942791588882991640/-mr-10000
121POSTHOOK: query: select sign(0) FROM src LIMIT 1
122POSTHOOK: type: QUERY
123POSTHOOK: Input: default@src
124POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-27_267_8942791588882991640/-mr-10000
1250.0
126PREHOOK: query: select sign(-45) FROM src LIMIT 1
127PREHOOK: type: QUERY
128PREHOOK: Input: default@src
129PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-30_576_4621808874907335472/-mr-10000
130POSTHOOK: query: select sign(-45) FROM src LIMIT 1
131POSTHOOK: type: QUERY
132POSTHOOK: Input: default@src
133POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-30_576_4621808874907335472/-mr-10000
134-1.0
135PREHOOK: query: select sign(46)  FROM src LIMIT 1
136PREHOOK: type: QUERY
137PREHOOK: Input: default@src
138PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-33_805_4140983550923146966/-mr-10000
139POSTHOOK: query: select sign(46)  FROM src LIMIT 1
140POSTHOOK: type: QUERY
141POSTHOOK: Input: default@src
142POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-41-33_805_4140983550923146966/-mr-10000
1431.0
144PREHOOK: query: DESCRIBE FUNCTION sign
145PREHOOK: type: DESCFUNCTION
146POSTHOOK: query: DESCRIBE FUNCTION sign
147POSTHOOK: type: DESCFUNCTION
148sign(x) - returns the sign of x )
149PREHOOK: query: DESCRIBE FUNCTION EXTENDED sign
150PREHOOK: type: DESCFUNCTION
151POSTHOOK: query: DESCRIBE FUNCTION EXTENDED sign
152POSTHOOK: type: DESCFUNCTION
153sign(x) - returns the sign of x )
154Example:
155   > SELECT sign(40) FROM src LIMIT 1;
156  1