filed JIRA: HAWQ-932 <https://issues.apache.org/jira/browse/HAWQ-932>
On Fri, Jul 15, 2016 at 11:11 AM Oleksandr Diachenko <[email protected]> wrote: > 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. >
