'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 |
|---|
