[
https://issues.apache.org/jira/browse/PHOENIX-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15663468#comment-15663468
]
Ankit Singhal commented on PHOENIX-3478:
----------------------------------------
you need to use quotes if you have SQL reserved characters(like ".") in your
property name(https://phoenix.apache.org/language/index.html#name).
{code}
UPDATE STATISTICS my_table SET "phoenix.stats.guidepost.width"=50000000
{code}
Let me see If I can update documentation to represent this better.
> UPDATE STATISTICS SET syntax error
> ----------------------------------
>
> Key: PHOENIX-3478
> URL: https://issues.apache.org/jira/browse/PHOENIX-3478
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.1
> Reporter: Alex Batyrshin
> Priority: Minor
>
> According to
> [documentation|https://phoenix.apache.org/language/index.html#update_statistics]
> example:
> bq. UPDATE STATISTICS my_table SET phoenix.stats.guidepost.width=50000000
> And this is real world:
> {code}
> 0: jdbc:phoenix:> UPDATE STATISTICS "xxxxxxxxxxxxxxxxxxx" SET
> phoenix.stats.guidepost.width=30000000;
> Error: ERROR 604 (42P00): Syntax error. Mismatched input. Expecting "EQ", got
> "." at line 1, column 52. (state=42P00,code=604)
> {code}
> Looks like SET parameter should be quoted.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
