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