DROP FUNCTION Statement
Removes a user-defined function (UDF), so that it is not available for execution during Impala SELECT or INSERT operations.
DROP [AGGREGATE] FUNCTION [IF EXISTS] [db_name.]function_name(type[, type...])
Statement type: DDL
Because the same function name could be overloaded with different argument signatures, you specify the argument types to identify the exact function to drop.
Currently, Impala UDFs and UDAs written in C++ are not persisted in the metastore database. Information about these functions is held in the memory of the catalogd daemon. You must reload them by running the CREATE FUNCTION statements again each time you restart the catalogd daemon. This limitation does not apply to Impala UDFs and UDAs written in Java.
Cancellation: Cannot be cancelled.
|<< DROP DATABASE Statement||DROP ROLE Statement (CDH 5.2 or higher only) >>|