phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Batyrshin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3478) UPDATE STATISTICS SET syntax error
Date Fri, 11 Nov 2016 22:33:58 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alex Batyrshin updated PHOENIX-3478:
------------------------------------
    Description: 
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.

  was:
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.


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

Mime
View raw message