You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/11/12 17:26:10 UTC
[jira] [Created] (TRAFODION-1619) Queries with SELECT [FIRST 1]
have their scan cache size set too large
Suresh Subbiah created TRAFODION-1619:
-----------------------------------------
Summary: Queries with SELECT [FIRST 1] have their scan cache size set too large
Key: TRAFODION-1619
URL: https://issues.apache.org/jira/browse/TRAFODION-1619
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 1.2-incubating
Reporter: Suresh Subbiah
Assignee: Suresh Subbiah
select [first 1] * from bseg takes a while to complete.
This was determined to be due to scan cache size being larger than necessary.Please try to limit scan cache size based on the number of rows requested in FIRST N syntax.
DDL
>>showddl bseg;
CREATE TABLE TRAFODION.NEWTEST.BSEG
(
MANDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BUKRS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BELNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, GJAHR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BUZEI VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BUZID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGCP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGBL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BSCHL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KOART VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, UMSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, UMSKS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZUMSK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SHKZG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GSBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PARGB VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MWSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, QSSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, KZBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PSWBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PSWSL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXBHW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, TXBFW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSTS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WMWST NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, HWBAS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FWBAS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, HWZUZ NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FWZUZ NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SHZUZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STEKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MWART VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXGRP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KTOSL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, QSSHB NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, KURSR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, GBETR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BDIFF NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BDIF2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, VALUT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZUONR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SGTXT VARCHAR(200 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZINKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBUND VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BEWAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ALTKT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VORGN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FDLEV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FDGRP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FDWBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FDTAG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FKONT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KOKRS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KOSTL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PROJN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUFNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBELN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBEL2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, POSN2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ETEN2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANLN1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANLN2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANBWA VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BZDAT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PERNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XUMSW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XHRES VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XKRES VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XOPVW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XCPDD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSKST VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSAUF VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSPRO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSERG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XFAKT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XUMAN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XANET VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSKRL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XINVE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XPANZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XAUTO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XNCOP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XZAHL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SAKNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HKONT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KUNNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LIFNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FILKD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XBILK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GVTYP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HZUON VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZFBDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZTERM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZBD1T NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD2T NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD3T NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD1P NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD2P NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKFBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKNTO NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WSKTO NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZLSCH VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZLSPR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZBFIX VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HBKID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BVTYP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, NEBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSK1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBT1 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBT1 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSK2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBT2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBT2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSK3 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBT3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBT3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, REBZG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REBZJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REBZZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REBZT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZOLLT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZOLLD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LZBKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LANDL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DIEKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SAMNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ABPER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VRSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VRSDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DISBN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DISBJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DISBZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, WVERW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFBN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFBJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFBU VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFAE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BLNBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BLNKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BLNPZ NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MSCHL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MANSP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MADAT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MANST VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MABER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ESRNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ESRRE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ESRPZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KLIBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, QSZNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, QBSHB NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, QSFBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVHW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVFW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MATNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, WERKS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MENGE NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MEINS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ERFMG NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ERFME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BPMNG NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BPRME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EBELN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EBELP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZEKKN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ELIKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VPRSV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PEINH NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BWKEY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BWTAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BUSTW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REWRT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, REWWR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BONFB NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BUALT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PSALT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, NPREI NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, TBTKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STCEG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EGBLD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EGLLD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RSTGR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RYACQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RPACQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RDIFF NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, RDIF2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PRCTR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XHKOM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VNAME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RECID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EGRUP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VPTNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VERTT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VERTN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBEWA VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DEPOT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXJCD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, IMKEY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DABRZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, POPTS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FIPOS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KSTRG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, NPLNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUFPL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, APLZL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PROJK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, PAOBJNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PASUBNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BTYPE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ETYPE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XEGDR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LNRAN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HRKFT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBE2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMBE3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB21 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB22 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB23 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB31 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB32 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB33 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWST2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWST3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVH2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVH3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKNT2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKNT3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BDIF3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, RDIF3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, HWMET VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GLUPM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XRAGL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, UZAWE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LOKKT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FISTL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GEBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STBUK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXBH2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, TXBH3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PPRCT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XREF1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XREF2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KBLNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KBLPOS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STTAX NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FKBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, OBZEI VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XNEGP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RFZEI VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, CCBTC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KKBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EMPFB VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XREF3 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS3 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS4 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GRICD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GRIRG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GITYP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XPYPR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KIDNO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ABSBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, IDXSP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LINFV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KONTT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KONTL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXDAT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AGZEI NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PYCUR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PYAMT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BUPLA VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SECCO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LSTAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, CESSION_KZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PRZNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PPDIFF NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PPDIF2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PPDIF3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENLC1 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENLC2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENLC3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENFC NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENDAYS NUMERIC(20, 0) DEFAULT NULL NOT SERIALIZED
, PENRC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GRANT_NBR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SCTAX NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FKBER_LONG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GMVKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SRTYPE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, INTRENO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MEASURE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGGJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PPA_EX_IND VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DOCLN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SEGMENT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PSEGMENT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PFKBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HKTID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KSTAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XLGCLR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TAXPS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PAYS_PROV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PAYS_TRAN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MNDID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XFRGE_BSEG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZGLLX VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZHZFC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZCGJG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZPAY_TY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZBUS_TY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZCUS1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZWLXQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZTAX_LIFN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZYIJIF VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZICTBM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZCP_ABC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZKH_ABC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZWY_ABC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZGLSBM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PGEBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PGRANT_NBR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BUDGET_PD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PBUDGET_PD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PEROP_BEG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PEROP_END VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FASTPAY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, IGNR_IVREF VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PRODPER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZDATE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZTIME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PRIMARY KEY (GJAHR ASC, BUZEI ASC, BELNR ASC, BUKRS ASC, PROJK ASC, MANDT
ASC)
)
SALT USING 72 PARTITIONS
ON (BELNR)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'SNAPPY',
MEMSTORE_FLUSH_SIZE = '1073741824'
)
;
--- SQL operation complete.
>>exit;
End of MXCI Session
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)