You could also take a snapshot in hbase just prior to the drop table, then restore it afterward.
> On Feb 24, 2016, at 12:25 PM, Steve Terrell <[email protected]> wrote: > > Thanks for your quick and accurate responses! > >> On Wed, Feb 24, 2016 at 1:18 PM, Ankit Singhal <[email protected]> >> wrote: >> Yes, data will be deleted during drop table command and currently there is >> no parameter to control that. You may raise a jira for this. >> >> A workaround you may try is by opening a connection at a timestamp a little >> greater than last modified timestamp of table and then run drop table >> command. but remember you may still loose some data inserted before that >> timestamp >> >> Regards, >> Ankit Singhal >> >>> On Wed, Feb 24, 2016 at 11:27 PM, Steve Terrell <[email protected]> >>> wrote: >>> Good idea! >>> >>> I was using SQuirreL Client, and I did put the hbase-site.xml in the same >>> directory as the driver jar. However, I did not know how to check to see >>> that the property was being found. >>> >>> So, I switched to using the sqlline query command line, and this time the >>> table remained in the hbase shell list after I dropped it in Phoenix. So, >>> when using sqlline I am sure that the property is being picked up. I'll >>> worry about SQuirreL another day. >>> >>> Now I have a new problem: Even though the table still exists in HBase, the >>> data that I had upserted into the table via Phoenix does not show up when I >>> scan it in hbase shell. Looks like the drop table in Phoenix also deleted >>> my rows in HBase. >>> >>> Is there a way to drop the Phoenix table without the rows in HBase being >>> deleted? >>> >>> Thank you, >>> Steve >>> >>> >>>> On Wed, Feb 24, 2016 at 11:42 AM, Ankit Singhal <[email protected]> >>>> wrote: >>>> Hi Steve, >>>> >>>> can you check whether the properties are picked by the sql/application >>>> client. >>>> >>>> Regards, >>>> Ankit Singhal >>>> >>>>> On Wed, Feb 24, 2016 at 11:09 PM, Steve Terrell <[email protected]> >>>>> wrote: >>>>> HI, I hope someone can tell me what I'm doing wrong… >>>>> >>>>> I set phoenix.schema.dropMetaData to false in hbase-site.xml on both the >>>>> client and server side. >>>>> >>>>> I restarted the HBase master service. >>>>> >>>>> I used Phoenix to create a table and upsert some values. >>>>> >>>>> I used Phoenix to drop the table. >>>>> >>>>> I expected the table to still exist when I went into hbase shell and did >>>>> a list, but the table apparently was dropped from HBase as well. >>>>> >>>>> Did I miss something? >>>>> >>>>> Thank you, >>>>> Steve >
