You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lili Ma (JIRA)" <ji...@apache.org> on 2016/03/16 07:27:33 UTC

[jira] [Resolved] (HAWQ-510) Interconnect error(Could not pare remote listeneraddress '[local]') during running query with generate_series

     [ https://issues.apache.org/jira/browse/HAWQ-510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lili Ma resolved HAWQ-510.
--------------------------
       Resolution: Fixed
    Fix Version/s: 2.0.0

> Interconnect error(Could not pare remote listeneraddress '[local]') during running query with generate_series
> -------------------------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-510
>                 URL: https://issues.apache.org/jira/browse/HAWQ-510
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Interconnect
>            Reporter: Lili Ma
>            Assignee: Lili Ma
>             Fix For: 2.0.0
>
>
> Running below query meets can't parse remote listeneraddress error.
> {code}
> CREATE TABLE t (key INT, value INT) DISTRIBUTED RANDOMLY;
> INSERT INTO t VALUES (1, 0);
> postgres=# SELECT t2.key, t2.value                                                                        FROM                                                                                                      (SELECT key, value FROM t WHERE value = 0) AS t1,                                                         (SELECT generate_series(1, 2)::INT AS key, 0::INT AS value ) AS t2                                        WHERE t1.value = t2.value;
> ERROR:  Interconnect Error: Could not parse remote listeneraddress: '[local]' port '58162': Name or service not known  (seg0 test1:21000 pid=25039)
> DETAIL:  getaddrinfo() unable to parse address: '[local]'
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)