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: [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]
<[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
