external table force quoting

[dsfamily]

--------- 'gpfdist://172.30.208.100:8881/RATES_EHCRPT_File1.CSV',
----- 'gpfdist://172.30.208.100:8882/RATES_EHCRPT_File2.CSV',
----- 'gpfdist://172.30.208.100:8883/RATES_EHCRPT_File3.CSV',
----- 'gpfdist://172.30.208.100:8884/RATES_EHCRPT_File4.CSV',
----- 'gpfdist://172.30.208.100:8885/RATES_EHCRPT_File5.CSV'

--------- Creation of external tables ----------------------

-- External Table: gtr_irs_rpt.rates_ehcrpt_880

-- DROP EXTERNAL TABLE gtr_irs_rpt.rates_ehcrpt_880;

CREATE EXTERNAL TABLE gtr_irs_rpt.rates_ehcrpt_Ext
(
ocode text ,
submitted_for_lei text ,
<snip huge list>
trd_prty1_non_fin_enty_jur text ,
trd_prty2_non_fin_enty_jur text ,
send_to text
)
LOCATION (
'gpfdist://172.30.208.100:8881/RATES_EHCRPT_File1.CSV',
'gpfdist://172.30.208.100:8882/RATES_EHCRPT_File2.CSV',
'gpfdist://172.30.208.100:8883/RATES_EHCRPT_File3.CSV',
'gpfdist://172.30.208.100:8884/RATES_EHCRPT_File4.CSV',
'gpfdist://172.30.208.100:8885/RATES_EHCRPT_File5.CSV'
)
FORMAT 'csv' (delimiter ',' null '' escape '"' quote '"' force quote submitted_for_lei,submitted_for_name,trade_type_indicator,
<snip huge list>
,trd_prty1_non_fin_enty_jur,trd_prty2_non_fin_enty_jur,send_to)
ENCODING 'UTF8';

grant insert on gtr_irs_rpt.rates_ehcrpt_Ext to gtr_dev;
GRANT insert on gtr_irs_rpt.rates_ehcrpt_Ext TO vchoppa;
GRANT insert on gtr_irs_rpt.rates_ehcrpt_Ext TO jxgeorge;
----------------------------

[chulett]

Can we get the actual error, please? And a question would have been nice, too.

Note that I removed an enormous quantity of column names in your example, don't see them adding any value and they made the display... awkward. I've saved them off if they become relevant...

[ray.wurlod]

You might get better answers posting on a Oracle forum such as AskTom.

[chulett]

I believe they are trying to import metadata from that DDL.

(see Additional Info)