[
https://issues.apache.org/jira/browse/PHOENIX-1484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233195#comment-14233195
]
James Taylor commented on PHOENIX-1484:
---------------------------------------
Would you mind adding to your test for the case of without having the
DEFAULT_COLUMN_FAMILY='f' declaration on the CREATE INDEX call, like this?
{code}
+ statement
+ .execute("create local index my_idx2 on example (fn)");
{code}
+1 after that. Thanks for the patch, [~rajesh23].
> Index creation failed due to specifying DEFAULT_COLUMN_FAMILY option
> --------------------------------------------------------------------
>
> Key: PHOENIX-1484
> URL: https://issues.apache.org/jira/browse/PHOENIX-1484
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.2
> Environment: HBase 0.98.6-cdh5.2.0
> Reporter: Sun Fulin
> Assignee: rajeshbabu
> Attachments: PHOENIX-1484.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
