You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn> on 2014/11/24 08:07:58 UTC
local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi,all
When creating data table with specifying DEFAULT_COLUMN_FAMILY='F', and then trying to create
local index on the table specifying column, we got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
Without specifying the options of DEFAULT_COLUMN_FAMILY, there are no such errors.
Quite confused about this exception and hope someone can suggests me kindly.
Thanks,
Sun.
CertusNet
Re: RE: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Posted by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>.
Hi Rajeshbabu
I filed JIRA as following:
https://issues.apache.org/jira/browse/PHOENIX-1484
Please kindly take your considerations.
Thanks,
Sun.
CertusNet
From: rajeshbabu chintaguntla
Date: 2014-11-25 22:27
To: sunfl@certusnet.com.cn; user
Subject: RE: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi Sun,
It's bug only. Please raise JIRA for this. if we pass DEFAULT_COLUMN_FAMILY as table property while creating local index it's failing because it's considering as view index which will not accept any table properties. I have tried without DEFAULT_COLUMN_FAMILY property and working fine.
Thanks,
Rajeshbabu.
This e-mail and its attachments contain confidential information from HUAWEI, which
is intended only for the person or entity whose address is listed above. Any use of the
information contained herein in any way (including, but not limited to, total or partial
disclosure, reproduction, or dissemination) by persons other than the intended
recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by
phone or email immediately and delete it!
From: sunfl@certusnet.com.cn [sunfl@certusnet.com.cn]
Sent: Tuesday, November 25, 2014 7:47 AM
To: user; rajeshbabu chintaguntla
Subject: Re: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi, Rajeshbabu
Thanks for your reply. My cluster contains hbase 0.98.6-cdh5.2.0, with the latest phoenix 4.2 release.
I tryied again with phoenix 4.1 version and still got the exception. Following is my statements:
1 create table example (id integer not null,fn varchar,ln varchar constraint pk primary key(id)) DEFAULT_COLUMN_FAMILY='F';
Notice that I would like to create default mutable index for the table.
2 create local index my_idx on example (fn) DEFAULT_COLUMN_FAMILY='F';
Here no matter with or without specifying DEFAULT_COLUMN_FAMILY options we would always got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
3 I also tried to create local index with immutable rows setting true, however, I still got the above error.
Corrects me if I am doing the wrong way.
Thanks,
Sun.
CertusNet
From: rajesh babu Chintaguntla
Date: 2014-11-25 01:46
To: user@phoenix.apache.org
Subject: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi Sun,
I have tried it and working fine for me.
Can you please provide exact statements and version of HBase and Phoenix?
Thanks,
Rajeshbabu.
On Mon, Nov 24, 2014 at 12:37 PM, sunfl@certusnet.com.cn <su...@certusnet.com.cn> wrote:
Hi,all
When creating data table with specifying DEFAULT_COLUMN_FAMILY='F', and then trying to create
local index on the table specifying column, we got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
Without specifying the options of DEFAULT_COLUMN_FAMILY, there are no such errors.
Quite confused about this exception and hope someone can suggests me kindly.
Thanks,
Sun.
CertusNet
RE: Re: local index creation catch error with specifying
DEFAULT_COLUMN_FAMILY when creating data table
Posted by rajeshbabu chintaguntla <ra...@huawei.com>.
Hi Sun,
It's bug only. Please raise JIRA for this. if we pass DEFAULT_COLUMN_FAMILY as table property while creating local index it's failing because it's considering as view index which will not accept any table properties. I have tried without DEFAULT_COLUMN_FAMILY property and working fine.
Thanks,
Rajeshbabu.
________________________________
This e-mail and its attachments contain confidential information from HUAWEI, which
is intended only for the person or entity whose address is listed above. Any use of the
information contained herein in any way (including, but not limited to, total or partial
disclosure, reproduction, or dissemination) by persons other than the intended
recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by
phone or email immediately and delete it!
________________________________
From: sunfl@certusnet.com.cn [sunfl@certusnet.com.cn]
Sent: Tuesday, November 25, 2014 7:47 AM
To: user; rajeshbabu chintaguntla
Subject: Re: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi, Rajeshbabu
Thanks for your reply. My cluster contains hbase 0.98.6-cdh5.2.0, with the latest phoenix 4.2 release.
I tryied again with phoenix 4.1 version and still got the exception. Following is my statements:
1 create table example (id integer not null,fn varchar,ln varchar constraint pk primary key(id)) DEFAULT_COLUMN_FAMILY='F';
Notice that I would like to create default mutable index for the table.
2 create local index my_idx on example (fn) DEFAULT_COLUMN_FAMILY='F';
Here no matter with or without specifying DEFAULT_COLUMN_FAMILY options we would always got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
3 I also tried to create local index with immutable rows setting true, however, I still got the above error.
Corrects me if I am doing the wrong way.
Thanks,
Sun.
________________________________
________________________________
CertusNet
From: rajesh babu Chintaguntla<ma...@gmail.com>
Date: 2014-11-25 01:46
To: user@phoenix.apache.org<ma...@phoenix.apache.org>
Subject: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi Sun,
I have tried it and working fine for me.
Can you please provide exact statements and version of HBase and Phoenix?
Thanks,
Rajeshbabu.
On Mon, Nov 24, 2014 at 12:37 PM, sunfl@certusnet.com.cn<ma...@certusnet.com.cn> <su...@certusnet.com.cn>> wrote:
Hi,all
When creating data table with specifying DEFAULT_COLUMN_FAMILY='F', and then trying to create
local index on the table specifying column, we got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
Without specifying the options of DEFAULT_COLUMN_FAMILY, there are no such errors.
Quite confused about this exception and hope someone can suggests me kindly.
Thanks,
Sun.
________________________________
________________________________
CertusNet
Re: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Posted by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>.
Hi, Rajeshbabu
Thanks for your reply. My cluster contains hbase 0.98.6-cdh5.2.0, with the latest phoenix 4.2 release.
I tryied again with phoenix 4.1 version and still got the exception. Following is my statements:
1 create table example (id integer not null,fn varchar,ln varchar constraint pk primary key(id)) DEFAULT_COLUMN_FAMILY='F';
Notice that I would like to create default mutable index for the table.
2 create local index my_idx on example (fn) DEFAULT_COLUMN_FAMILY='F';
Here no matter with or without specifying DEFAULT_COLUMN_FAMILY options we would always got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
3 I also tried to create local index with immutable rows setting true, however, I still got the above error.
Corrects me if I am doing the wrong way.
Thanks,
Sun.
CertusNet
From: rajesh babu Chintaguntla
Date: 2014-11-25 01:46
To: user@phoenix.apache.org
Subject: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Hi Sun,
I have tried it and working fine for me.
Can you please provide exact statements and version of HBase and Phoenix?
Thanks,
Rajeshbabu.
On Mon, Nov 24, 2014 at 12:37 PM, sunfl@certusnet.com.cn <su...@certusnet.com.cn> wrote:
Hi,all
When creating data table with specifying DEFAULT_COLUMN_FAMILY='F', and then trying to create
local index on the table specifying column, we got the following error:
Error: ERROR 1009 (42L02): Properties may not be defined for a view. (state=42L02,code=1009)
Without specifying the options of DEFAULT_COLUMN_FAMILY, there are no such errors.
Quite confused about this exception and hope someone can suggests me kindly.
Thanks,
Sun.
CertusNet
Re: local index creation catch error with specifying
DEFAULT_COLUMN_FAMILY when creating data table
Posted by rajesh babu Chintaguntla <ch...@gmail.com>.
Hi Sun,
I have tried it and working fine for me.
Can you please provide exact statements and version of HBase and Phoenix?
Thanks,
Rajeshbabu.
On Mon, Nov 24, 2014 at 12:37 PM, sunfl@certusnet.com.cn <
sunfl@certusnet.com.cn> wrote:
> Hi,all
> When creating data table with specifying DEFAULT_COLUMN_FAMILY='F', and
> then trying to create
> local index on the table specifying column, we got the following error:
> Error: ERROR 1009 (42L02): Properties may not be defined for a view.
> (state=42L02,code=1009)
> Without specifying the options of DEFAULT_COLUMN_FAMILY, there are no such
> errors.
>
> Quite confused about this exception and hope someone can suggests me
> kindly.
> Thanks,
> Sun.
>
> ------------------------------
> ------------------------------
>
> CertusNet
>
>
>