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:43:01 GMT
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:
> 
> 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