phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajeshbabu Chintaguntla (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-3058) UpgradeUtil#disableViewIndexes not working properly for views with schema name
Date Mon, 11 Jul 2016 04:40:11 GMT

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

Rajeshbabu Chintaguntla resolved PHOENIX-3058.
----------------------------------------------
    Resolution: Fixed

Handled this as part of PHOENIX-3002.

> UpgradeUtil#disableViewIndexes not working properly for views with schema name
> ------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3058
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3058
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Rajeshbabu Chintaguntla
>            Priority: Blocker
>             Fix For: 4.8.0
>
>
> In UpgradeUtil#disableViewIndexes we are prefixing the schema name to index than view
so ALTER INDEX parsing is failing
> {noformat}
> Error: ERROR 604 (42P00): Syntax error. Mismatched input. Expecting "ON", got "." at
line 1, column 16. (state=42P00,code=604)
> org.apache.phoenix.exception.PhoenixParserException: ERROR 604 (42P00): Syntax error.
Mismatched input. Expecting "ON", got "." at line 1, column 16.
> 	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:1285)
> 	at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1368)
> 	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1439)
> 	at org.apache.phoenix.util.UpgradeUtil.disableViewIndexes(UpgradeUtil.java:599)
> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2482)
> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2300)
> 	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
> 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2300)
> 	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:231)
> 	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:142)
> {noformat}
> Ping [~samarthjain]. Handling this as part of PHOENIX-3002



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message