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. When I try to create a local index on table 'TABLE1', i'm seeing an error. Please refer to the sequence of events, commands & error in the below table. You can also find the full stacktrace at the bottom of the email. 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 local index "TEST:TABLE1INDX2" on "TEST:TABLE1"(colfam1.col3 desc); Error: org.apache.hadoop.hbase.NamespaceNotFoundException: _LOCAL_IDX_TEST Detailed Stacktrace: *Error: org.apache.hadoop.hbase.NamespaceNotFoundException: _LOCAL_IDX_TEST* * at org.apache.hadoop.hbase.master.HMaster.getNamespaceDescriptor(HMaster.java:3332)* * at org.apache.hadoop.hbase.master.HMaster.createTable(HMaster.java:1781)* * at org.apache.hadoop.hbase.master.HMaster.createTable(HMaster.java:1911)* * at org.apache.hadoop.hbase.protobuf.generated.MasterProtos$MasterService$2.callBlockingMethod(MasterProtos.java:40470)* * at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2078)* * at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108)* * at org.apache.hadoop.hbase.ipc.FifoRpcScheduler$1.run(FifoRpcScheduler.java:74)* * at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)* * at java.util.concurrent.FutureTask.run(FutureTask.java:262)* * at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)* * at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)* * at java.lang.Thread.run(Thread.java:745) (state=08000,code=101)* Thanks, Vamsi.
