You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org> on 2016/07/08 13:33:10 UTC

[jira] [Created] (PHOENIX-3058) UpgradeUtil#disableViewIndexes not working properly for views with schema name

Rajeshbabu Chintaguntla created PHOENIX-3058:
------------------------------------------------

             Summary: 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


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)