HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / udf_factorial.q.out
1 PREHOOK: query: DESCRIBE FUNCTION factorial
2 PREHOOK: type: DESCFUNCTION
3 POSTHOOK: query: DESCRIBE FUNCTION factorial
4 POSTHOOK: type: DESCFUNCTION
5 factorial(int) - Returns n factorial. Valid n is [0..20].
6 PREHOOK: query: DESC FUNCTION EXTENDED factorial
7 PREHOOK: type: DESCFUNCTION
8 POSTHOOK: query: DESC FUNCTION EXTENDED factorial
9 POSTHOOK: type: DESCFUNCTION
10 factorial(int) - Returns n factorial. Valid n is [0..20].
11 Returns null if n is out of [0..20] range.
12 Example:
13  > SELECT factorial(5);
14  120
15 Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFFactorial
16 Function type:BUILTIN
17 PREHOOK: query: explain select factorial(5)
18 PREHOOK: type: QUERY
19 POSTHOOK: query: explain select factorial(5)
20 POSTHOOK: type: QUERY
21 STAGE DEPENDENCIES:
22   Stage-0 is a root stage
23
24 STAGE PLANS:
25   Stage: Stage-0
26     Fetch Operator
27       limit: -1
28       Processor Tree:
29         TableScan
30           alias: _dummy_table
31           Row Limit Per Split: 1
32           Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
33           Select Operator
34             expressions: 120L (type: bigint)
35             outputColumnNames: _col0
36             Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
37             ListSink
38
39 PREHOOK: query: select
40 factorial(5),
41 factorial(0),
42 factorial(20),
43 factorial(-1),
44 factorial(21),
45 factorial(cast(null as int))
46 PREHOOK: type: QUERY
47 PREHOOK: Input: _dummy_database@_dummy_table
48 #### A masked pattern was here ####
49 POSTHOOK: query: select
50 factorial(5),
51 factorial(0),
52 factorial(20),
53 factorial(-1),
54 factorial(21),
55 factorial(cast(null as int))
56 POSTHOOK: type: QUERY
57 POSTHOOK: Input: _dummy_database@_dummy_table
58 #### A masked pattern was here ####
59 120     1       2432902008176640000     NULL    NULL    NULL