phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ethan Wang (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-3837) Unable to set property on an index with Alter statement
Date Tue, 28 Nov 2017 21:32:00 GMT

    [ 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)

Mime
View raw message