Hi, I noticed, that external table which uses localhost is no longer works in Hawq, but it used to work before.
*template1=# CREATE EXTERNAL TABLE ext_table1 (t1 text, t2 text, num1 integer, dub1 double precision) LOCATION (E'pxf://localhost:51200/hive_small_data?PROFILE=Hive') FORMAT 'CUSTOM' (formatter='pxfwritable_import');* *CREATE EXTERNAL TABLE* *template1=# select * from ext_table1;* *ERROR: remote component error (0): (libchurl.c:898)* When I turned on debug mode in curl, I found this error in logs - "* Closing connection 0". I found a workaround, to set CURLOPT_RESOLVE option in curl: *struct curl_slist *host = NULL;* * host = curl_slist_append(NULL, "localhost:51200:127.0.0.1");* * set_curl_option(context, CURLOPT_RESOLVE, host);* It seems like an issue with DNS cache, any ideas? Regards, Alex.
