phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Creating secondary index on Phoenix view on Hbase table throws error
Date Wed, 12 Oct 2016 22:38:15 GMT
Yes correct that is hbase-site.xml Ted.

i am running Hbase in standalone mode. Do I need region server?

thx

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.



On 12 October 2016 at 23:25, Ted Yu <yuzhihong@gmail.com> wrote:

> 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.talebzadeh@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.IndexedWALEd
>> itCodec</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.ServerRpcContr
>> ollerFactory</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.
>>
>>
>>
>
>

Mime
View raw message