Amazon S3 output
Posted: Tue Feb 11, 2020 6:24 pm
When writing to Amazon S3 we have the fields delimited by a comma (,). The rows are enclosed in double quotes. The Quotation Mark property in the S3 stage controls the column quotations. is there a property or setting that will turn off the double quotes for the rows?
Ex: this is what Amazon S3 admin is seeing in the S3 files
"LCLS,306048214593355542501394290,20-JAN-20 02.39.14.565007 PM"
"LCLS,994570338530973782655923294,20-JAN-20 02.43.28.350008 PM"
"LCLS,234645550397601429848923658,20-JAN-20 03.24.18.888892 PM"
Thanks
Ex: this is what Amazon S3 admin is seeing in the S3 files
"LCLS,306048214593355542501394290,20-JAN-20 02.39.14.565007 PM"
"LCLS,994570338530973782655923294,20-JAN-20 02.43.28.350008 PM"
"LCLS,234645550397601429848923658,20-JAN-20 03.24.18.888892 PM"
Thanks