phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-1160) Allow an index to be declared as immutable
Date Thu, 15 Feb 2018 20:46:00 GMT


James Taylor commented on PHOENIX-1160:

We should also fix PHOENIX-4612 by just disallowing the immutability of a table to change.
Otherwise, we wouldn't know if an index was declared as immutable or if its data table was
declared as immutable.

> Allow an index to be declared as immutable
> ------------------------------------------
>                 Key: PHOENIX-1160
>                 URL:
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: James Taylor
>            Priority: Major
> Currently, a table must be marked as immutable, through the IMMUTABLE_ROWS=true property
specified at creation time. In this case, all indexes added to the table are immutable, while
without this property, all indexes are mutable.
> Instead, we should support a mix of immutable and mutable indexes. We already have an
INDEX_TYPE field on our metadata row. We can add a new IMMUTABLE keyword and specify an index
is immutable like this:
> {code}
> CREATE IMMUTABLE INDEX foo ON bar(c2, c1);
> {code}
> It would be up to the application developer to ensure that only columns that don't mutate
are part of an immutable index (we already rely on this anyway).

This message was sent by Atlassian JIRA

View raw message