RE: issue with a request

mathieu ferlay Thu, 16 Mar 2017 07:48:06 -0700

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:[email protected]] 
Envoyé : jeudi 16 mars 2017 14:36
À : [email protected]
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:[email protected]] 
Sent: Thursday, March 16, 2017 2:46 AM
To: [email protected] 
<mailto:[email protected]> 
Subject: RE: issue with a request

 

Thanks Benny.

 

Best regard

 

FERLAY Mathieu

 

 

De : Wang, Ai-Min (Benny) [mailto:[email protected]] 
Envoyé : jeudi 16 mars 2017 08:42
À : [email protected] 
<mailto:[email protected]> 
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：[email protected] <mailto:[email protected]> 

 

From: mathieu ferlay [mailto:[email protected]] 
Sent: Thursday, March 16, 2017 3:39 PM
To: [email protected] 
<mailto:[email protected]> 
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

RE: issue with a request

Reply via email to