Is your feature request related to a problem? Please describe.
Right now EXPORT PART/PARTITION exports all rows from part/partition.
Sometimes its required to export specific rows only from part/partition which match to some criteria.
For example: export all rows where "is_deleted<>True"
Describe the solution you'd like
Add ability to add WHERE condition to ALTER TABLE EXPORT PART statement.
Something like
ALTER TABLE<> EXPORT PART WHERE customer_id>0 AND is_deleted<>True;
Is your feature request related to a problem? Please describe.
Right now EXPORT PART/PARTITION exports all rows from part/partition.
Sometimes its required to export specific rows only from part/partition which match to some criteria.
For example: export all rows where "is_deleted<>True"
Describe the solution you'd like
Add ability to add WHERE condition to ALTER TABLE EXPORT PART statement.
Something like
ALTER TABLE<> EXPORT PART WHERE customer_id>0 AND is_deleted<>True;