THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Code Block |
|---|
alter table <T> (schema) not skewed;
{code>
|
The
...
above
...
will
...
- turn
...
- off
...
- "skewed"
...
- feature
...
- from
...
- a
...
- table
...
- and
...
- make
...
- a
...
- table
...
- non-skewed.
...
It
...
won't
...
- impact
...
- partitions
...
- created
...
- before
...
- the
...
- alter
...
- statement
...
- only
...
- impact
...
- partitions
...
- created
...
- afterwards.
| Code Block |
|---|
alter table <T> (schema) set skewed location (key1="loc1", key2="loc2") |
...
|
Design
When such a table is being loaded, it would be good to create a sub-directory per skewed key. The infrastructure similar to dynamic partitions can be used.
Alter table <T> partition <P> concatenate; needs to be changed to merge files per directory