You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@trafodion.apache.org by mathieu ferlay <mf...@gnubila.fr> on 2017/03/16 07:39:03 UTC

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

Posted by mathieu ferlay <mf...@gnubila.fr>.

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.owhadi@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:mferlay@gnubila.fr] 
Sent: Thursday, March 16, 2017 2:46 AM
To: user@trafodion.incubator.apache.org <ma...@trafodion.incubator.apache.org> 
Subject: RE: issue with a request

 

Thanks Benny.

 

Best regard

 

FERLAY Mathieu

 

 

De : Wang, Ai-Min (Benny) [mailto:aimin.wang@esgyn.cn] 
Envoyé : jeudi 16 mars 2017 08:42
À : user@trafodion.incubator.apache.org <ma...@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.wang@esgyn.cn <ma...@esgyn.cn> 

 

From: mathieu ferlay [mailto:mferlay@gnubila.fr] 
Sent: Thursday, March 16, 2017 3:39 PM
To: user@trafodion.incubator.apache.org <ma...@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

RE: issue with a request

Posted by Eric Owhadi <er...@esgyn.com>.

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:mferlay@gnubila.fr]
Sent: Thursday, March 16, 2017 2:46 AM
To: user@trafodion.incubator.apache.org
Subject: RE: issue with a request

Thanks Benny.

Best regard

FERLAY Mathieu


De : Wang, Ai-Min (Benny) [mailto:aimin.wang@esgyn.cn]
Envoyé : jeudi 16 mars 2017 08:42
À : user@trafodion.incubator.apache.org<ma...@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.wang@esgyn.cn<ma...@esgyn.cn>

From: mathieu ferlay [mailto:mferlay@gnubila.fr]
Sent: Thursday, March 16, 2017 3:39 PM
To: user@trafodion.incubator.apache.org<ma...@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

RE: issue with a request

Posted by mathieu ferlay <mf...@gnubila.fr>.

Thanks Benny.

 

Best regard

 

FERLAY Mathieu

 

 

De : Wang, Ai-Min (Benny) [mailto:aimin.wang@esgyn.cn] 
Envoyé : jeudi 16 mars 2017 08:42
À : 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.wang@esgyn.cn <ma...@esgyn.cn> 

 

From: mathieu ferlay [mailto:mferlay@gnubila.fr] 
Sent: Thursday, March 16, 2017 3:39 PM
To: user@trafodion.incubator.apache.org <ma...@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

RE: issue with a request

Posted by "Wang, Ai-Min (Benny)" <ai...@esgyn.cn>.

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.wang@esgyn.cn

From: mathieu ferlay [mailto:mferlay@gnubila.fr]
Sent: Thursday, March 16, 2017 3:39 PM
To: 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