'Caused by: org.postgresql.util.PSQLException: ERROR: extra data after last expected column

I am trying to import a csv file to postgres db:

CREATE EXTERNAL TABLE dwh.stg.products_mapping_temp_ext (
    date varchar,
    product_code varchar,
    product_name varchar,
    product_operation_code varchar,
    product_operation_name varchar,
    department varchar,
    process_code varchar,
    process_name varchar,
    process_stage_code varchar,
    process_stage_name varchar
)
LOCATION (
    'gpfdist://worker:6666/dags/csv/quarter_kpi/products_mapping_temp_ext.csv'
) ON ALL
FORMAT 'CSV' ( delimiter ';' null '' escape '"' quote '"' header fill missing fields )
ENCODING 'WIN1251';

The content of my CSV is:

date; product_code; product_name; product_operation_code; product_operation_name;department;process_code;process_name ;process_stage_code;process_stage_name.

function is:

CREATE OR REPLACE FUNCTION etl.fnc_products_mapping_temp_sa_load()
    RETURNS void
    LANGUAGE plpgsql
    VOLATILE
AS $$
     BEGIN 
     TRUNCATE TABLE stg.products_mapping_temp; 
     INSERT INTO stg.products_mapping_temp(
        "date",
        product_code,
        product_name,
        product_operation_code,
        product_operation_name,
        department,
        process_code,
        process_name,
        process_stage_code,
        process_stage_name
    ) 
     SELECT 
        to_date("date", 'dd.mm.yyyy'),
        product_code,
        product_name,
        product_operation_code,
        product_operation_name,
        department,
        ltrim(rtrim(process_code)),
        ltrim(rtrim(process_name)),
        ltrim(rtrim(process_stage_code)),
        ltrim(rtrim(process_stage_name)) 
    FROM stg.products_mapping_temp_ext; 
     END; 
$$
EXECUTE ON ANY;


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source