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: [email protected] [[email protected]] 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:[email protected]> Date: 2014-11-25 01:46 To: [email protected]<mailto:[email protected]> 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, [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> 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
