--------- '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;
----------------------------
external table force quoting
Moderators: chulett, rschirm, roy
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...
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...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: