[
https://issues.apache.org/jira/browse/PHOENIX-3837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16240769#comment-16240769
]
Ethan Wang edited comment on PHOENIX-3837 at 11/28/17 9:31 PM:
---------------------------------------------------------------
1, So the syntax will be
bq. ALTER INDEX LOCAL_ADDRESS ON PERSON ACTIVE GUIDE_POSTS_WIDTH = 20
bq. ALTER INDEX LOCAL_ADDRESS ON PERSON ACTIVE SET GUIDE_POSTS_WIDTH = 20
2, I'm also storing PTableType in AlterIndexStatement (i.e., PTableType.INDEX),
as it is needed later on when inserting into catalog, when they inserting a new
row with a new seqnum, they need table typle.
3, I assume both Phoenix and Hbase properties (e.g., TTL) will likely be
allowed through this correct?
[~giacomotaylor]
was (Author: aertoria):
1, So the syntax will be
bq. ALTER INDEX LOCAL_ADDRESS ON PERSON ACTIVE GUIDE_POSTS_WIDTH = 20
bq. ALTER INDEX LOCAL_ADDRESS ON PERSON SET GUIDE_POSTS_WIDTH = 20
2, I'm also storing PTableType in AlterIndexStatement (i.e., PTableType.INDEX),
as it is needed later on when inserting into catalog, when they inserting a new
row with a new seqnum, they need table typle.
3, I assume both Phoenix and Hbase properties (e.g., TTL) will likely be
allowed through this correct?
[~giacomotaylor]
> 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
> Assignee: Ethan Wang
> Fix For: 4.14.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)
