@anna -- Can you make it into a single file of a single step by using UNION ALL and exporting all tables at once?
INSERT INTO FILES(
"path"="
s3a://Folder/ABC",
...
"aws.s3.endpoint"="
http://10.50.10.160:30104)
SELECT COL_A From TABLE_A
UNION ALL SELECT COL_B From TABLE_B
UNION ALL SELECT COL_C From TABLE_C;
NOTE: This won't take care of duplicates, but I figure you can do that before you run the export.