Member since
05-24-2022
1
Post
0
Kudos Received
0
Solutions
05-24-2022
06:07 AM
Is there any way in Kudu, dynamic partitions can be created which can automatically add new partition when the new date(month) is available. e.g. in the above post RANGE(year)
(
PARTITION VALUE = (2017),
PARTITION VALUE = (2018),
PARTITION VALUE = (2019),
PARTITION VALUE = (2020)
) Values after 2020 will get rejected, any workaround so create partitions based on interval PARTITION BY RANGE (MY_DATE) INTERVAL( NUMTODSINTERVAL(1,'YEAR')) -- Syntax from a famous relational DB
... View more