Thanks for the reply Alicia. Do you know if this feature 'creating local indexes in non-default namespaces' is on the RoadMap? Is there any page which I can keep tracking to see when this feature will be implemented?
Vamsi Attluri. On Tue, Nov 11, 2014 at 11:40 PM, Alicia Shu <a...@hortonworks.com> wrote: > Currently local index can only be created in default namespace. > > Alicia > > On Tue, Nov 11, 2014 at 3:30 PM, Vamsi Krishna <vamsi.attl...@gmail.com> > wrote: > >> 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. >> > > > 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.
