Sounds like you may have an out-of-sync issue with your SYSTEM.CATALOG. What version of Phoenix were you using before you tried the 4.1 RC? Is this the 4.1 RC1? Did you upgrade from an earlier Phoenix version, as the IS_VIEW_REFERENCED was added in the 3.0/4.0 release, I believe? If you upgraded, did you upgrade to each minor release in order so that the SYSTEM.CATALOG table was upgraded.
One workaround (if this is feasible for you) is to disable and drop the SYSTEM.CATALOG table from an HBase shell, and then re-run your DDL command to re-create your tables again. This won't affect your HBase data, though your indexes would be rebuilt from scratch. Thanks, James On Wed, Aug 27, 2014 at 12:54 PM, Mike Friedman <[email protected]> wrote: > Hi, > > > > We are wondering if anyone has seen this error running sqlline of Phoenix > 4.1RC and what a solution or workaround might be. Thanks. - Mike > > > > > > 14/08/27 09:09:59 WARN util.NativeCodeLoader: Unable to load native-hadoop > library for your platform... using builtin-java classes where applicable > > 14/08/27 09:10:00 WARN impl.MetricsConfig: Cannot locate configuration: > tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties > > 14/08/27 09:10:01 WARN query.ConnectionQueryServicesImpl: > addColumnsIfNotExists failed due > to:org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): > Undefined column. columnName=IS_VIEW_REFERENCED > > Error: ERROR 504 (42703): Undefined column. columnName=IS_VIEW_REFERENCED > (state=42703,code=504) > > org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): > Undefined column. columnName=IS_VIEW_REFERENCED > > at > org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:516) > > at > org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:264) > > at > org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:332) > > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:448) > > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:439) > > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:255) > > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:248) > > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:246) > > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:192) > > at > org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:147) > > at > org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:152) > > at > org.apache.phoenix.schema.MetaDataClient.addColumnMutation(MetaDataClient.java:391) > > at > org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:1732) > > at > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:689) > > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:256) > > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:248) > > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:246) > > at > org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:960) > > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.addColumnsIfNotExists(ConnectionQueryServicesImpl.java:1465) > > at > org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1526) > > at > org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489) > > at > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) > > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489) > > at > org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162) > > at > org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129) > > at > org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133) > > at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650) > > at > sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701) > > at sqlline.SqlLine$Commands.connect(SqlLine.java:3942) > > at sqlline.SqlLine$Commands.connect(SqlLine.java:3851) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810) > > at sqlline.SqlLine.dispatch(SqlLine.java:817) > > at sqlline.SqlLine.initArgs(SqlLine.java:633) > > at sqlline.SqlLine.begin(SqlLine.java:680) > > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) > > at sqlline.SqlLine.main(SqlLine.java:424) > > sqlline version 1.1.2 > >
