if I create a UDF that has nothing to do with any table and just adds two numbers and returns the sum , how do I run it in hive since I understand there is nothing like "select <function-name> from dual; "
I don't have any arguments? I want to add some constant numbers inside the function and display the results .
this is a very valid situation where you don't have any arguments and jjust want to do something inside the function .
I get this error if I try to run the function with no arguments (since I don't have any)
> select qp(); FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments 'qp': No matching method for class com.demo.queryp with (). Possible choices: _FUNC_(string) hive>