Hi Experts,
We are exporting a partitioned table from a database and want to import the table onto another database. In source database we have 5 partitions and all partitions having data, except default one. In the target database, we started inserting records, so , two new partitions created,which not exist in source database.
Now, we are importing the source data onto the target database table ,since we don't want to lose existing data, so, using table_exists_actions =append, but, all data from the source database got inserted into the default partition of the target table. Wonder, what can be done, so that instead of getting all source data inserted into default partition of the target, the partitions of source table should get created in the target table as well, without loosing existing data.