bq. my h-base-site.xml Seems to be typo above - did you mean hbase-site.xml ?
Have you checked every region server w.r.t. the value for hbase.regionserver.wal.codec ? Cheers On Wed, Oct 12, 2016 at 3:22 PM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Hi, > > In the following "marketDataHbase" is a view on Hbase table. > > This is my h-base-site.xml (running Hbase on standalone mode) > > <property> > <name>hbase.defaults.for.version.skip</name> > <value>true</value> > </property> > <property> > <name>hbase.regionserver.wal.codec</name> > <value>org.apache.hadoop.hbase.regionserver.wal. > IndexedWALEditCodec</value> > </property> > <property> > <name>hbase.region.server.rpc.scheduler.factory.class</name> > <value>org.apache.hadoop.hbase.ipc.PhoenixRpcSchedulerFactory</value> > <description>Factory to create the Phoenix RPC Scheduler that uses > separate queues for index and metadata updates</description> > </property> > <property> > <name>hbase.rpc.controllerfactory.class</name> > <value>org.apache.hadoop.hbase.ipc.controller. > ServerRpcControllerFactory</value> > <description>Factory to create the Phoenix RPC Scheduler that uses > separate queues for index and metadata updates</description> > </property> > <property> > <name>phoenix.functions.allowUserDefinedFunctions</name> > <value>true</value> > <description>enable UDF functions</description> > </property> > > and I have restarted Hbase but still getting the below error! > 0: jdbc:phoenix:thin:url=http://rhes564:8765> create index ticker_index > on "marketDataHbase" ("ticker"); > Error: Error -1 (00000) : Error while executing SQL "create index > ticker_index on "marketDataHbase" ("ticker")": Remote driver error: > RuntimeException: java.sql.SQLException: ERROR 1029 (42Y88): Mutable > secondary indexes must have the hbase.regionserver.wal.codec property set > to org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec in the > hbase-sites.xml of every region server. tableName=TICKER_INDEX -> > SQLException: ERROR 1029 (42Y88): Mutable secondary indexes must have the > hbase.regionserver.wal.codec property set to org.apache.hadoop.hbase. > regionserver.wal.IndexedWALEditCodec in the hbase-sites.xml of every > region server. tableName=TICKER_INDEX (state=00000,code=-1) > > Thanks > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > >
