Hello Vamsi,
First of all, when you create/alter index, please don¹t pass in schema for
index table name otherwise it will treat as part of the index table name.
Phoenix will automatically use data table schema name for the newly created
index table.
In addition, the issue you found is a bug and I¹ll create a JIRA on this.
Basically we double normalized the index table name so the index table name
becomes uppercase.
Thanks,
-Jeffrey
From: Vamsi Krishna <vamsi.attl...@gmail.com>
Reply-To: <user@phoenix.apache.org>
Date: Tuesday, November 11, 2014 at 4:49 PM
To: <user@phoenix.apache.org>
Subject: Issue with disabling phoenix global index in lowercase
Hi,
I'm working with HDP 2.2.
Hadoop: 2.6.0.2.2.0.0-1084
HBase: 0.98.4.2.2.0.0-1084-hadoop2
Phoenix: 4.2
I created namespace 'test' in HBase.
I created a table 'table1' in Phoenix under namespace 'test' in HBase.
I created a global index 'table1indx1' on table 'table1'.
When I try to disable the index 'table1indx1', I'm seeing an error.
Please refer to the sequence of events, commands & error in the below table.
Please help me resolve this issue.
Hbase shell Phoenix command line interface
Command Error
create_namespace 'test'
create table "test:table1" (col1 varchar primary key, colfam1.col2
varchar, colfam1.col3 varchar);
create index "test:table1indx1" on "test:table1"(colfam1.col3 desc);
alter index "test:table1indx1" on "test:table1" disable; Error:
ERROR 1012 (42M03): Table undefined. tableName=TEST:TABLE1INDX1
(state=42M03,code=1012)
Note: Same scenario works fine when I create the namespace, table name,
index name in UPPERCASE.
Thanks,
Vamsi Krishna Attluri
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
