Re: Re: External scan error: There are more external files (URLs) than primary segments that can read them (COptTasks.cpp:1756)

2016-09-21 Thread Luis Macedo
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

Re: Re: External scan error: There are more external files (URLs) than primary segments that can read them (COptTasks.cpp:1756)

2016-09-21 Thread Vineet Goel
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

回复:Re: External scan error: There are more external files (URLs) than primary segments that can read them (COptTasks.cpp:1756)

2016-09-21 Thread 来熊
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

Re: External scan error: There are more external files (URLs) than primary segments that can read them (COptTasks.cpp:1756)

2016-09-20 Thread Vineet Goel
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

External scan error: There are more external files (URLs) than primary segments that can read them (COptTasks.cpp:1756)

2016-09-20 Thread 来熊
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 (