RE: how to create a table NOT using aligned format?

[Liu, Ming (Ming)]

thanks Anoop and Selva,
Ming

From: Anoop Sharma [mailto:anoop.sha...@esgyn.com]
Sent: Saturday, December 03, 2016 12:43 AM
To: user@trafodion.incubator.apache.org
Subject: RE: how to create a table NOT using aligned format?

you can either set the attribute in create stmt as Selva mentioned,
or set the cqd traf_aligned_row_format 'OFF'.

Here is an example of creating it.

To check the file format of a table, do showddl.

If it shows 'attribute aligned format', then it is aligned format.
It it doesn't show anything, then it is is hbase (one value per cell) format.


>>create table t (a int) attribute hbase format;

--- SQL operation complete.
>>cqd traf_aligned_row_format 'OFF';

--- SQL operation complete.
>>create table t1 (a int);

--- SQL operation complete.
>>showddl t;

CREATE TABLE TRAFODION.SCH.T
  (
    A                                INT DEFAULT NULL SERIALIZED
  )
;

-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SCH.T TO 
DB__ROOT WITH GRANT OPTION;

--- SQL operation complete.
>>showddl t1;

CREATE TABLE TRAFODION.SCH.T1
  (
    A                                INT DEFAULT NULL SERIALIZED
  )
;

-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TRAFODION.SCH.T1 TO 
DB__ROOT WITH GRANT OPTION;

--- SQL operation complete.
>>

From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
Sent: Friday, December 2, 2016 7:55 AM
To: 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: Re: how to create a table NOT using aligned format?


Sorry for the typo. It is 'attribute hbase format'



Selva

________________________________
From: Selva Govindarajan 
<selva.govindara...@esgyn.com<mailto:selva.govindara...@esgyn.com>>
Sent: Friday, December 2, 2016 7:53 AM
To: 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: Re: how to create a table NOT using aligned format?


You can use the clause 'attribut hebase format' in the create table statement.



Selva

________________________________
From: Liu, Ming (Ming) <ming....@esgyn.cn<mailto:ming....@esgyn.cn>>
Sent: Friday, December 2, 2016 1:07 AM
To: 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Subject: how to create a table NOT using aligned format?


hi, all,



With latest Trafodion build, when I create a table, it is in aligned format by 
default.

What is the syntax to create table that is NOT aligned format?



thanks,

Ming