Re: create table failed

Thanks for all your valuable replies. I tried VARCHAR 16 BYTES, it goes well. SQL>CREATE TABLE EVENT_BYTES ( v_date timestamp(6) NOT NULL, sid varchar(16 BYTES) NOT NULL DEFAULT '', uid varchar(16 BYTES) NOT NULL DEFAULT '', vid int unsigned NOT NULL , idx tinyint NOT

Re: create table failed

Hi, Another thing you can do is to specify the limit in the VARCHAR in bytes, not in characters. If you can do that and if you normally store 1, 2 or 3 byte characters in the key, that could be more efficient. When specifying the limit in characters, every UTF-8 character uses the maximum length

RE: create table failed

Hi, Qiao, This is a defect, would you please help to file a JIRA? I can reproduce it, will make some investigation on this issue. One workaround for you is to change the DDL a little: uid VARCHAR(255) to VARCHAR(254) Hope it works for you. Thanks, Ming From: 乔彦克 [mailto:qya...@gmail.com]

create table failed

Hi,all Now I've got new problems. Since I have date in my columns, I want to try the division feature of trafodion. I use the bellow sql to create tables, but only get these errors " ERROR[29157] There was a problem reading from the server* ERROR[29160] The message header was not long

Re: WARNING[6008] Statistics for column were not available

Thanks Henry, now the query works fine. Many thanks again. Henry Lin 于2016年8月17日周三 上午11:33写道： > Hi , > > > > Pls. create table and update statistics as below: > > > > CREATE TABLE EVENT_new ( > > v_date date NOT NULL, > > sid varchar(255) CHARACTER SET UTF8 NOT NULL