phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rajeshbabu chintaguntla <rajeshbabu.chintagun...@huawei.com>
Subject RE: Re: local index creation catch error with specifying DEFAULT_COLUMN_FAMILY when creating data table
Date Tue, 25 Nov 2014 14:27:05 GMT
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<mailto:chrajeshbabu32@gmail.com>
Date: 2014-11-25 01:46
To: user@phoenix.apache.org<mailto: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<mailto:sunfl@certusnet.com.cn>
<sunfl@certusnet.com.cn<mailto: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




Mime
View raw message