...
The operation fails in the presence of an index.
Exchange partition is not allowed with transactional tables either as source or destination. Alternatively, shall use use LOAD DATA or INSERT OVERWRITE commands to move partitions across transactional tables.
This command requires both the source and destination table names to have the same table schema.
If the schemas are different, the following exception is thrown:The tables have different schemas. Their partitions cannot be exchanged
...