Change port from 5700 to 51200 Sent from my iPhone
> On Aug 4, 2016, at 6:12 PM, litiebiao (JIRA) <[email protected]> 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)
