Sunday, 1 February 2015

What is columnar table in Teradata best example

What is columnar table in Teradata best example
#What is columnar table in Teradata best example:
What is columnar table in Teradata?

Let me give an example.

Create table samples.test_1(name varchar (10), id integer )
no primary index;

This table we also call it as NOPI table.

Two rules for columnar table.
  • Table must be multiset table
  • It should be NOPI table
Additional Points on columnar tables:
  • Columnar Tables allow Columns to be Partitioned.
  • An AMP still holds the entire row, but partitions vertically.
  • Columns are placed inside their own individual Container.

No comments:

Post a Comment

Featured post

5 Top Teradata DATE functions to read now

The following are the list of DATE functions. These are very frequently being used in Teradata. The following statement requests the cur...

Popular Posts