amazon web services - How to load gzipped json data from a copy -


copy tmp_data 's3://mybucket/copy/batch_insert_data_1417072335118.json'  credentials 'aws_access_key_id=xxxxxxxxxxxxxxx;aws_secret_access_key=yyyyyyyyyyyyyyyyyyyyyyyyy' json gzip acceptinvchars ' ' truncatecolumns trimblanks; 

above copy command works without gzip. want use gzip speed process. im uploading gzipped json file s3 bucket. above copy command not work? idea how load gzipped json file copy in redshift?

you missing json_option (http://docs.aws.amazon.com/redshift/latest/dg/r_copy.html). try setting 'auto'. see corrected example below:

copy tmp_data 's3://mybucket/copy/batch_insert_data_1417072335118.json'  credentials 'aws_access_key_id=xxxxxxxxxxxxxxx;aws_secret_access_key=yyyyyyyyyyyyyyyyyyyyyyyyy' json 'auto' gzip acceptinvchars ' ' truncatecolumns trimblanks; 

Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -