Factorial function in Impala

Question

How can I find the factorial of a number using Impala query?

Answer 1

There are two ways to do this:

select factorial(5);
+--------------+
| factorial(5) |
+--------------+
| 120          |
+--------------+

select 5!;
+-----+
| 5!  |
+-----+
| 120 |
+-----+