1) Take table snapshot of hbase table 2) drop phoenix table 3) restore back the hbase snapshot
Now there will be a table in hbase. Thanks Sandeep ᐧ On Thu, Feb 25, 2016 at 6:41 AM, Jonathan Leech <[email protected]> wrote: > 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 >>>>> >>>> >>>> >>> >> > -- * Regards* * Sandeep Nemuri*
