ALTER TABLE Storage Conversion Example | VantageCloud Lake - Example: Convert Row-Format Table to Column-Format Table - Teradata Vantage

The following statement creates the Block File System table d1.tab1_bfs:

CREATE MULTISET TABLE d1.tab1_bfs, FALLBACK,
  NO BEFORE JOURNAL,
  NO AFTER JOURNAL,
  CHECKSUM = DEFAULT,
  DEFAULT MERGEBLOCKRATIO,
  MAP = TD_MAP1,
  (
   a INTEGER,
   b INTEGER
   c INTEGER
  )
  PRIMARY INDEX (a);

The following statement converts d1.tab1_bfs to an Object File System table:

ALTER TABLE d1.tab1_bfs, STORAGE = TD_OFSSTORAGE ORDER BY (a, b);

*** Warning: 4835 One or more table options ignored. Submit a SHOW TABLE to see resulting table definition.

The following statement shows the Object File System table definition:

SHOW TABLE d1.tab1_bfs;

CREATE MULTISET TABLE d1.tab1_bfs, NO FALLBACK,
  MAP = TD_MAP1,
  STORAGE = TD_OFSSTORAGE
  (
   a INTEGER,
   b INTEGER
   c INTEGER
  )
  ORDER BY (a, b)
  NO PRIMARY INDEX
  PARTITION BY COLUMN;