I need to restore specific table from archive.
i did First : Rename table XXX.table1 to XXX.table2;
after that create a table with the name "xxx.table1" successfully.
Now, we need to restore the data from archive.
Error : table id doesn't match for dbs.
Can any one tell me the best restore process. Please.
To use RESTORE, leave the original table alone; if you want a backup of the contents, make a new backup table.
If you create a new target table, you must (re)GRANT any the access rights held on the original, and use COPY command instead of RESTORE.