The SQL strategy build a MIRROR table on the RIGHT cluster that points to the LEFT storage. Only the table definition is used to create the table. If the table has partitions, the MSCK REPAIR issued to discover them before the transfer, won't link the data.
The SQL strategy build a MIRROR table on the RIGHT cluster that points to the LEFT storage. Only the table definition is used to create the table. If the table has partitions, the MSCK REPAIR issued to discover them before the transfer, won't link the data.
Hence the transfer will NOT be complete.