Skip to main content

  • ​
    clearTable

    public ClearTableResponse clearTable(ClearTableRequest request) throws GPUdbException
    Clears (drops) one or all tables in the database cluster. The operation is synchronous meaning that the table will be cleared before the function returns. The response payload returns the status of the operation along with the name of the table that was cleared.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    clearTable

    public ClearTableResponse clearTable(String tableName, String authorization, Map<String,String> options) throws GPUdbException
    Clears (drops) one or all tables in the database cluster. The operation is synchronous meaning that the table will be cleared before the function returns. The response payload returns the status of the operation along with the name of the table that was cleared.
    Parameters:
    tableName - Name of the table to be cleared, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table. Empty string clears all available tables, though this behavior is be prevented by default via gpudb.conf parameter ‘disable_clear_all’. The default value is ”.
    authorization - No longer used. User can pass an empty string. The default value is ”.
    options - Optional parameters.
    • NO_ERROR_IF_NOT_EXISTS: If TRUE and if the table specified in tableName does not exist no error is returned. If FALSE and if the table specified in tableName does not exist then an error is returned. Supported values:The default value is FALSE.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.