Skip to content

Instantly share code, notes, and snippets.

@shivallan

shivallan/CTAS_partition

Created August 24, 2015 14:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save shivallan/c173a58ba533e1fbc8ba to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save shivallan/c173a58ba533e1fbc8ba to your computer and use it in GitHub Desktop.
Download ZIP
Создание таблицы через select + партиции по дате
Raw
CTAS_partition
create table TEST_PARTITION
partition by range (CREATE_DTTM) (
partition part_Aug2015 values less than (to_date('01-SEP-2015', 'DD-MON-YYYY')),
partition part_Sep2015 values less than (to_date('01-OCT-2015', 'DD-MON-YYYY')),
partition part_Oct2015 values less than (to_date('01-NOV-2015', 'DD-MON-YYYY')),
partition part_Nov2015 values less than (to_date('01-DEC-2015', 'DD-MON-YYYY'))
) as
(
select *
from INT_OFFER.INT_CMFRONT_CHANNEL_PARAMS@OFFERDB_LINK_WRITER where 1=0
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment