You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Goden Yao (JIRA)" <ji...@apache.org> on 2016/08/08 17:30:20 UTC
[jira] [Assigned] (HAWQ-981) create PXF External tables in
HAWQ,Query error
[ https://issues.apache.org/jira/browse/HAWQ-981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Goden Yao reassigned HAWQ-981:
------------------------------
Assignee: Goden Yao (was: Lei Chang)
> 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
> Components: PXF
> Affects Versions: 2.0.0.0-incubating
> Reporter: litiebiao
> Assignee: Goden Yao
> Fix For: backlog
>
>
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)