Hi,
I'm new to Phoenix and trying it right now. I had installed it as Parcel in
Cloudera 5.4.
I'm planning to use it with an already existant Hbase table (other systems use
it and I can't recreate it). I see that I can create it without problem with
the CREATE TABLE command.
But in case I need to DROP the table afterwards (only from Phoenix), is there
any way to avoid removing the table also from Hbase? Cause I tried the DROP
TABLE command and the table is removed despite setting the
phoenix.schema.dropMetaData property in Phoenix hbase-site.xml with true or
false.
I'm using Phoenix from command line
(/opt/cloudera/parcels/CLABS_PHOENIX-4.3.0-1.clabs_phoenix1.0.0.p0.78/lib/phoenix/bin/sqlline.py)
and I set the property in
/opt/cloudera/parcels/CLABS_PHOENIX-4.3.0-1.clabs_phoenix1.0.0.p0.78/lib/phoenix/bin/hbase-site.xml.
I also see that Phoenix add an extra column (named _0) with an empty value in
my column family. Is there any way to avoid that?
Thanks in advance,