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, [email protected] wrote: > > 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)
