Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ Common HetuEngine SQL Syntax/ HetuEngine DDL SQL Syntax/ DROP FUNCTION
Updated on 2024-12-13 GMT+08:00
View PDF
Share

DROP FUNCTION

Syntax

DROP FUNCTION [ IF EXISTS ] qualified_function_name

Description

It is used to delete an existing function that matches the given function name. If no matching function exists, the optional IF EXISTS clause will cause the NOT_FOUND error to be suppressed.

Example

  • Delete the example.namespace01.date_diff function:

    DROP FUNCTION example.namespace01.date_diff

  • Delete the example.namespace01.date_diff function if it exists:

    DROP FUNCTION IF EXISTS example.namespace01.date_diff