[jira] [Created] (HAWQ-981) create PXF External tables in HAWQ,Query error

["litiebiao (JIRA)" <ji...@apache.org>]

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)