CREATE FROM SELECT scenario : provide the local and remote "rename" operation