hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prn...@pivotal.io
Subject Re: [jira] [Created] (HAWQ-981) create PXF External tables in HAWQ,Query error
Date Fri, 05 Aug 2016 01:41:34 GMT
Change port from 5700 to 51200

Sent from my iPhone

> On Aug 4, 2016, at 6:12 PM, litiebiao (JIRA) <jira@apache.org> wrote:
> 
> litiebiao created HAWQ-981:
> ------------------------------
> 
>             Summary: create PXF External tables in HAWQ,Query error 
>                 Key: HAWQ-981
>                 URL: https://issues.apache.org/jira/browse/HAWQ-981
>             Project: Apache HAWQ
>          Issue Type: Bug
>            Reporter: litiebiao
>            Assignee: Lei Chang
> 
> 
> 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_S1APP2P_TDR_20160720?profile=HdfsTextSimple')
> FORMAT 'TEXT' (DELIMITER = E'\t');
> 
> select * from DR_S1APP2P_TDR_20160720 limit 10;
> ERROR:  remote component error (0) from '10.213.39.234:50070': Failed connect to 10.213.39.234:50070;
Connection timed out (libchurl.c:878)
> 
> ********** 错误 **********
> 
> ERROR: remote component error (0) from '10.213.39.234:50070': Failed connect to 10.213.39.234:50070;
Connection timed out (libchurl.c:878)
> SQL 状态: XX000
> 
> 
> 
> 
> 
> --
> This message was sent by Atlassian JIRA
> (v6.3.4#6332)

Mime
View raw message