[jira] [Commented] (PHOENIX-3837) Unable to set property on an index with Alter statement

["Geoffrey Jacoby (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-3837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16170695#comment-16170695 ] 

Geoffrey Jacoby commented on PHOENIX-3837:
------------------------------------------

This is important for more than just guideposts. For example, if in creating an immutable global index, you forget to set the replication scope or ttl (or you later want to change them), there's no way to do so without going down to the HBase level. 

> Unable to set property on an index with Alter statement
> -------------------------------------------------------
>
>                 Key: PHOENIX-3837
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3837
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.10.0
>            Reporter: Mujtaba Chohan
>            Priority: Minor
>             Fix For: 4.12.0
>
>
> {{ALTER INDEX IDX_T ON T SET GUIDE_POSTS_WIDTH=1}}
> {noformat}
> Error: ERROR 601 (42P00): Syntax error. Encountered "SET" at line 1, column 102. (state=42P00,code=601)
> org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered "SET" at line 1, column 102.
> at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
> at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
> at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1299)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)