Skip to main content
Question

GETTING ERROR[2202B] on running COPY command from s3 object

  • March 5, 2025
  • 1 reply
  • 1 view

srijan

I am running a copy command on vertica db with version 12.0x to copy file data from s3 to my table. Getting following error => ERROR[2202B] Conflicting or Redundant option. What can be the source of failure with the below query:

COPY common.temp_catalogue (google_product_category,link,product_type,shipping,brand,currency,size,color,description,image_link,item_group_id,price,prid,sale_price,title,availability,catalogue_name,collection,quantity,tags) FROM 's3://data-store.csv.gz'
GZIP
DELIMITER ','
NULL AS 'NULL'
ENCLOSED BY '"'
NULL AS 'NULL';

1 reply

Vertica_Curtis
Forum|alt.badge.img+1
  • Participating Frequently
  • March 5, 2025

You've defined NULL AS 'NULL' twice in your copy operation.