Hi Yuan, Yes, I encourage you to file a JIRA. We have to include TDDL table as well as part of cleanat.
In the mean time as a work around, please drop the table from hbase shell explicitly and you should be able to continue with offline restore. Regards, Prashanth From: Liu, Yuan (Yuan) [mailto:[email protected]] Sent: Thursday, May 25, 2017 9:33 PM To: [email protected] Subject: RE: Initialize trafodion drop will not drop DTM tables Hi Sean, Thanks for your so quick response. I just tried to use cleanat, it seems that it will only drop DTM LOG. After executing cleanat, there still exists one table: TRAFODION._DTM_.TDDL So this table will not be dropped by cleanat, right? [cid:[email protected]] [cid:[email protected]] Best regards, Yuan Email: [email protected]<mailto:[email protected]> Cellphone: (+86) 13671935540 From: Sean Broeder [mailto:[email protected]] Sent: Friday, May 26, 2017 11:34 AM To: [email protected]<mailto:[email protected]> Subject: RE: Initialize trafodion drop will not drop DTM tables Hi Yuan, The reason initialize Trafodion, drop does not drop DTM tables is that the DTM is running and still using them. I'm not practiced in offline restore. Does it use scripts that don't require Trafodion to be running? Perhaps you can leverage the cleanat script as follows. initialize Trafodion, drop sqstop cleanat offline restore sqstart Regards, Sean From: Liu, Yuan (Yuan) [mailto:[email protected]] Sent: Thursday, May 25, 2017 8:28 PM To: [email protected]<mailto:[email protected]> Subject: Initialize trafodion drop will not drop DTM tables Hi Trafodioners, I found that when I did 'initialize trafodion, drop' the DTM related tables would not be dropped. Could anyone explain why this happened? For the feature of 'offline restore', we need to make sure there is no TRAFODION.* table exist in HBase, otherwise the restore will fail. So I am thinking can we have such enhancement that we drop all TRAFODION.* tables when 'initialize trafodion, drop'? Does that make sense? [cid:[email protected]] [cid:[email protected]] Best regards, Yuan Email: [email protected]<mailto:[email protected]> Cellphone: (+86) 13671935540
