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.

Comments

Popular posts from this blog

SQL for Quantile Function in Teradata

3 Uses of SAMPLE function in Teradata

All You Need NULL Value Functions