|#What is columnar table in Teradata best example:|
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
- 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.