dat',
>> 'gpfdist://segment1:9001/call_center_[0-9]*_[0-9]*.dat',
>> 'gpfdist://segment1:9002/call_center_[0-9]*_[0-9]*.dat',
>> 'gpfdist://segment1:9003/call_center_[0-9]*_[0-9]*.dat',
>> 'gpfdist://segment1:9004/call_center_[0-9]*_[0-9]*.dat',
>> 'gpfdist://segment1:9
ll_center_[0-9]*_[0-9]*.dat',
> 'gpfdist://segment1:9004/call_center_[0-9]*_[0-9]*.dat',
> 'gpfdist://segment1:9005/call_center_[0-9]*_[0-9]*.dat',
> 'gpfdist://segment1:9006/call_center_[0-9]*_[0-9]*.dat')
> FORMAT 'TEXT' (DELIMITER '|' NULL AS '' ESCAPE AS E'\\');
>
> insert into cal
TER '|' NULL AS '' ESCAPE AS E'\\');
insert into call_center select * from ext_call_center;
ERROR: External scan error: There are more external files (URLs) than primary
segments that can read them (COptTasks.cpp:1756)
hawq config >>>>:
GUC: add_missing_fromValue: off
GUC: app
ted using "like target_table"
> statement) ,
> if the target table was distributed by some column(s), it raise this error:
> External scan error: There are more external files (URLs) than primary
> segments that can read them (COptTasks.cpp:1756)
> if the target table was
Hi,all:
I am testing hawq 2.0.0 , and I find a problem like this:
I load data from an external table (created using "like target_table"
statement) ,
if the target table was distributed by some column(s), it raise this error:
External scan error: There are more external files (