[ https://issues.apache.org/jira/browse/PHOENIX-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15342152#comment-15342152 ]
Rajeshbabu Chintaguntla commented on PHOENIX-3002: -------------------------------------------------- [~jamestaylor] [~samarthjain] In the upgrade we drop the index and recreate the index while creating index it's expecting IS_NAMESPACE_MAPPED when NO_UPGRADE attribute used in PhoenixRuntime(After PHOENIX-3016). So it would be better to go by configuration. Wdyt? {noformat} 16/06/21 22:21:22 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=IS_NAMESPACE_MAPPED at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:694) at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:449) at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:394) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:593) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:581) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:336) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:329) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:250) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2295) at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1458) at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:329) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440) at org.apache.phoenix.util.UpgradeUtil.upgradeLocalIndexes(UpgradeUtil.java:428) at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:250) {noformat} > Upgrading to 4.8 doesn't recreate local indexes > ----------------------------------------------- > > Key: PHOENIX-3002 > URL: https://issues.apache.org/jira/browse/PHOENIX-3002 > Project: Phoenix > Issue Type: Bug > Reporter: Samarth Jain > Assignee: Rajeshbabu Chintaguntla > Priority: Blocker > Fix For: 4.8.0 > > Attachments: PHOENIX-3002.patch, PHOENIX-3002_v0.patch, > PHOENIX-3002_v1.patch, PHOENIX-3002_v2.patch > > > [~rajeshbabu] - I noticed that when upgrading to 4.8, local indexes created > with 4.7 or before aren't getting recreated with the new local indexes > implementation. I am not seeing the metadata rows for the recreated indices > in SYSTEM.CATALOG. -- This message was sent by Atlassian JIRA (v6.3.4#6332)