Problem :- Due to this error you are unable to inset data into a particular table which has partitions.
Cause :- It happened because the data you are trying to insert is not in range of the partition has been created or NULL value is updated on the column which has partition.
i.e. To have partition on creation_date You must always put Date in the column which is in range and should not insert NULL.
Solution :- To solve the problem, make sure that the partitioning key column data to be inserted does not have any NULL value.
Cause :- It happened because the data you are trying to insert is not in range of the partition has been created or NULL value is updated on the column which has partition.
i.e. To have partition on creation_date You must always put Date in the column which is in range and should not insert NULL.
Solution :- To solve the problem, make sure that the partitioning key column data to be inserted does not have any NULL value.
No comments:
Post a Comment