You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Mich Talebzadeh <mi...@gmail.com> on 2016/10/12 22:22:31 UTC
Creating secondary index on Phoenix view on Hbase table throws error
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.
Re: Creating secondary index on Phoenix view on Hbase table throws error
Posted by Mich Talebzadeh <mi...@gmail.com>.
This works when the index is created in phoenix server as opposed to
phoenix client.
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.
On 12 October 2016 at 23:38, Mich Talebzadeh <mi...@gmail.com>
wrote:
> 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 <yu...@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.
>>>
>>>
>>>
>>
>>
>
Re: Creating secondary index on Phoenix view on Hbase table throws error
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <yu...@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.
>>
>>
>>
>
>
Re: Creating secondary index on Phoenix view on Hbase table throws error
Posted by Ted Yu <yu...@gmail.com>.
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 <mi...@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.
>
>
>