| ==== |
| ---- QUERY |
| create function hive_pi() returns double |
| location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' |
| symbol='org.apache.hadoop.hive.ql.udf.UDFPI'; |
| |
| create function hive_round(double) returns double |
| location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' |
| symbol='org.apache.hadoop.hive.ql.udf.UDFRound'; |
| |
| create function hive_floor(double) returns bigint |
| location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' |
| symbol='org.apache.hadoop.hive.ql.udf.UDFFloor'; |
| |
| create function hive_mod(int, int) returns int |
| location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' |
| symbol='org.apache.hadoop.hive.ql.udf.UDFPosMod'; |
| |
| create function hive_bin(bigint) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' |
| symbol='org.apache.hadoop.hive.ql.udf.UDFBin'; |
| |
| create function hive_lower(string) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' |
| symbol='org.apache.hadoop.hive.ql.udf.UDFLower'; |
| |
| # Used to test persistent java functions |
| create function identity_anytype |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(boolean) returns boolean |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(tinyint) returns tinyint |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(smallint) returns smallint |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(int) returns int |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(bigint) returns bigint |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(float) returns float |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(double) returns double |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(string) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(string, string) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function identity(string, string, string) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function hive_add(int, int) returns int |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function hive_add(smallint, smallint) returns smallint |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function hive_add(float, float) returns float |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function hive_add(double, double) returns double |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function hive_add(boolean, boolean) returns boolean |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdf'; |
| |
| create function throws_exception() returns boolean |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.TestUdfException'; |
| |
| create function replace_string(string) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.ReplaceStringUdf'; |
| |
| create function import_nearby_classes(string) returns string |
| location '$FILESYSTEM_PREFIX/test-warehouse/impala-hive-udfs.jar' |
| symbol='org.apache.impala.ImportsNearbyClassesUdf'; |
| ==== |