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 >>>> >>> >>> >> >
