We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


COPY FROM S3 OBJECT WORKING ON CLI BUT NOT WORKING WHILE ON CODE. — Vertica Forum

COPY FROM S3 OBJECT WORKING ON CLI BUT NOT WORKING WHILE ON CODE.

My objective is to dump s3 file data into temp table. I tried create a temp_Data table and execute COPY Command with valid aws region, aws access key and secret key.
COPY FROM S3 OBJECT COPY temp_Data ("userid", "user_name") FROM 's3://app-upload/data.csv.gz' GZIP DELIMITER ',' ENCLOSED BY '"' NULL AS 'NULL'
Over it. When I execute it locally it inserts users into vsql . But when I execute on golang it fails saying Unable to do get rows impacted no RowsAffected available after DDL statement what can be the reason of failure

Tagged:

Leave a Comment

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