I tried your code in 11.1 (includes Apache Spark 3.3.0, Scala 2.12) and it worked perfectly fine.

However it will work perfectly only the first time because if you try to rerun the same code, it'll error out stating renamed_table_name exists.

P.S: Please use code snippet(</> button) to include your code in your question