hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Goden Yao <goden...@apache.org>
Subject Re: CURL issues with localhost in HAWQ
Date Mon, 18 Jul 2016 18:47:51 GMT
filed JIRA: HAWQ-932  <https://issues.apache.org/jira/browse/HAWQ-932>

On Fri, Jul 15, 2016 at 11:11 AM Oleksandr Diachenko <odiachenko@pivotal.io>
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.
>

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