Versions Compared

Old Version 14

changes.mady.by.user Namit Jain

Saved on

compared with

New Version 15

changes.mady.by.user Namit Jain

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

== Dependent Tables ==
Create a table which explicitly depends on another table. Consider the following scenario for the first use case mentioned:

Code Block

create table T (key string, value string) partitioned by (ds string, hr string);

-- create a dependent table which specifies the dependencies explicitly
-- Tdep inherits the schema of T
-- Tdep is partitioned by a prefix of T (either ds or ds,hr)
create dependent table Tdep partitioned by (ds string) depends on table T;

In order to denote the end of a daily partition for T, the corresponding partition is added in Tdep

Code Block

-- create partition T@ds=1/hr=1 to T@ds=1/hr=24
alter table Tdep add partition (ds=1);