phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: sqlline error with Phoenix 4.1
Date Wed, 27 Aug 2014 20:43:49 GMT
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 <Mike.Friedman@ds-iq.com> 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
>
>

Mime
View raw message