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:[email protected]]
Sent: Friday, December 2, 2016 7:55 AM
To: [email protected]
Subject: Re: how to create a table NOT using aligned format?
Sorry for the typo. It is 'attribute hbase format'
Selva
________________________________
From: Selva Govindarajan
<[email protected]<mailto:[email protected]>>
Sent: Friday, December 2, 2016 7:53 AM
To:
[email protected]<mailto:[email protected]>
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) <[email protected]<mailto:[email protected]>>
Sent: Friday, December 2, 2016 1:07 AM
To:
[email protected]<mailto:[email protected]>
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
