THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
== 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);
|