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

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

Tagged:

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file