Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hawq.incubator.apache.org
From: prnair@pivotal.io
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (1.0)
Subject: Re: [jira] [Created] (HAWQ-981) create PXF External tables in HAWQ,Query error
Message-Id: <374A9BAB-47CB-468F-B1D4-136461B2D4E2@pivotal.io>
Date: Thu, 4 Aug 2016 18:43:01 -0700
References: <JIRA.12995071.1470359527000@Atlassian.JIRA> <JIRA.12995071.1470359527945@arcas> <JIRA.12995071.1470359527000.230199.1470359540441@Atlassian.JIRA> <936E0A8E-5A80-412B-BEA6-26B4623B6114@pivotal.io>
In-Reply-To: <936E0A8E-5A80-412B-BEA6-26B4623B6114@pivotal.io>
To: "dev@hawq.incubator.apache.org" <dev@hawq.incubator.apache.org>
archived-at: Fri, 05 Aug 2016 01:43:11 -0000

Sorry typo 50700 to 51200 and please make sure pxf is running on port 51200

Sent from my iPhone

> On Aug 4, 2016, at 6:41 PM, prnair@pivotal.io wrote:
>=20
> Change port from 5700 to 51200
>=20
> Sent from my iPhone
>=20
>> On Aug 4, 2016, at 6:12 PM, litiebiao (JIRA) <jira@apache.org> wrote:
>>=20
>> litiebiao created HAWQ-981:
>> ------------------------------
>>=20
>>            Summary: create PXF External tables in HAWQ,Query error=20
>>                Key: HAWQ-981
>>                URL: https://issues.apache.org/jira/browse/HAWQ-981
>>            Project: Apache HAWQ
>>         Issue Type: Bug
>>           Reporter: litiebiao
>>           Assignee: Lei Chang
>>=20
>>=20
>> create EXTERNAL table DR_S1APP2P_TDR_20160720(
>> PROTOCOLID     SMALLINT,
>> GLOBALID        NUMERIC(22),
>> SESSIONID       NUMERIC(22),
>> CDRID   NUMERIC(22),
>> XDRTYPE SMALLINT,
>> IMSI    VARCHAR(16),
>> IMEI    VARCHAR(26),
>> MSISDN  VARCHAR(26),
>> EVENTID SMALLINT,
>> BTIME   timestamp,
>> ETIME   timestamp,
>> EVENTRESULT     SMALLINT,
>> EVENTCAUSE     SMALLINT,
>> REQUESTCAUSE   SMALLINT,
>> EVENTTYPE       SMALLINT,
>> EVENTTYPE1      SMALLINT,
>> MMEADDRESS      VARCHAR(40),
>> ENBADDRESS      VARCHAR(40),
>> MMEPORT SMALLINT,
>> ENBPORT SMALLINT,
>> MMES1APUEID     INT,
>> ENBS1APUEID     INT,
>> MMEGRPID       SMALLINT,
>> MMECODE SMALLINT,
>> MTMSI   VARCHAR(8),
>> OLDGUTITYPE     SMALLINT,
>> OLDMMEGRPID    SMALLINT,
>> OLDMMECODE      SMALLINT,
>> OLDMTMSI        VARCHAR(8),
>> TMSI    VARCHAR(8),
>> UEIPV4ADDR      VARCHAR(40),
>> UEIPV6ADDR      VARCHAR(40),
>> ETAC   SMALLINT,
>> PEERTAC SMALLINT,
>> ECI     INT,
>> PEERECI INT,
>> LAC    SMALLINT,
>> OLDLAC SMALLINT,
>> CSFBRESULT      SMALLINT,
>> NASPROCFLAG     SMALLINT,
>> S1APPROCFLAG    SMALLINT,
>> ERABFLAG        SMALLINT,
>> PAGINGTYPE      SMALLINT,
>> VOICEDOMAIN     SMALLINT,
>> PAGINGDOMAIN    SMALLINT,
>> UECENTRIC       SMALLINT,
>> VOPSOPT SMALLINT,
>> EMMCAUSE       SMALLINT,
>> ESMCAUSE       SMALLINT,
>> CTXTSTPCAUSE   SMALLINT,
>> CTXTMODCAUSE   SMALLINT,
>> S1RELCAUSE     SMALLINT,
>> AUTHREQOFFSET  SMALLINT,
>> AUTHRESOFFSET  SMALLINT,
>> SECUCMDOFFSET  SMALLINT,
>> SECUCPLOFFSET  SMALLINT,
>> CTXTSTPREQOFFSET       SMALLINT,
>> CTXTSTPRSPOFFSET       SMALLINT,
>> PAGINGRSPOFFSET SMALLINT,
>> CTXTMODREQOFFSET        INT,
>> CTXTMODRSPOFFSET        INT,
>> S1RELOFFSET     INT,
>> INITREQERABNUM  SMALLINT,
>> INITSUCERABNUM  SMALLINT,
>> STPREQERABNUM   SMALLINT,
>> STPSUCERABNUM   SMALLINT,
>> MODREQERABNUM   SMALLINT,
>> MODSUCERABNUM   SMALLINT,
>> CTXTSTPSTATUS   SMALLINT,
>> CTXTMODSTATUS   SMALLINT,
>> AUTHSTATUS      SMALLINT,
>> SECUSTATUS      SMALLINT,
>> CAUSE1 SMALLINT,
>> CAUSE2 SMALLINT,
>> OFFSET1 INT,
>> OFFSET2 INT,
>> CALLINGNUM      VARCHAR(26),
>> CALLEDNUM       VARCHAR(26),
>> SMCNUMBER       VARCHAR(26),
>> ATAC   SMALLINT,
>> AECI    INT,
>> UCUESRVCCSUPPORT        SMALLINT,
>> EVENTCAUSETYPE SMALLINT,
>> REQEVENTCAUSETYPE      SMALLINT,
>> ENBID  SMALLINT,
>> ENBMID SMALLINT,
>> MMEID  SMALLINT,
>> MMEMID SMALLINT,
>> AREAID SMALLINT,
>> TAC     VARCHAR(8),
>> UETYPEID       SMALLINT,
>> TYPEID SMALLINT,
>> MANUFACTURERID SMALLINT,
>> RECVTIME        timestamp,
>> REGIONID       SMALLINT,
>> XDRNUMBER      SMALLINT,
>> SESSIONQCI     SMALLINT
>> )  LOCATION ('pxf://10.213.39.234:50070/apps/hbase/data/data/default/DR_S=
1APP2P_TDR_20160720?profile=3DHdfsTextSimple')
>> FORMAT 'TEXT' (DELIMITER =3D E'\t');
>>=20
>> select * from DR_S1APP2P_TDR_20160720 limit 10;
>> ERROR:  remote component error (0) from '10.213.39.234:50070': Failed con=
nect to 10.213.39.234:50070; Connection timed out (libchurl.c:878)
>>=20
>> ********** =E9=94=99=E8=AF=AF **********
>>=20
>> ERROR: remote component error (0) from '10.213.39.234:50070': Failed conn=
ect to 10.213.39.234:50070; Connection timed out (libchurl.c:878)
>> SQL =E7=8A=B6=E6=80=81: XX000
>>=20
>>=20
>>=20
>>=20
>>=20
>> --
>> This message was sent by Atlassian JIRA
>> (v6.3.4#6332)