hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oleksandr Diachenko <odiache...@pivotal.io>
Subject CURL issues with localhost in HAWQ
Date Fri, 15 Jul 2016 18:11:44 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message