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

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'


*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:");*

* set_curl_option(context, CURLOPT_RESOLVE, host);*

It seems like an issue with DNS cache, any ideas?

Regards, Alex.

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