Thanks Eric, For the moment i’ll just try to migrate our script from sql to trafodion but I notice it for our second phase corresponding to the optimization.
Regards, Mathieu De : Eric Owhadi [mailto:eric.owh...@esgyn.com] Envoyé : jeudi 16 mars 2017 14:36 À : user@trafodion.incubator.apache.org Objet : RE: issue with a request Hi Mathieu, Just a small comment: you are using UTF8 for storing UUID, on a VARCHAR. If this is just for testing functionality that’s OK. But for real production and high volume, if you want to optimize, please consider: CHAR(36) CHARACTER SET ISO88591 Trafodion would reserve 4 times more space for the key in UTF8 compared to ISO88591 plus 2 bytes for variable length of varchar that is not needed since UUID are always 36 char long. Hope this helps, Eric From: mathieu ferlay [mailto:mfer...@gnubila.fr] Sent: Thursday, March 16, 2017 2:46 AM To: user@trafodion.incubator.apache.org <mailto:user@trafodion.incubator.apache.org> Subject: RE: issue with a request Thanks Benny. Best regard FERLAY Mathieu De : Wang, Ai-Min (Benny) [mailto:aimin.w...@esgyn.cn] Envoyé : jeudi 16 mars 2017 08:42 À : user@trafodion.incubator.apache.org <mailto:user@trafodion.incubator.apache.org> Objet : RE: issue with a request Hi: Pleaes use following sql， UUID is reserved word and please use “” to enclose it： CREATE TABLE IF NOT EXISTS Token ( "UUID" VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL, Expiration DATE NOT NULL, SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL, PRIMARY KEY ("UUID") ); Best Regrard！ Benny/Wang Aimin MP：13501196050 Mail：aimin.w...@esgyn.cn <mailto:aimin.w...@esgyn.cn> From: mathieu ferlay [mailto:mfer...@gnubila.fr] Sent: Thursday, March 16, 2017 3:39 PM To: user@trafodion.incubator.apache.org <mailto:user@trafodion.incubator.apache.org> Subject: issue with a request Hi everybody, i try to load these following lines: CREATE TABLE IF NOT EXISTS Token ( UUID VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL, Expiration DATE NOT NULL, SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL, PRIMARY KEY (UUID) ); But I obtain systematically a mistake on UUID. Do you know how to success it with this column’s name? Thanks, Regards FERLAY Mathieu
