phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeffrey Zhong <>
Subject Re: Issue with disabling phoenix global index in lowercase
Date Wed, 12 Nov 2014 04:46:34 GMT

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.


From:  Vamsi Krishna <>
Reply-To:  <>
Date:  Tuesday, November 11, 2014 at 4:49 PM
To:  <>
Subject:  Issue with disabling phoenix global index in lowercase


I'm working with HDP 2.2.


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

Note: Same scenario works fine when I create the namespace, table name,
index name in UPPERCASE.

Vamsi Krishna Attluri

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.

View raw message